QMB 3200 Formulas Exam Questions And
Answers
Class Width -
correct answer ✅=(Max - Min)/5
Quartile 1 -
correct answer ✅=QUARTILE.EXC (data, 1) ← 25% percentile
Quartile 3 -
correct answer ✅=QUARTILE.EXC (data, 3) ← 75% percentile
Percentile -
correct answer ✅=PERCENTILE.INC(data, %)
Mean -
correct answer ✅=AVERAGE(data)
Median -
correct answer ✅=MEDIAN(data)
Mode -
correct answer ✅=MODE(data)
Answers
Class Width -
correct answer ✅=(Max - Min)/5
Quartile 1 -
correct answer ✅=QUARTILE.EXC (data, 1) ← 25% percentile
Quartile 3 -
correct answer ✅=QUARTILE.EXC (data, 3) ← 75% percentile
Percentile -
correct answer ✅=PERCENTILE.INC(data, %)
Mean -
correct answer ✅=AVERAGE(data)
Median -
correct answer ✅=MEDIAN(data)
Mode -
correct answer ✅=MODE(data)