Binomial Distributions
Given your statistical knowledge, you have been asked to assist the quality control manager of a local manufacturer in establishing and seeing that the factory conforms to standards set by management. The facility manufactures a new electronic toy. The factory can produce 1000 toys per day. Management has indicated that initially they will be satisfied if the defect rate is 3% or less. Since you can’t quality-test every toy produced, you suggest that a random sample of 40 toys be taken. The results of testing 40 toys from today’s production line yields the results shown in the “WA3_Outcomes” Excel file Column 1.
Take a second sample of 40 toys.
The results of this sample are shown in “WA3_Outcomes” Excel file Column 2.
WA 3 - Outcome | |
Outcome #1 | Outcome #2 |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Defective |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Defective |
Not | Not |
Not | Not |
Not | Not |
Defective | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Defective |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Not | Not |
Using Excel and this data
1. Create a pivot table for this sample.
2. Analyze the result.
3. Provide a rationale for how the knowledge gained from taking a second sample changes or does not change your analysis.
Pivot table made above
As we can observe that in the outcome 1 the defective were 1 out of 40 while for outcome 2 the defectives have increased to 3.
Hence we can say that the quality of the new sample is not acceptable since 3/40 i.e. 7.5% defective samples are now produced.
Hope the above answer has helped you in understanding the problem. Please upvote the ans if it has really helped you. Good Luck!!
Binomial Distributions Given your statistical knowledge, you have been asked to assist the quality control manager of a...