Assignment:
The Crouse Fuse Company case presents a problem that may be analyzed with the use of P-Control Charts. The sampling data from operations during the monitored control week are used as a basis for P-Control chart limits in the future.
From the data in Exhibit 1 of the case, there are 80 different samples of 50 units per sample from the monitored week of operation. This gives a total number sampled as 80*50 = 4,000.
CFC management wants to see STATs process control analysis applied to the data from their system - based on the proportion of defective units in a sample, and it should be done on the data from BOTH shifts.
There were 94 defective units found during testing in the monitored week, yielding an expected proportion defective, = 94/4,000 = .0235. With a sample size n = 50; calculate the proportion standard deviation.
Make control charts for a 95% confidence level, which gives us a standard normal distribution value with Z = 1.960.
Need statistical response/charts from Excel for these control charts.
Note: These control limits are then used to construct P-Control charts to consider the output from the First Shift and Second Shift of the first week of operation after the monitored week.
| Sample |
Number Defective |
Day |
Sample |
Number Defective |
|
|
|
|
|
| 1 |
0 |
3 |
9 |
0 |
| 2 |
0 |
3 |
10 |
0 |
| 3 |
1 |
3 |
11 |
0 |
| 4 |
0 |
3 |
12 |
1 |
| 5 |
1 |
3 |
13 |
0 |
| 6 |
1 |
3 |
14 |
0 |
| 7 |
1 |
3 |
15 |
0 |
| 8 |
2 |
3 |
16 |
1 |
| 9 |
0 |
4 |
1 |
0 |
| 10 |
1 |
4 |
2 |
1 |
| 11 |
1 |
4 |
3 |
1 |
| 12 |
1 |
4 |
4 |
1 |
| 13 |
0 |
4 |
5 |
0 |
| 14 |
0 |
4 |
6 |
0 |
| 15 |
2 |
4 |
7 |
1 |
| 16 |
2 |
4 |
8 |
1 |
| 1 |
0 |
4 |
9 |
2 |
| 2 |
1 |
4 |
10 |
0 |
| 3 |
0 |
4 |
11 |
0 |
| 4 |
2 |
4 |
12 |
0 |
| 5 |
0 |
4 |
13 |
1 |
| 6 |
1 |
4 |
14 |
0 |
| 7 |
1 |
4 |
15 |
0 |
| 8 |
1 |
4 |
16 |
1 |
| 9 |
0 |
5 |
1 |
0 |
| 10 |
1 |
5 |
2 |
0 |
| 11 |
1 |
5 |
3 |
0 |
| 12 |
2 |
5 |
4 |
1 |
| 13 |
0 |
5 |
5 |
0 |
| 14 |
1 |
5 |
6 |
1 |
| 15 |
2 |
5 |
7 |
1 |
| 16 |
1 |
5 |
8 |
2 |
| 1 |
0 |
5 |
9 |
0 |
| 2 |
0 |
5 |
10 |
0 |
| 3 |
0 |
5 |
11 |
1 |
| 4 |
1 |
5 |
12 |
1 |
| 5 |
0 |
5 |
13 |
0 |
| 6 |
0 |
5 |
14 |
0 |
| 7 |
1 |
5 |
15 |
0 |
| 8 |
2 |
5 |
16 |
1 |
Attachment:- Case crouse fuse company.rar