QMB 3200 MID TERM EXCEL FORMULAS 100% CORRRECT

QMB 3200 MID TERM EXCEL
FORMULAS 100% CORRRECT
frequency formula - ANSWER-=countif(range,criteria)

percent frequency formula - ANSWER-=(frequency cell)/sum(range)

you need frequency and the total frequencies

relative frequency - ANSWER-=(frequency cell)/(total cell)

you need the frequency and the total

Standard deviation formula - ANSWER-=stdev.s(range)

outliers formula - ANSWER-Q1-1.5(IQR)

Histogram - ANSWER-a visual display of a frequency, relative frequency, or percent
frequency distribution. Var of interest is on the horizontal axis and frequencies are on
the vertical axis.

average/mean formula - ANSWER-=average(range)

Median formula - ANSWER-=median(range)

mode formula - ANSWER-=mode.sngl(range)

geometric mean formula - ANSWER-=geomean(range)

Percentile formula - ANSWER-=percentile.exc(range,percent)

quartile 1,2,3 formula - ANSWER-=quartile.exc(range,1) same for 2 and 3

Hypergeometric probability formula - ANSWER-=hypergeom.dist(sample, N ,r ,
population, False)
cum is true

exponential probability distribution formula - ANSWER-=expon.dist(x, 1/mean, true)
Only true

normal dist formula - ANSWER-=norm.dist(x, mean, standard dev, cum/true)

variance formula - ANSWER-=var.s(range)