Hey,

Can someone please help with these business statistics questions?

Thank you.

A B C D E F G 1 Hospital A Hospital B 2 8 6.4 3 4.8 4.2 4 5.7 5.9 5 6.9 4.9 6 6.9 3.1 7 6.3 6 8 7 5.3 9 6.1 6.2 10 5.6 5.3 11 7.1 5.8 12 6.9 4.8 13 7.3 5.2 14 5.6 3.5 15 6.3 4.9 16 6 4.4 17 8.6 3.4 18 6.2 3.8 19 6.8 5 20 8.3 3.1 21 7.3 5.9 22 5.7 4.1 23 6.8 5.1 24 8.2 5.2 25 5.9 4.8 26 6.1 6.5 27 8 5.2 28 7.8 5.4 29 8.1 7.8 30 7.9 5.7 31Question 1 Not yet saved Marked out of 1.00 F Flag question Question 2 Not yet saved Marked out of 1.00 W" Flag question Download and open Mg times.xlsx file containing waiting times collected from hospitals A and B. Now we will use this data set to determine whether there is a difference between the average waiting times of patients in hospitals. Since the waiting times of patients in the different hospitals are independent, and thus we will use a twosample ttest to compare the average waiting times. Follow the instructions in the Practical nine worksheet and perform the twosample ttest in Excel. 1. (1 mark) What is the absolute value of the test statistic? = (3dp) 2. (1 mark) What is the value of the degrees of freedom? = (Integer) 3. (1 mark) What is the absolute value of the critical value for constructing the 95% confidence interval for the difference in the population mean waiting times? (3dp) Department waiting times wa iting times Department A Department B (2 mark) A visual display that could be used to check one of the assumptions for the hypothesis test is shown below. Which assumption could be checked using this display? Has this assumption been satisfied? Explain why or why not the assumption has been satisfied