Management Excel Homework Binomial Probability Distribution Enter Data Only Yellow shaded

subject Type Homework Help
subject Pages 7
subject Words 168
subject Authors James R. Evans, William M. Lindsay

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Binomial Probability Distribution
Enter data only in yellow-shaded cells.
Number of successes, x3
x f(x) F(x)
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Poisson Probability Distribution Template
Enter data only in yellow-shaded cells.
Number of outcomes, x5
Mean,
l
12
f(x) = P(X = x)0.01274
x f(x) F(x)
00.00001 0.00001
10.00007 0.00008
20.00044 0.00052
30.00177 0.00229
40.00531 0.00760
50.01274 0.02034
60.02548 0.04582
70.04368 0.08950
80.06552 0.15503
90.08736 0.24239
10 0.10484 0.34723
11 0.11437 0.46160
12 0.11437 0.57597
13 0.10557 0.68154
14 0.09049 0.77202
15 0.07239 0.84442
16 0.05429 0.89871
17 0.03832 0.93703
18 0.02555 0.96258
19 0.01614 0.97872
20 0.00968 0.98840
21 0.00553 0.99393
22 0.00302 0.99695
23 0.00157 0.99853
24 0.00079 0.99931
25 0.00038 0.99969
26 0.00017 0.99987
27 0.00008 0.99994
28 0.00003 0.99998
29 0.00001 0.99999
30 0.00001 1.00000
31 0.00000 1.00000
32 0.00000 1.00000
33 0.00000 1.00000
34 0.00000 1.00000
35 0.00000 1.00000
36 0.00000 1.00000
37 0.00000 1.00000
38 0.00000 1.00000
39 0.00000 1.00000
40 0.00000 1.00000
41 0.00000 1.00000
42 0.00000 1.00000
43 0.00000 1.00000
44 0.00000 1.00000
45 0.00000 1.00000
46 0.00000 1.00000
47 0.00000 1.00000
48 0.00000 1.00000
49 0.00000 1.00000
50 0.00000 1.00000
Normal Distribution Probability Template
Enter data only in yellow-shaded cells
Mean,
m
1020
Standard deviation,
s
20
x-value 1036.83
Calculated z-value 0.8
F(x) = P(Xx)0.79997
x z F(x)
960.00 -3.00 0.00135
962.00 -2.90 0.00187
966.00 -2.70 0.00347
968.00 -2.60 0.00466
970.00 -2.50 0.00621
972.00 -2.40 0.00820
974.00 -2.30 0.01072
976.00 -2.20 0.01390
978.00 -2.10 0.01786
980.00 -2.00 0.02275
982.00 -1.90 0.02872
984.00 -1.80 0.03593
986.00 -1.70 0.04457
988.00 -1.60 0.05480
990.00 -1.50 0.06681
992.00 -1.40 0.08076
994.00 -1.30 0.09680
996.00 -1.20 0.11507
998.00 -1.10 0.13567
1000.00 -1.00 0.15866
1002.00 -0.90 0.18406
1004.00 -0.80 0.21186
1006.00 -0.70 0.24196
1008.00 -0.60 0.27425
1010.00 -0.50 0.30854
1012.00 -0.40 0.34458
1014.00 -0.30 0.38209
1016.00 -0.20 0.42074
1018.00 -0.10 0.46017
1020.00 0.00 0.50000
1022.00 0.10 0.53983
1024.00 0.20 0.57926
1026.00 0.30 0.61791
1028.00 0.40 0.65542
1030.00 0.50 0.69146
1032.00 0.60 0.72575
1034.00 0.70 0.75804
1036.00 0.80 0.78814
1038.00 0.90 0.81594
1040.00 1.00 0.84134
1042.00 1.10 0.86433
1044.00 1.20 0.88493
1046.00 1.30 0.90320
1048.00 1.40 0.91924
1050.00 1.50 0.93319
1052.00 1.60 0.94520
1054.00 1.70 0.95543
1056.00 1.80 0.96407
1058.00 1.90 0.97128
1060.00 2.00 0.97725
1062.00 2.10 0.98214
1064.00 2.20 0.98610
1066.00 2.30 0.98928
1068.00 2.40 0.99180
1070.00 2.50 0.99379
1072.00 2.60 0.99534
1074.00 2.70 0.99653
1076.00 2.80 0.99744
1078.00 2.90 0.99813
1080.00 3.00 0.99865
0.00000
0.10000
0.20000
0.30000
0.40000
0.50000
0.60000
0.70000
0.80000
0.90000
1.00000
960.00
966.00
970.00
974.00
978.00
982.00
986.00
990.00
994.00
998.00
1002.00
1006.00
1010.00
1014.00
1018.00
1022.00
1026.00
1030.00
1034.00
1038.00
1042.00
1046.00
1050.00
1054.00
1058.00
1062.00
1066.00
1070.00
1074.00
1078.00
Cumulative Probability Distribution P(X ≤ x)
Normal Inverse Distribution Calculation Template
Enter data only in yellow-shaded cells
Mean,
m
1044
20
Probability P(Xx)0.8
Calculated x-value 1060.83
Exponential Probability Distribution Template
Enter data only in yellow-shaded cells.
Mean rate,
l
0.00025
x- value 4000
F(x) = P(Xx)
0.6321
x F(x)
0 0.0000
800 0.1813
1600 0.3297
2400 0.4512
3200 0.5507
4000 0.6321
4800 0.6988
5600 0.7534
6400 0.7981
7200 0.8347
8000 0.8647
8800 0.8892
9600 0.9093
10400 0.9257
11200 0.9392
12000 0.9502
12800 0.9592
13600 0.9666
14400 0.9727
15200 0.9776
16000 0.9817

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.