MSIS 111 PROBABILITY EXCEL

profileAlibrea Tuskata
Chapter5CengageExcelDemoBinomDist11.xlsx
Home>Computer Science homework help>MSIS 111 PROBABILITY EXCEL

Sheet1

n trials 20
p probability 0.7
x Variale subject to change
f(12) 0.1143967397
f(16) 0.1304209744
f(x ≥ 16) 0.7624922211 0.7624922211 16 0.1304209744
0.2375077789 17 0.0716036722
18 0.0278458725
19 0.0068393371
20 0.0007979227
f(x ≤ 15) 0.7624922211 0.2375077789
E(x) 14
n*p
(Variance(x) 4.2
n*p (1-p)
Standard Deviation 2.0493901532
sqrt of variance

Compute the Binomial formula, where: n =20 and p = .70