Question: Using the data below, Day How late my manager was to work (in minutes) 1 0 2 8 3 5 4 10 5 0 6
Using the data below,
| Day | How late my manager was to work (in minutes) |
| 1 | 0 |
| 2 | 8 |
| 3 | 5 |
| 4 | 10 |
| 5 | 0 |
| 6 | 2 |
| 7 | 6 |
| 8 | 8 |
| 9 | 15 |
| 10 | 1 |
| 11 | 0 |
| 12 | 6 |
| 13 | 45 |
| 14 | 20 |
| 15 | 2 |
| 16 | 3 |
| 17 | 7 |
| 18 | 8 |
| 19 | 12 |
| 20 | 9 |
1. Calculate the control limits.
- Determine if any points are out-of-control.
- If so, remove those data points and recalculate the limits.
- These become your established limits and will not change when you add the additional 5 data points.
2. Once you have established your limits, collect five more data points to "test" these limits. Do not recalculate the limits based on the additional data points
3. Most importantly, using excel create either a p-chart or moving range chart depending on your data.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
