The quality manager at the Noscrap Shirt Company took a random sample of 10 workers’ output of good and defective shirts produced for 10 days each on a check sheet, as shown in the worksheet Prob04-04 in the Excel workbook Ch04Data.xlsx on the Student Companion Site. Find the proportion of defective shirts in the sample by using the Excel COUNTIF function. Recommend what management should do, based on these findings.

 

COUNTIF FUNCTION
Answers the question: Is the shirt GOOD or DEFECTIVE?
					DEFECT	GOOD
COUNTIF (RANGE, CRITERIA) --> COUNTED ITEMS					12	88
PERCENT OF TOTAL					12%	88%
GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	DEFECT	GOOD
GOOD	GOOD	GOOD	DEFECT	GOOD	GOOD	GOOD	GOOD	GOOD	DEFECT
GOOD	GOOD	GOOD	GOOD	DEFECT	DEFECT	GOOD	GOOD	DEFECT	GOOD
GOOD	GOOD	DEFECT	GOOD	GOOD	GOOD	DEFECT	GOOD	GOOD	GOOD
GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD
GOOD	GOOD	GOOD	DEFECT	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD
GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD
GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD
DEFECT	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	DEFECT	GOOD	GOOD
GOOD	DEFECT	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD	GOOD