Below are ACT composite scores from 20 randomly selected college students.

15 33 20 25 21

24 17 16 20 25

26 21 21 17 28

21 24 19 19 24

6. Using excel, Calculate the following descriptive statistics below. Be sure all your work is shown and clearly labeled. Provide a screenshot of the functions and results from Excel and paste it into your assignment document (be sure I can see the numbers and labels clearly).

• mean
• median
• range
• sample standard deviation (using STDEV.S)
• sample variance (using VAR.S)
• population standard deviation (using STDEV.P)
• population variance (using VAR.P)

Respond to the following questions:

7. How would you interpret the sample standard deviation? (*Hint* Also consider the mean value and refer to page 84 of your textbook). (3 pts) 8. How would you interpret the sample variance? (3 pts) 9. Which of these two measures of variability is easier to interpret? Explain. (3 pts)