River Bottom Fire Department is evaluating their response times in order to determine whether a new fire

Question:

River Bottom Fire Department is evaluating their response times in order to determine whether a new fire station is needed. Samples were taken for 30 random days from 6 stations. These data can be found in the worksheet Prob07-01 in the Ch07Data.xlsx file.a. Using Microsoft Excel® or similar software with statistical capability, construct a histogram for these 180 individual readings.b. Construct a run chart for the sample meansc. Interpret what the data show. Does the process appear to be in control?


 









































































































































































































































































































































































































































































































































































































































































































































































































































































































River Bottom Fire Department
Sorted
Values
3.81BinFrequency
3.823.80
3.854.035
3.864.265
3.874.413
3.884.611
3.884.815
3.885.036
3.885.24
3.895.41
3.90More0
3.90
3.90
3.91
3.91
3.93
3.93
3.93
3.94
3.94
3.94
3.95
3.95
3.95
3.95
3.96
3.98
3.98
3.98
3.98
4.00
4.00
4.00
4.00
4.00
4.01
4.01
4.01
4.01
4.01
4.01
4.01
4.02
4.02
4.03
4.03
4.04
4.04
4.05
4.06
4.06
4.06
4.06
4.06
4.07
4.07
4.08
4.08
4.08
4.08
4.08
4.08
4.09
4.1
4.1
4.1
4.1
4.11
4.12
4.12
4.12
4.12
4.12
4.13
4.13
4.14
4.14
4.14
4.14
4.14
4.15
4.15
4.16
4.16
4.16
4.16
4.16
4.16
4.17
4.17
4.17
4.17
4.18
4.18
4.18
4.19
4.19
4.19
4.19
4.19
4.21
4.21
4.22
4.23