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
Get step-by-step solutions from verified subject matter experts
