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 h