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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!