QMB 3200 Formulas Exam Rated A+
Study online at https://quizlet.com/_hpgkvo
1. Class Width: =(Max - Min)/5
2. Quartile 1: =QUARTILE.EXC (data, 1) •25% percentile
3. Quartile 3: =QUARTILE.EXC (data, 3) •75% percentile
4. Percentile: =PERCENTILE.INC(data, %)
5. Mean: =AVERAGE(data)
6. Median: =MEDIAN(data)
7. Mode: =MODE(data)
8. Range: =MAX(data) - MIN(data)
9. Interquartile Range: =QUARTILE.EXC(data,3) - QUARTILE.EXC(data,1)
10. Variance Excel: =VAR.S(data)
11. St Dev: =STDEV.S(data)
12. Coefficient of Variation: =Standard Deviation/Mean
13. Covariance: =COVARIANCE.S (data1, data2)
14. Correlation: =CORREL (data1, data2)
15. Expected Value: =(a+b)/2
16. Variance Formula: =(b-a)^2/12
17. Compute Prob Given Z: =NORM.S.DIST
18. Compute Z Given Prob: =NORM.S.INV
19. Z Value Formula: =(x-mean)/St Dev
1/1
Study online at https://quizlet.com/_hpgkvo
1. Class Width: =(Max - Min)/5
2. Quartile 1: =QUARTILE.EXC (data, 1) •25% percentile
3. Quartile 3: =QUARTILE.EXC (data, 3) •75% percentile
4. Percentile: =PERCENTILE.INC(data, %)
5. Mean: =AVERAGE(data)
6. Median: =MEDIAN(data)
7. Mode: =MODE(data)
8. Range: =MAX(data) - MIN(data)
9. Interquartile Range: =QUARTILE.EXC(data,3) - QUARTILE.EXC(data,1)
10. Variance Excel: =VAR.S(data)
11. St Dev: =STDEV.S(data)
12. Coefficient of Variation: =Standard Deviation/Mean
13. Covariance: =COVARIANCE.S (data1, data2)
14. Correlation: =CORREL (data1, data2)
15. Expected Value: =(a+b)/2
16. Variance Formula: =(b-a)^2/12
17. Compute Prob Given Z: =NORM.S.DIST
18. Compute Z Given Prob: =NORM.S.INV
19. Z Value Formula: =(x-mean)/St Dev
1/1