COVID-19 lockdowns may lead to physical inactivity: A significant risk factor for non-communicable diseases A researcher aims to investigate the changes in daily step counts before and during the COVID-19 lockdown in North Sydney, Sydney. From December 2019 to July 2021, smartphone-based step counts were continuously collected in 40 Australian adults residing in North Sydney across phases: before and during the lockdown. The Excel file covid daily steps.xIsx shows the daily step counts for these two phases. Use Excel to analyse the data and answer the following questions; you may assume that any required assumptions have been met. For each question, either choose the most correct option, or type in the answer to the number of decimal places specified. 1. (1 mark) What was the average daily step counts before the COVID-19 lockdown ? x (2dp) 2. (1 mark) What was the standard deviation of daily step counts during the COVID-19 lockdown ? x (3dp) 3. (2 marks) Calculate a 95% confidence interval for the average daily steps before the lockdown for the Australian adults residing in North Sydney. lower bound x (3dp) upper bound x (3dp) 4. (1 mark) Based on your 95% confidence interval in Question 3, choose the most appropriate statement: XThe researcher is interested in using a hypothesis test to answer the question. on average, has the daily step counts changed before and during the COWD-IQ tockdown for North Sydney residents ? 5. (1 mark) Which of the following choices of tests should be used to test for a mean change in daily step counts before and during the COVlD19 lockdown? 3' 6. {1 marks) Use Excel to perform the test chosen in [5) and provide the absolute value of the test statistic X {3dp} 7. (1 mark) The pvalue is larger than 0.05 3 X 8. (1 mark) The test indicates that the average daily step counts for North Sydney residents: X