BB4401: Business Information Analysis

Practice Test 1

3. In the Excel spreadsheet xlsx we have a collection of student data. Using this data you are required to generate:
4. the frequency distribution for the siblings data.                                                2 marks
5. the relative frequency distribution for the ages of the students.               2 marks
6. the relative frequency distribution for the ages of the female students. 2 marks
7. the cumulative frequency distribution for the siblings data.                 2 marks
8. the percent frequency distribution for the football teams supported by the students.                                                                                                                                    2 marks
9. the two way frequency distribution for the ages of the students by gender.
   • marks
10. Answer the following questions.
11. What is the modal number of siblings?                                                 1 mark
12. 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

 

4. 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