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
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
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
4000 0.039211
5000 0.048771
6000 0.058235
7000 0.067606
8000 0.076884
9000 0.086069
10000 0.095163
15000 0.139292
20000 0.181269
30000 0.259182
40000 0.329680
50000 0.393469
60000 0.451188
70000 0.503415
80000 0.550671
90000 0.593430
100000 0.632121
Table for chart construction
T = x Cum. Failure
Hours Probability
0 0.000000
10000 0.095163
20000 0.181269
30000 0.259182
40000 0.329680
50000 0.393469
70000 0.503415
80000 0.550671
90000 0.593430
100000 0.632121
110000 0.667129
120000 0.698806
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
Calculated probability 0.139292 Calculated probability 0.095163
190000 0.850431
200000 0.864665
210000 0.877544
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
