Problem 6-2 Numeros Verdes Partners, P.S.C.
COUNTIF FUNCTION
Answers the question: Is the bill overdue?
TRUE FALSE
COUNTIF (RANGE, CRITERIA) –> COUNTED ITEMS 50 150
PERCENT OF TOTAL 25% 75%
FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE TRUE FALSE
FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE
FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE
FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE
FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE TRUE TRUE FALSE FALSE
Problem 6-2 Numeros Verdes Partners, P.S.C.
Binomial Probability Distribution
Enter data only in yellow-shaded cells.
Desired number 5
Sample Size 10
Proportion – p 0.25
Calculated probability 0.05840
Problem 6-3 Turkuman Rug Co.
Poisson Probability Distribution Template
Enter data only in yellow-shaded cells.
Desired number 7
x f(x) F(x)
0 0.16530 0.16530
1 0.29754 0.46284
2 0.26778 0.73062
3 0.16067 0.89129
4 0.07230 0.96359
5 0.02603 0.98962
6 0.00781 0.99743
7 0.00201 0.99944
8 0.00045 0.99989
9 0.00009 0.99998
Distribution mean 1.8
Calculated probability
0.800
0.900
1.000
Cumulative Failure Probability
Calculated probability 0.139292 Calculated probability 0.095163
220000 0.889197
230000 0.899741
240000 0.909282
250000 0.917915
260000 0.925726
270000 0.932794
280000 0.939190
290000 0.944977
300000 0.950213