COVID-19 deaths are underreported in different countries for different reasons, including limited capacity to test for infection, inadequate death registration systems, and inaccurate reporting due to political factors. As a result, health officials based their analysis on the concept of "excess mortality"- a measure of the difference between deaths from all causes observed or estimated during the pandemic and the number of deaths that would be expected from the past mortality trends. For example, the Economist, estimates 22.05 million (95%% uncertainty interval 21.35-22.75 million) excess deaths between 1 January 2020 and 31 December 2021. The Excel file ExcessDeaths.xlex contains excess deaths estimates (in millions) for the same period, from 32 randomly selected from health experts/institutions worldwide. Use EXCEL and an appropriate hypothesis test to answer the following research question, assuming assumptions are satisfied. Research Question: Could the mean excess deaths due to the COVID-19 pandemic equal 22.05 million between 1 January 2020 and 31 December 2021, as estimated by the Economist? 1. (1 mark) What is the sample mean? million (3dp) 2. (1 mark) What is the sample standard deviation? million (3dp) 3. (1 mark) The most appropriate hypothesis test for these data is 4. (1 mark] The null hypothesis is that the mean estimated excess deaths from COVID-19 equal (Hint: this is the value of up in the Ho: M = Mol 5. (2 mark) What is the absolute value of the test statistic ? (3dp) 6. (2 mark) Is the p-value for this test statistic greater or less than 0.05? 7. (3 mark) Calculate a 95%% confidence interval to estimate the mean excess deaths due to the COVID-19 between 1 January 2020 and 31 December 2021. The Absolute Value of the Critical Value for a 95% confidence interval is (3dp) Lower Bound = million (3dp) Upper Bound = million (3dp) 8. (1 mark) What is the most appropriate conclusion for this test? A. The excess deaths are significantly different than the hypothesised value, possibly greater. B. The excess deaths are significantly different than the hypothesised value, possibly lower. C. The excess deaths could be the same as the hypothesised value