Question
Using Excel, calculate the mean wait times for both samples, along with their standard deviations. Then conduct a t-test, assuming unequal variances, to determine if
Using Excel, calculate the mean wait times for both samples, along with their standard deviations. Then conduct a t-test, assuming unequal variances, to determine if there is a statistically significant difference in the mean waiting time of the two samples.
Submit your findings in a Word document and include the Excel spread sheet.
Sample 1 - Old patient triage process wait time in minutes | Sample 2 - New patient triage process wait time in minutes |
35.63 | 30.44 |
29.80 | 26.51 |
33.43 | 30.46 |
29.37 | 33.44 |
33.62 | 31.06 |
30.65 | 30.05 |
33.26 | 33.70 |
27.11 | 31.62 |
28.36 | 24.03 |
37.48 | 31.42 |
35.02 | 30.20 |
31.99 | 32.67 |
30.22 | 28.99 |
31.99 | 30.57 |
31.49 | 32.49 |
33.34 | 30.54 |
35.84 | 33.44 |
27.68 | 33.00 |
33.18 | 33.13 |
29.93 | 34.90 |
30.81 | 29.08 |
33.96 | 35.72 |
34.87 | 35.90 |
41.05 | 30.70 |
32.31 | 33.15 |
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