BUAD 310 EXCEL Type Flashcards.

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/64

encourage image

There's no tags or description

Looks like no tags are added yet.

65 Terms

1
New cards

Calculate the mean

=AVERAGE(range)

2
New cards

Calculate the median

=MEDIAN(range)

3
New cards

Calculate the sample standard deviation

=STDEV.S(range)

4
New cards

Find the minimum

=MIN(range)

5
New cards

Find the maximum

=MAX(range)

6
New cards

Calculate the range

=MAX(range)-MIN(range)

7
New cards

Count numeric observations

=COUNT(range)

8
New cards

Add values

=SUM(range)

9
New cards

Find the first quartile

=QUARTILE.EXC(range,1)

10
New cards

Find the third quartile

=QUARTILE.EXC(range,3)

11
New cards

Calculate the interquartile range

=QUARTILE.EXC(range,3)-QUARTILE.EXC(range,1)

12
New cards

Find the 90th percentile

=PERCENTILE.EXC(range,0.9)

13
New cards

Average values meeting multiple conditions

=AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria2)

14
New cards

Average spending in I for females in F

=AVERAGEIFS(I2:I401,F2:F401,"Female")

15
New cards

Write the general IF formula

=IF(logical_test,value_if_true,value_if_false)

16
New cards

Label spending of 150 or less Small and spending above 150 Large

=IF(I2<=150,"Small","Large")

17
New cards

Write the general COUNTIF formula

=COUNTIF(range,criteria)

18
New cards

Count people labeled Female in column F

=COUNTIF(F2:F401,"Female")

19
New cards

Count spending values greater than 150 in column I

=COUNTIF(I2:I401,">150")

20
New cards

Count values greater than the value in Q2

=COUNTIF(I2:I401,">"&Q2)

21
New cards

Write the general COUNTIFS formula

=COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2)

22
New cards

Count Small spenders who are Female

=COUNTIFS($J$2:$J$401,"Small",$F$2:$F$401,"Female")

23
New cards

Count Large spenders who are Male

=COUNTIFS($J$2:$J$401,"Large",$F$2:$F$401,"Male")

24
New cards

Count values greater than 50 and less than 100

=COUNTIFS(I2:I401,">50",I2:I401,"<100")

25
New cards

Count values between Q2 and R2, including both endpoints

=COUNTIFS(I2:I401,">="&Q2,I2:I401,"<="&R2)

26
New cards

Create a frequency distribution

=FREQUENCY(data_array,bins_array)

27
New cards

Calculate a joint probability from a table

=joint_cell_count/grand_total

28
New cards

Calculate a marginal probability from a table

=category_total/grand_total

29
New cards

Calculate P(A given B) from counts

=count_for_both_A_and_B/count_for_B

30
New cards

Calculate P(Large given Male) using 59 large males and 166 total males

=59/166

31
New cards

Calculate P(Male and Large) using 59 large males and 400 total people

=59/400

32
New cards

Find the normal probability to the left of x

=NORM.DIST(x,mean,standard_dev,TRUE)

33
New cards

Find the normal probability to the right of x

=1-NORM.DIST(x,mean,standard_dev,TRUE)

34
New cards

Find the normal probability between a and b

=NORM.DIST(b,mean,standard_dev,TRUE)-NORM.DIST(a,mean,standard_dev,TRUE)

35
New cards

Find a normal cutoff from a left-tail probability

=NORM.INV(probability,mean,standard_dev)

36
New cards

Find the 90th percentile of a normal distribution

=NORM.INV(0.90,mean,standard_dev)

37
New cards

Find the normal cutoff exceeded 5% of the time

=NORM.INV(0.95,mean,standard_dev)

38
New cards

Find P(X>b given X>a) for a normal variable, where b>a

=(1-NORM.DIST(b,mean,standard_dev,TRUE))/(1-NORM.DIST(a,mean,standard_dev,TRUE))

39
New cards

Find P(X<a given X<b) for a normal variable, where a<b

=NORM.DIST(a,mean,standard_dev,TRUE)/NORM.DIST(b,mean,standard_dev,TRUE)

40
New cards

Calculate a stock's decimal return

=(new_price-old_price)/old_price

41
New cards

Find the probability of a positive normally distributed return

=1-NORM.DIST(0,mean_return,SD_return,TRUE)

42
New cards

Find the probability a stock closes at a target price or below when returns are normal

=NORM.DIST((target_price-current_price)/current_price,mean_return,SD_return,TRUE)

43
New cards

Find the z-based margin of error for a mean

=CONFIDENCE.NORM(alpha,population_SD,n)

44
New cards

Find the t-based margin of error for a mean

=CONFIDENCE.T(alpha,sample_SD,n)

45
New cards

Find the lower confidence limit for a mean with unknown population SD

=AVERAGE(range)-CONFIDENCE.T(alpha,STDEV.S(range),COUNT(range))

46
New cards

Find the upper confidence limit for a mean with unknown population SD

=AVERAGE(range)+CONFIDENCE.T(alpha,STDEV.S(range),COUNT(range))

47
New cards

Find the lower confidence limit for a mean with known population SD

=sample_mean-CONFIDENCE.NORM(alpha,population_SD,n)

48
New cards

Find the upper confidence limit for a mean with known population SD

=sample_mean+CONFIDENCE.NORM(alpha,population_SD,n)

49
New cards

Calculate an expected count for a chi-square test

=row_total*column_total/grand_total

50
New cards

Calculate the chi-square test p-value

=CHISQ.TEST(observed_range,expected_range)

51
New cards

Calculate pooled variance for two independent samples assuming equal variances

=((n1-1)s1^2+(n2-1)s2^2)/(n1+n2-2)

52
New cards

Calculate the standard error of a difference using pooled variance

=SQRT(pooled_variance*(1/n1+1/n2))

53
New cards

Calculate the pooled two-sample t statistic

=((mean1-mean2)-null_difference)/SQRT(pooled_variance*(1/n1+1/n2))

54
New cards

Calculate degrees of freedom for a pooled two-sample t test

=n1+n2-2

55
New cards

Find the positive t critical value for a two-sided confidence interval

=T.INV(1-alpha/2,df)

56
New cards

Find the positive t critical value for a 95% confidence interval

=T.INV(0.975,df)

57
New cards

Calculate the margin of error for a pooled two-sample mean difference

=T.INV(1-alpha/2,n1+n2-2)SQRT(pooled_variance(1/n1+1/n2))

58
New cards

Find the lower confidence limit for a difference in means

=(mean1-mean2)-margin_of_error

59
New cards

Find the upper confidence limit for a difference in means

=(mean1-mean2)+margin_of_error

60
New cards

Calculate a square root

=SQRT(number)

61
New cards

Calculate an absolute value

=ABS(number)

62
New cards

Calculate correlation

=CORREL(x_range,y_range)

63
New cards

Predict Y using a regression equation

=intercept+slope*x

64
New cards

Calculate the approximate 95% prediction interval lower limit used in class

=predicted_y-2*model_standard_error

65
New cards

Calculate the approximate 95% prediction interval upper limit used in class

=predicted_y+2*model_standard_error