Question 1

• Using the sample data collected by you and Justin, apply the relevant Excel functions/reports to compute the three measures of central tendency and the three measures of dispersion on the daily exercise duration. Describe the sampled data using statistical measures.
• Construct the frequency distribution for the exercise duration using a class interval of 10 mins with 0 as the lower limit of the first class.
• Support part b) with a histogram to show the distribution of the data. Describe the shape of the histogram.
• Do you have a reason to believe that males spent more time exercising than females? Provide a short summary report to answer the above question. Support your reasoning with relevant statistical measures and/or charts.

Question 2

Construct a contingency table using the sampled data collected by gender and type of exercise.

Using the contingency table, answer the following questions:

• What is the probability that a person chosen plays ball games?
• What is the probability that a person chosen is a female and jogs?
• What is the probability that a person chosen, engage in other activities?
• Given that a person who swims, what is the probability that this person is a male?
• Given that a female is chosen, what is the probability that she swims?