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)
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)
