Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Download and open mng times.xlsx file containing waiting times collected from hospitals A and B. How we will use this data set to determine whether
Download and open mng times.xlsx file containing waiting times collected from hospitals A and B. How we will use this data set to determine whether there is a difference between the average 1wailing times of patients in hospitals. Since the waiting times of patients in the different hospitals are independent, and thus we will use a two-sample t-test to compare the average waiting times. Follow the instructions in the Practical nine worksheet and perform the two-sample t-test 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? {Ede} Hospital A Hospital B 5.4 9 4.8 6.7 6.9 7.3 6.4 10.7 5.7 8.3 7.6 7.7 4.1 5.3 5.9 8.3 5.7 6.5 7.3 7.8 5.4 9.5 6 12.7 6.3 7.6 5.3 8.6 6.3 13 5.1 4.9 5.3 8.1 4.8 8.1 6.5 7.9 4.9 8.2 5.7 3.3 5.7 4.3 5.2 5.3 7.8 4.9 6.4 7.5
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started