Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribedimage text in transcribed
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% Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Birds Higher Engineering Mathematics

Authors: John Bird

9th Edition

1000353036, 9781000353037

More Books

Students also viewed these Mathematics questions

Question

Evaluate employees readiness for training. page 275

Answered: 1 week ago