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
Written for
- Institution
- QMB 3200
- Course
- QMB 3200
Document information
- Uploaded on
- March 23, 2024
- Number of pages
- 1
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
- qmb 3200 formulas stuvia
-
qmb 3200 formulas with complete solutions
Also available in package deal