Module 1 Analytics

excel worksheet

Problem

Criteria

Maximum Points

Problem 1 (MPG)

Problem 2 (2.6b)

Formula for Mean 1

 Formula for Median 1

 Formula for Mode 1  2 

Formula for Mode 2  2 

Formula for Range 1 

Formula for Variance 2 

Formula for Standard Deviation 2 

Formula for Coefficient of Variation 2 

Formula for 92nd Percentile 2 

Formula for 1st Quartile 1 

Formula for 2nd Quartile 1 

Formula for 3rd Quartile 1 

Formula for IQR 2 

Formula for Frequency 12 

Formula for Relative Frequency 4

 Formula for Percent Frequency 4

Total Points

40