Excel data sheet: https://docs.google.com/spreadsheets/d/15wJ9zO6BhVP7HxTuznu-yElbmqxyrCumwSi75IuUMN0/edit?usp=sharing

5. (2 marks) What is the absolute value of the test statistic? {3dp} 0 6. (2 marks) Is the pvalue for this test statistic greater or less than 0.05? T. {1 mark} What is the most appropriate conclusion for this test? A. The average working hours are signicantly different from the 40 hours claimed by the health and wellbeing committee. The average working hours possibly increased. B. The average working hours are signicantly different from the 40 hours claimed by the health and wellbeing committee. The average working hours possibly decreased. C. The average working hours are consistent with the 40 hours claimed by the health and wellbeing committee. 8. A health and wellbeing committee member believes that the average working hours per week have shifted due to the COVlD19. the wants to estimate the 95% condence interval for the population mean using a random sample of 37 fulltime employees. Their average working hours are 48 hours. and the standard deviation is 5.8 hours. a. {1 mark} The Absolute Value of the Critical Value for a 95% condence interval is (3dp) b. {1 mark} Lower Bound = hours (2dp) c. {1 mark} Upper Bound = hours (2dp) 0 A health and wellbeing committee claims that working an average of 40 hours per week is recommended for maintaining a good worklife balanoe. A random sample of 49 fulltime employees was surveyed about how many hours they worked: the data are recorded in the Exoel le WorkingHours.xlsx . You may assume that the data come from a population that is normally distributed. Use Excel and an appropriate hypothesis test to answer the following research question: Research Question: Are full-time employees working an average of 40 hours per week? 1. (1 mark) What is the sample mean? hours (2dp) 2. (1 mark) What is the sample standard deviation? hours (3dp) 0 3. (1 mark) The most appropriate hypothesis test for these data is 4. (1 mark) The null hypothesis is that the average working hours pin in the HI]: :1 = m] a twosample ttest for comparing means 5. (2 marks) What is the absolute value of the test statistic? _ _ a paired ttest for comparing means 6. (2 marks) Is the pvalue for this test statistic greater or less tha a Una-sample Ztest for a population mean i". (1 mark) What is the most appropriate conclusion for this test? a onesample t'tESt for a population mean 4. [1 ma rk] The null hypothesis is that the average worl-cing hours equal (Hint: this is the value of pin in the HI]: :1 = no] 5. [2 ma rlcs) What is the absolute value of the test statistic? 53.04 hours 1P 6. [2 marks) Is the pvalue for this test statistic greater or less than 0.05 40'04 hours 7". [1 mark) What is the most appropriate conclusion for this test? 45.04 hours 40 hours