Problem 6-1-Instructor Reserve
SelCells, Inc.
COUNTIF FUNCTION
Answers the question: Is the CELLPHONE DEFECTIVE?
TRUE FALSE
6244
PERCENT OF TOTAL 2.40% 97.60%
FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
Problem 6-1-Instructor Reserve
SelCells, Inc.
Enter data only in yellow-shaded cells.
Desired number 5
Calculated probability 0.00565
x f(x) F(x)
0 0.29682 0.29682
1 0.36494 0.66176
2 0.21986 0.88162
3 0.08650 0.96812
7 0.00016 0.99998
8 0.00002 1.00000
Sample Size 50
Proportion – p 0.024