130 stats

katherinabe
ProbabilityDistributionDiscretBINOMIAL1.xlsx
Home>Mathematics homework help>Statistics homework help>130 stats

Binomial

X P ( X = x ) p =.30 n = 7
0 0.082 P(X < 5 ) =
1 0.247 Use BINOM.DIST()
2 0.318 =BINOM.DIST(4,7,0.3,TRUE)
3 0.227 0.9712
4 0.097 < ------ P ( X = 4 )
5 0.025 =BINOM.DIST(4,7,0.3,FALSE)
6 0.004 0.097
7 0

Sheet6

x
QUANTITY PURCHASED PER PERSON IN ONE MONTH
# of six packs purchased # people who purchased this amount P ( X = x ) x * P ( x = x ) x2 * P ( X = x )
0 7
1 6
2 6
3 12
4 14
5 12
6 10
7 8
8 5
9 5
10 3
88 S S S
Definition
Mean S ( x * P ( X )
Variance S (x2 * P ( X = x ) - mean2
Standard Deviation Sqrt (variance)

Sheet3

x
QUANTITY PURCHASED PER PERSON IN ONE MONTH
# of six packs purchased # people who purchased this amount P ( X = x ) x * P ( x = x ) x2 * P ( X = x ) (x-u)^2 (x-u)^2*P(x)
0 7 0.0795 0 0.000 20.77 1.652
1 6 0.0682 0.068 0.068 12.65 0.863
2 6 0.0682 0.136 0.273 6.54 0.446
3 12 0.1364 0.409 1.227 2.42 0.331
4 14 0.1591 0.636 2.545 0.31 0.049
5 12 0.1364 0.682 3.409 0.20 0.027
6 10 0.1136 0.682 4.091 2.08 0.237
7 8 0.0909 0.636 4.455 5.97 0.543
8 5 0.0568 0.455 3.636 11.85 0.674
9 5 0.0568 0.511 4.602 19.74 1.122
10 3 0.0341 0.341 3.409 29.63 1.010
88 4.557 27.716 6.951
Definition
Mean S ( x * P ( X ) 4.557
Variance S (x2 * P ( X = x ) - mean2 6.950
Standard Deviation Sqrt (variance) 2.636

NORM

0.5 0.5
0.95
0.5 0.45
0.05
m = 0 ???
s = 1
To get values on the line
??? Use NORM.INV
=NORM.INV(0.95,0,1)
1.645
To get values inside the curve (i.e. probability)
use NORM.DIST
=NORM.DIST(1.644854,0,1,TRUE)
0.9500000385