Question: Determine the mean and standard deviation values from the data below. Calculate the % of each data set that falls within 1, 2 and 3
Determine the mean and standard deviation values from the data below. Calculate the % of each data set that falls within 1, 2 and 3 standard deviations. The count and countifs functions will be useful.Make a table that summarizes the findings, then provide a comment on the results. Do the fractions of data that fall within the various standard deviation ranges agree with what you would expect for a normally distributed random variable? Are there any datasets where the ranges seem odd?Use Excel.



BLUE (g) 0.775 0.863 0.825 0.854 0.869 0.864 0.887 0.912 0.807 0.855 0.818 0.942 0.886 0.841 0.932 0.868 0.810 0.881 0.803 0.858 0.842 0.832 0.881EXAM SCORES 93 40 20 52 59 75 41 74 65 40 38 46 65 31 36 49 53 76 64 45 65 70 37HEIGHT (cm) 186.0 160.5 179.0 166.7 178.5 180.4 166.3 181.1 170.0 180.8 174.7 171.9 175.9 179.8 182.9 169.3 161.6 166.2 155.0 178.4 176.7 174.9 178.2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
