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.81 | Bin | Frequency | |||
3.82 | 3.8 | 0 | |||
3.85 | 4.0 | 35 | |||
3.86 | 4.2 | 65 | |||
3.87 | 4.4 | 13 | |||
3.88 | 4.6 | 11 | |||
3.88 | 4.8 | 15 | |||
3.88 | 5.0 | 36 | |||
3.88 | 5.2 | 4 | |||
3.89 | 5.4 | 1 | |||
3.90 | More | 0 | |||
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 | |||||
Transcribed Image Text:
Frequency 70 60 50 40 30 20 10 0 Histogram dud 3.8 4.0 4.2 4.4 4.6 4.8 5.0 5.2 5.4 More Bin Frequency
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
An Introduction To Six Sigma And Process ImprovementISBN: 9781133604587 2nd Edition Authors: James R. Evans, William M. Lindsay
Question Posted:
|