## Using the relative frequency distribution in 2b calculate the mean age of the students.

Practice Test 1

1. In the Excel spreadsheet xlsx we have a collection of student data. Using this data you are required to generate:
2. the frequency distribution for the siblings data.                                                2 marks
3. the relative frequency distribution for the ages of the students.               2 marks
4. the relative frequency distribution for the ages of the female students. 2 marks
5. the cumulative frequency distribution for the siblings data.                 2 marks
6. the percent frequency distribution for the football teams supported by the students.                                                                                                                                    2 marks
7. the two way frequency distribution for the ages of the students by gender.
• marks
9. What is the modal number of siblings?                                                 1 mark
10. Using the relative frequency distribution in 2b calculate the mean age of the students.

This should include a clear description of how you calculated the mean.

4 marks

1. What is the median number of siblings?

Provide a full explanation of how the median is calculated.

3 marks

1. What percentage of the students do not support Arsenal or Chelsea?
• marks What is the modal gender for each age?                                                                3 marks

1. Without calculating the mean values explain why the mean age of the male students is greater than the mean age of the female students.

3 marks