Excel HW 1.0 - 20 20.9 18.25 Column1 20 20 20 22 20 22 Mean 20.9 9 8 50 Standard Error 1.08128797 20 50 Median 20 40 15 Mode 20 13 22 Standard Deviation

# Excel HW 1.0 - 20 20.9 18.25 Column1 20 20 20 22 20 22 Mean...

• Notes
• 5

This preview shows page 1 - 3 out of 5 pages.

20 20.9 18.25 Column1 20 20 20 22 20 22 Mean 20.9 9 8 50 Standard Error 1.08128797 20 50 Median 20 40 15 Mode 20 13 22 Standard Deviation 7.64586056 10 7.6458605581 Sample Variance 58.4591837 20 58.4591836735 Kurtosis 4.41907364 15 Skewness 1.6130124 22 Range 42 18 Minimum 8 20 Maximum 50 40 Sum 1045 19 Count 50 22 Largest(1) 50 50 Smallest(1) 8 22 22 21 21 20 22 The mean is slightly higher than the median and the mode 29 the distrubution is fairly normal, but is slighty right skewed 14 the five number summary for this data set is: 21 Mininmum: 8 18 Quartile 1: 18.25 21 Mean: 20.9 19 Quartile 3: 22 22 Maximum: 50 20 15 15 15 21 10 8 23 20 AVERAGE(A1:A50) QUARTILE(A1:A50, 1) 35 MEDIAN(A1:A50) QUARTILE(A1:A50,2) 20 MODE(A1:A50) QUARTILE(A1:A50, 3) 22 MIN(A1:A50) QUARTILE(A1:A50, 4) 30 PERCENTILE(A1:A50, 0.2) 20 PERCENTILE(A1:A50, 0.8) 20 STDEV(A1:A50) 20 VAR(A1:A50) 25 12 20 22
Mean 21.22 Standard Deviation 5.36 The answers are in bold. (Part A) What percent of vehicles have miles per gallon ratings greater than 30 NORMDIST(30,B1,B2,TRUE) 0.949295 1-0.94929538= 0.050705 5.07% (Part B) What percent of vehicles have miles per gallon ratings between 30 and 35 NORMDIST(35,B1,B2,TRUE) 0.994928 0.994928204-0.949295= 0.045633 4.56% (Part C) What percent of vehicles have miles per gallon ratings less than 12.45 NORMDIST(12.45,B1,B2,TRUE) 0.050899 5.09%