Question 5
37 |
39 |
35 |
25 |
20 |
37 |
15 |
22 |
28 |
15 |
33 |
31 |
19 |
19 |
19 |
192/5000
The following data measures the age of a random sample of 15
individuals in a group of aerobic exercises.
What percentage of the data is within a standard deviation
A. 40%
B. 25%
C. 60%
D. 45%
Entering the data into excel sheet from A1 to A15
Using Excel function AVERAGE to find the mean, we get
type formula AVERAGE then select the range A1 to A15
Mean = AVERAGE(A1:A15) = 26.27
Using Excel function STDEV.S to find the sample standard deviation, we get
type formula STDEV.S then select the range A1 to A15
Standard deviation = STDEV.S(A1:A15) = 8.50
Now, we need to find the one standard deviation range from the mean
So, lower limit is 17.77 and upper limit is 34.77
There are 9 data values which are between 17.77 and 34.77
total number of data values = 15
So, proportion = (data values between range)/(total number of data values) = 9/15 = 0.6
converting to %, we get 0.6*100 = 60%
option C is correct
Get Answers For Free
Most questions answered within 1 hours.