QMB 3200 Formulas With Complete Solutions!

Class Width - ANSWERS=(Max - Min)/5 Quartile 1 - ANSWERS=QUARTILE.EXC (data, 1) ← 25% percentile Quartile 3 - ANSWERS=QUARTILE.EXC (data, 3) ← 75% percentile Percentile - ANSWERS=PERCENTILE.INC(data, %) Mean - ANSWERS=AVERAGE(data) Median - ANSWERS=MEDIAN(data) Mode - ANSWERS=MODE(data) Range - ANSWERS=MAX(data) - MIN(data) Interquartile Range - ANSWERS=QUARTILE.EXC(data,3) - QUARTILE.EXC(data,1) Variance Excel - ANSWERS=VAR.S(data) St Dev - ANSWERS=STDEV.S(data) Coefficient of Variation - ANSWERS=Standard Deviation/Mean Covariance - ANSWERS=COVARIANCE.S (data1, data2) Correlation - ANSWERS=CORREL (data1, data2) Expected Value - ANSWERS=(a+b)/2 Variance Formula - ANSWERS=(b-a)^2/12 Compute Prob Given Z - ANSWERS=NORM.S.DIST Compute Z Given Prob - ANSWERS=NORM.S.INV