Problem 4-4
Hanna Vinson
Noscrap Shirt Company
Applying the COUNTIF FUNCTION
Answers the question: Is the shirt good or defective?
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
Good
Defective
88
12
proportion =
12%
Management should
that the proportion o
next time a sample is