Question

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.

Answer 1

PivotTable Fieldsx Outcome Outcome Chocse fie ds to ads to report Outt 团Outcome 82 Hw LabelsCount of Outcome 42 Defective Defective 13 Grand Total าย 9 Defectve Drsg helds betmeen a ees below 23 Not Count of t out B Not

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!!