QMB 3200 Excel Formulas Exam Questions And Answers.docx

QMB 3200 Excel Formulas Exam Questions
And Answers
frequency formula -
correct answer ✅=countif(range,criteria)


percent frequency formula -
correct answer ✅=(frequency cell)/sum(range)


you need frequency and the total frequencies


relative frequency -
correct answer ✅=(frequency cell)/(total cell)


you need the frequency and the total


Histogram -
correct 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 -
correct answer ✅=average(range)

, QMB 3200 Excel Formulas Exam Questions
And Answers
Median formula -
correct answer ✅=median(range)


mode formula -
correct answer ✅=mode.sngl(range)


geometric mean formula -
correct answer ✅=geomean(range)


Percentile formula -
correct answer ✅=percentile.exc(range,percent)


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


variance formula -
correct answer ✅=var.s(range)


Standard deviation formula -
correct answer ✅=stdev.s(range)