Homework SourseFor the data set provided use Minitab andor MS Excel to do t
For the data set provided), use Minitab and/or MS Excel to do the following: (15)
Develop the p-chart (for the control limits and centerline, calculate them by hand)
Develop the np-chart
Develop the q-chart
Sampel size for all numbers is 75
| Sample # | # Nonconforming |
| 1 | 4 |
| 2 | 3 |
| 3 | 2 |
| 4 | 1 |
| 5 | 1 |
| 6 | 2 |
| 7 | 2 |
| 8 | 1 |
| 9 | 1 |
| 10 | 0 |
| 11 | 0 |
| 12 | 5 |
| 13 | 2 |
| 14 | 1 |
| 15 | 2 |
| 16 | 3 |
| 17 | 3 |
| 18 | 3 |
| 19 | 2 |
| 20 | 2 |
| 21 | 1 |
| 22 | 4 |
| 23 | 4 |
| 24 | 1 |
| 25 | 3 |
Solution
I am not able to upload images, so sending the excel data. Using this data, we can generate charts in excel. For all the p, np and q chart, we will use Line chart type, but the Sample Data on x axis and respective, p, np and q data on y axis.
| Sample # | # Nonconforming | p chart | np chart | q chart | |||||
| 1 | 4 | 5.33% | 4 | 94.67% | |||||
| 2 | 3 | 4.00% | 3 | 96.00% | |||||
| 3 | 2 | 2.67% | 2 | 97.33% | |||||
| 4 | 1 | 1.33% | 1 | 98.67% | |||||
| 5 | 1 | 1.33% | 1 | 98.67% | |||||
| 6 | 2 | 2.67% | 2 | 97.33% | |||||
| 7 | 2 | 2.67% | 2 | 97.33% | |||||
| 8 | 1 | 1.33% | 1 | 98.67% | 0.027468 | 0.000366 | 0.01913728 | ||
| 9 | 1 | 1.33% | 1 | 98.67% | 2.060075 | 0.027468 | 0.16573371 | ||
| 10 | 0 | 0.00% | 0 | 100.00% | 0.027468 | 0.000366 | 0.01913728 | ||
| 11 | 0 | 0.00% | 0 | 100.00% | |||||
| 12 | 5 | 6.67% | 5 | 93.33% | |||||
| 13 | 2 | 2.67% | 2 | 97.33% | |||||
| 14 | 1 | 1.33% | 1 | 98.67% | UCLp | 8.5678507% | |||
| 15 | 2 | 2.67% | 2 | 97.33% | LCLp | -2.9145174% | |||
| 16 | 3 | 4.00% | 3 | 96.00% | CLp | 2.83% | |||
| 17 | 3 | 4.00% | 3 | 96.00% | |||||
| 18 | 3 | 4.00% | 3 | 96.00% | |||||
| 19 | 2 | 2.67% | 2 | 97.33% | |||||
| 20 | 2 | 2.67% | 2 | 97.33% | UCLnp | 2.617201126 | |||
| 21 | 1 | 1.33% | 1 | 98.67% | LCLnp | 1.622798874 | |||
| 22 | 4 | 5.33% | 4 | 94.67% | CLnp | 2.12 | |||
| 23 | 4 | 5.33% | 4 | 94.67% | |||||
| 24 | 1 | 1.33% | 1 | 98.67% | |||||
| 25 | 3 | 4.00% | 3 | 96.00% | UCLq | 1.029145174 | |||
| Total nonconforming | 53 | 2.83% | 2.12 | 0.971733 | LCLq | 0.914321493 | |||
| Total possible | 1875 | CLq | 0.971733333 | ||||||
| 2.83% |
