Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, can you please help me with this question? Download and open Waiting times.xlsx file containing waiting times collected from hospitals A and B. Now
Hi, can you please help me with this question?
Download and open Waiting 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 two- sample t-test to compare the average waiting times. Follow the instructions in the Practical nine worksheet and perform the two-sam ple Host in Excel. 1. {1 mark} What is the absolute value of the test statistic? = (Bop) 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} Q Waiting_times AutoSave O OFF Share Comments Home Insert Draw Page Layout Formulas Data Review View ? Tell me Insert v 11 AA ap Wrap Text v General Calibri (Body) Ex Delete Sort & Analyse Sensitivity Conditional Format Cell Find & Paste BIUV OvAv E Merge & Centre v $ ~ % " Formatting as Table Styles Format v Filter Select A1 4 X V fx Hospital A M N 0 P Q R S T U V w X Z AA E F G H K L Hospital A Hospital B 10.7 7. 12.5 7.6 11.5 1.2 10.4 6 9.7 7.4 9.6 3.3 9.2 8 11.4 11.2 10.4 7.8 9.8 6.5 7.5 9.9 10.7 6.9 9.8 3.4 10 8.2 8 9.9 9.7 7.7 10 8.1 10.1 4.2 8.3 4.6 11.5 5.6 9.8 6.4 10.9 6.7 10 8.9 9.4 8.1 12.1 4.9 11.4 7.1 11.7 5.9 30 8.3 9.5 31 33 34 35 36 df + - + 100% ReadyStep 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