Question: Please assist in solving the question below: 3. For the data shown in the table below, construct a p-chart to evaluate the proportion of delayed
Please assist in solving the question below:
3. For the data shown in the table below, construct a p-chart to evaluate the proportion of delayed flights, a c-chart to assess the number of delayed flights, and x-bar and R-charts to analyze the delay duration (in minutes). After creating these charts, discuss which of them you find useful or not useful, and provide your reasoning.
| Among Samples of 5 Delayed Flights | ||||
| Date | #Flights | #Delayed Flights | Avg Delay Length | Range of Delay Length |
| 08-Apr | 91 | 10 | 11.67 | 29.38 |
| 09-Apr | 94 | 15 | 21.33 | 31.56 |
| 10-Apr | 92 | 8 | 19.12 | 52.91 |
| 11-Apr | 88 | 8 | 7.21 | 81.45 |
| 12-Apr | 109 | 7 | 17.13 | 27.17 |
| 13-Apr | 108 | 11 | 13.83 | 43.28 |
| 14-Apr | 112 | 16 | 22.9 | 33.15 |
| 15-Apr | 89 | 7 | 13.3 | 28.15 |
| 16-Apr | 94 | 13 | 15.64 | 46.11 |
| 17-Apr | 88 | 12 | 17.78 | 68.31 |
| 18-Apr | 90 | 8 | 23.89 | 45.12 |
| 19-Apr | 112 | 16 | 21.42 | 37.43 |
| 20-Apr | 110 | 17 | 21.64 | 37.56 |
| 21-Apr | 111 | 7 | 16.34 | 70.16 |
| 22-Apr | 93 | 10 | 20.25 | 49.03 |
| 23-Apr | 88 | 5 | 20.77 | 58.82 |
| 24-Apr | 93 | 12 | 11.39 | 48.5 |
| 25-Apr | 93 | 14 | 23.17 | 54.16 |
| 26-Apr | 109 | 14 | 8.36 | 55.86 |
| 27-Apr | 115 | 17 | 16.83 | 28.87 |
| 28-Apr | 112 | 7 | 19.9 | 67.78 |
| 29-Apr | 88 | 12 | 14.26 | 52.78 |
| 30-Apr | 92 | 12 | 20.68 | 67.07 |
| 01-May | 92 | 5 | 13.69 | 55.33 |
4. Using the control limits determined above, evaluate whether the new data shown in the table below (on the right) suggests that network performance is within control or out of control.
| Among Samples of 5 Delayed Flights | ||||
| Date | #Flights | #Delayed Flights | Avg Delay Length | Range of Delay Length |
| 10-May | 91 | 21 | 32.43 | 118.59 |
| 11-May | 94 | 15 | 31.85 | 74.79 |
| 12-May | 92 | 16 | 27.08 | 78.79 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
