Question
Several ER physicians complained that turn-around times for lab tests were out of control and were constantly getting worse. In order to test their theory,
Several ER physicians complained that turn-around times for lab tests were "out of control" and were constantly getting worse. In order to test their theory, the following turn-around times in minutes were collected (Table 2). Use Excel to construct appropriate control charts (attach outputs)
Table 2. Turn-around Time of Lab Tests (Minutes)
Day | Test 1 | Test 2 | Test 3 | Day | Test 1 | Test 2 | Test 3 |
1 | 86 | 73 | 75 | 13 | 85 | 63 | 110 |
2 | 90 | 82 | 95 | 14 | 69 | 71 | 112 |
3 | 101 | 74 | 89 | 15 | 106 | 93 | 82 |
4 | 76 | 71 | 105 | 16 | 89 | 95 | 73 |
5 | 102 | 76 | 115 | 17 | 85 | 101 | 68 |
6 | 81 | 82 | 55 | 18 | 95 | 89 | 88 |
7 | 75 | 50 | 95 | 19 | 72 | 60 | 97 |
8 | 92 | 65 | 93 | 20 | 95 | 84 | 61 |
9 | 93 | 71 | 82 | 21 | 75 | 97 | 115 |
10 | 109 | 92 | 76 | 22 | 60 | 110 | 56 |
11 | 70 | 84 | 67 | 23 | 77 | 55 | 99 |
12 | 80 | 79 | 58 |
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