Question

Here are the scores for two separate statistics courses. The first group is from the Fall term. The second group is from the Spring term. Calculate the means, ranges, population variances, and population standard deviations of each group. Lastly, tell me in your own words what the numbers are telling us about the data; specifically, compare them to one another.

• Fall: 86, 91, 69, 78, 72, 82, 61, 81
• Spring: 70, 92, 85, 77, 65, 88, 80, 72

1.Calculate the mean for the Fall:

2.Calculate the mean for the Spring:

3.Calculate the range for the Fall:

4.Calculate the range for the Spring:

5.Calculate the population variance for the Fall:

6.Calculate the population variance for the Spring:

7.Calculate the population standard deviation for the Fall:

8.Calculate the population standard deviation for the Spring:

9.In your own words, what do the different standard deviations between the Fall and Spring statistics courses indicate? How does this relate to range calculations?

Answer 1

1. Here mean for the fall = 77.5 (By using average function of Excel)

2. Here mean for the spring = 78.625 (By using average function of Excel)

3. Range for the fall = Maximum - Minimum = 30

4. Range for the Spring = Maximum - Minimum = 27

5. Population Variance for Fall = VaR(Data Set) = 94.57

6. Population variance for Spring = VaR(DataSet) = 87.98

7. Population Standard deviation for the Fall = STDEV(Dataset) = 9.72

8. Population Standard deviation for the Fall = STDEV(Dataset) = 9.38

9. Here we can see that there are two diffetent standard deviation between the fal and spring courses. It is because the range of the scores. As the range of fall scores is more so that means standard deviation would be higher for fall scores.