BB4401: Business Information Analysis

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
  8. Answer the following questions.
  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