**BB4401: Business Information Analysis **

**Practice Test 1 **

- In the Excel spreadsheet xlsx we have a collection of student data. Using this data you are required to generate:
- the frequency distribution for the siblings data.
**2 marks** - the relative frequency distribution for the ages of the students.
**2 marks** - the relative frequency distribution for the ages of the female students.
**2 marks** - the cumulative frequency distribution for the siblings data.
**2 marks** - the percent frequency distribution for the football teams supported by the students.
**2 marks** - the two way frequency distribution for the ages of the students by gender.
**marks**

- Answer the following questions.
- What is the modal number of siblings?
**1 mark** - 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 **

- What is the median number of siblings?

**Provide a full explanation of how the median is calculated. **

**3 marks **

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

- 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 **