Question: The Excel file Process Behavior Homework has 3 columns identified as X1, X2 and X3 as well as a Month column (Data tab). Assume X1,
The Excel file Process Behavior Homework has 3 columns identified as X1, X2 and X3 as well as a Month column (Data tab). Assume X1, X2 and X3 represent Key Measures for your Business. Develop Process Behavior Charts for each of these Key Measures using the techniques described in the notes. Remember these instructions are slightly different than those provided in the Understanding Variation supplemental textbook (Median moving range, +- 2 standard deviations). Make sure to evaluate and remove outliers per the rules provided in the notes. Interpret the performance of each of these Key Measures and comment on your next course of action.
Grading Scale:
- X1 (2 points)
- X2 (2 points)
- X3 (3 points) Note: On X3, due to an operating issue, a new work procedure was implemented starting in July, 2016. This procedure directly impacts the performance of this Key Measure.
| Month | X1 | X2 | X3 |
| 15-Jun | 4.09 | 3.59 | 3.59 |
| 15-Jul | 6.36 | 6.36 | 6.36 |
| 15-Aug | 5.92 | 5.92 | 5.92 |
| 15-Sep | 4.87 | 4.87 | 4.87 |
| 15-Oct | 5.43 | 5.43 | 5.43 |
| 15-Nov | 4.09 | 8.09 | 4.09 |
| 15-Dec | 5.39 | 5.39 | 5.39 |
| 16-Jan | 6.19 | 6.19 | 6.19 |
| 16-Feb | 6.22 | 6.22 | 6.22 |
| 16-Mar | 4.89 | 4.89 | 4.89 |
| 16-Apr | 6.33 | 6.33 | 6.33 |
| 16-May | 4.4 | 4.4 | 12.9 |
| 16-Jun | 4.63 | 4.63 | 9.63 |
| 16-Jul | 4.99 | 4.99 | 4.99 |
| 16-Aug | 5.97 | 5.97 | 5.97 |
| 16-Sep | 5.01 | 5.01 | 5.01 |
| 16-Oct | 4.03 | 3.5 | 4.03 |
| 16-Nov | 5.52 | 5.52 | 5.52 |
| 16-Dec | 5 | 5 | 5 |
| 17-Jan | 5.05 | 9.05 | 5.05 |
| 17-Feb | 5.24 | 5.24 | 5.24 |
| 17-Mar | 4.44 | 4.44 | 4.44 |
| 17-Apr | 4.34 | 4.34 | 4.34 |
| 17-May | 5.06 | 3.39 | 3.89 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
