Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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
Problem 6-2 Numeros Verdes Partners, P.S.C.
Binomial Probability Distribution
Enter data only in yellow-shaded cells.
Desired number 5
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
Problem 6-10 Genjeteye, Inc.
Exponential Probability Distribution
Enter data only in yellow-shaded cells.
Failure Rate = 1/MTTF 0.00001 Failure Rate = 1/MTTF 0.00001
T = x Cum. Failure P(10000 ≤ x ≤ 15000) = P(x ≤ 15000) - P(x ≤ 10000) = 0.044129
Hours Probability F(x)
1000 0.009950
2000 0.019801
3000 0.029554
30000 0.259182
40000 0.329680
50000 0.393469
60000 0.451188
Table for chart construction
T = x Cum. Failure
Hours Probability
0 0.000000
130000 0.727468
140000 0.753403
150000 0.776870
160000 0.798103
170000 0.817316
180000 0.834701
0.800
0.900
1.000
Cumulative Failure Probability
190000 0.850431
200000 0.864665
210000 0.877544
