Question 2 (8 marks) Marks

All work for this question must be done on the worksheet named Question 2.

This worksheet can befound in the data fileAssignment Data.

You are about to test the following hypothesis:

In 2019, the annual salary (US dollars) of 65 randomly selected professional sporting athletes around the world was collected. Is there a significant difference between the average annual salary of male and female athletes?

1. Using Excel, obtain an output for a hypothesis test at 5% level of significance. Assume that the population variances of the two groups of sporting athletes are equal. Also, assume that the annual salaries of male and female athletes are normally distributed.*[3]

Using the information in the output, conduct a hypothesis test in the space below. Make sure that you include the null and the alternative hypothesis, the decision rule and the value of the test statistics. Explain your decision and write a conclusion.

Annual salary of males athletes ($US in millions)	Annual salary of female athletes ($US in millions)
53.4	2.8
16.8	11.1
16.1	25.8
10.9	10.2
26.0	8.6
7.9	6.3
44.7	16.3
16.9	21.4
47.7	11.8
43.8	6.3
30.3	1.4
52.1	6.9
44.8	24.8
50.7	9.2
55.8	24.2
5.2	19.3
36.4	28.1
25.0	27.6
51.9	1.9
28.7	4.7
13.7	14.6
32.0	24.6
43.1	21.7
47.7	6.3
58.2	6.0
23.2	23.1
47.7	3.0
39.1
11.3
11.3
42.8
55.2
52.7
28.8
27.8
34.5
52.4
58.2