Problem 3 (Based on Hypothesis Testing) During the current COVID-19 directives, it was stated that contact sports aren't allowed. Members of the Barbados private Footballers association claim that 20% of the public support this claim, that football games should not be allowed. The president of the Footballer's association, Mark Small, called upon Breezy Analytics to investigate whether there is any validity in the claims being made. You carry out a hypothesis test to investigate whether there is any statistical evidence in favor or against the claim being made. You carry out a survey on a survey of over 700 Barbadian footballers. The main question asked was: "Should football games be allowed during the current COVID-19 directive? The responses to this question were recorded and entered in an Excel spread sheet. The Excel Sheet was labelled "Football". a. In Excel, construct a pivot table to show the frequency distribution of Barbadian attitudes towards football being allowed. [1 mark] b. Based on the pivot table, what is the point estimate for the proportion of persons who believe that football should be allowed [1mark] c. Use the information from the above and the critical value approach to test whether the data collected supports the claim made by football association using a = 0.03 . For the hypothesis test, students should make they (1) state the null hypothesis and the alternative hypothesis algebraically; (2) compute the test statistics and critical values; (3) state (or show) the rejection and do not reject regions; and (4) based on (2) and (3), make a decision (reject or do not reject the null). Finally, state your conclusion. [8 marks] d. Using the p-value approach, you redid your test and calculated the p-value of 0.000. Based on this p-value, does your decision change? Give a reason for your answer [ 3 marks]