Probability – Discussion - Statistics

COMPUTE

Binomial Probabilities
Data
Sample size	4
Probability of an event of interest	0.1
Statistics
Mean	0.4
Variance	0.36
Standard deviation	0.6
Binomial Probabilities Table
X	P(X)
0	0.6561
1	0.2916
2	0.0486
3	0.0036
4	0.0001

COMPUTE_FORMULAS

Binomial Probabilities
Data
Sample size	4
Probability of an event of interest	0.1
Statistics
Mean	=B4 * B5
Variance	=B8 * (1 - B5)
Standard deviation	=SQRT(B9)
Binomial Probabilities Table
X	P(X)
0	=BINOM.DIST(A14, $B$4, $B$5, FALSE)
1	=BINOM.DIST(A15, $B$4, $B$5, FALSE)
2	=BINOM.DIST(A16, $B$4, $B$5, FALSE)
3	=BINOM.DIST(A17, $B$4, $B$5, FALSE)
4	=BINOM.DIST(A18, $B$4, $B$5, FALSE)

Histogram

Binomial Probability Histogram

0 1 2 3 4 0.65610000000000002 0.29159999999999991 4.8600000000000011E-2 3.6000000000000025E-3 1.0000000000000009E-4

Number of Events of Interest

P(X)

CUMULATIVE

Binomial Probabilities
Data
Sample size	4
Probability of an event of interest	0.1
Statistics
Mean	0.4
Variance	0.36
Standard deviation	0.6
Binomial Probabilities Table
X	P(X)	P(<=X)	P(<X)	P(>X)	P(>=X)
0	0.6561	0.6561	0.0000	0.3439	1.0000
1	0.2916	0.9477	0.6561	0.0523	0.3439
2	0.0486	0.9963	0.9477	0.0037	0.0523
3	0.0036	0.9999	0.9963	0.0001	0.0037
4	0.0001	1.0000	0.9999	0.0000	0.0001

CUMULATIVE_FORMULAS

Binomial Probabilities
Data
Sample size	4
Probability of an event of interest	0.1
Statistics
Mean	=B4 * B5
Variance	=B8*(1 - B5)
Standard deviation	=SQRT(B9)
Binomial Probabilities Table
X	P(X)	P(<'=X)	P(<X)	P(>X)	P(>'=X)
0	=BINOM.DIST(A14, $B$4, $B$5, FALSE)	=BINOM.DIST(A14, $B$4, $B$5, TRUE)	=C14 - B14	=1 - C14	=1 - D14
1	=BINOM.DIST(A15, $B$4, $B$5, FALSE)	=BINOM.DIST(A15, $B$4, $B$5, TRUE)	=C15 - B15	=1 - C15	=1 - D15
2	=BINOM.DIST(A16, $B$4, $B$5, FALSE)	=BINOM.DIST(A16, $B$4, $B$5, TRUE)	=C16 - B16	=1 - C16	=1 - D16
3	=BINOM.DIST(A17, $B$4, $B$5, FALSE)	=BINOM.DIST(A17, $B$4, $B$5, TRUE)	=C17 - B17	=1 - C17	=1 - D17
4	=BINOM.DIST(A18, $B$4, $B$5, FALSE)	=BINOM.DIST(A18, $B$4, $B$5, TRUE)	=C18 - B18	=1 - C18	=1 - D18

CUMULATIVE_OLDER

Binomial Probabilities
Data
Sample size	4
Probability of an event of interest	0.1
Statistics
Mean	0.4
Variance	0.36
Standard deviation	0.6
Binomial Probabilities Table
X	P(X)	P(<=X)	P(<X)	P(>X)	P(>=X)
0	0.6561	0.6561	0.0000	0.3439	1.0000
1	0.2916	0.9477	0.6561	0.0523	0.3439
2	0.0486	0.9963	0.9477	0.0037	0.0523
3	0.0036	0.9999	0.9963	0.0001	0.0037
4	0.0001	1.0000	0.9999	0.0000	0.0001

CUMULATIVE_OLDER_FORMULAS

Binomial Probabilities
Data
Sample size	4
Probability of an event of interest	0.1
Statistics
Mean	=B4 * B5
Variance	=B8 * (1 - B5)
Standard deviation	=SQRT(B9)
Binomial Probabilities Table
X	P(X)	P(<'=X)	P(<X)	P(>X)	P(>'=X)
0	=BINOMDIST(A14, $B$4, $B$5, FALSE)	=BINOMDIST(A14, $B$4, $B$5, TRUE)	=C14 - B14	=1 - C14	=1 - D14
1	=BINOMDIST(A15, $B$4, $B$5, FALSE)	=BINOMDIST(A15, $B$4, $B$5, TRUE)	=C15 - B15	=1 - C15	=1 - D15
2	=BINOMDIST(A16, $B$4, $B$5, FALSE)	=BINOMDIST(A16, $B$4, $B$5, TRUE)	=C16 - B16	=1 - C16	=1 - D16
3	=BINOMDIST(A17, $B$4, $B$5, FALSE)	=BINOMDIST(A17, $B$4, $B$5, TRUE)	=C17 - B17	=1 - C17	=1 - D17
4	=BINOMDIST(A18, $B$4, $B$5, FALSE)	=BINOMDIST(A18, $B$4, $B$5, TRUE)	=C18 - B18	=1 - C18	=1 - D18