tarea excel proes
DESCRIPTION
excelTRANSCRIPT
Binomial distribution
30 n0.2 p
cumulativeX P(X) probability0 0.00124 0.001241 0.00928 0.010522 0.03366 0.044183 0.07853 0.122714 0.13252 0.255235 0.17228 0.427516 0.17946 0.606977 0.15382 0.760798 0.11056 0.871359 0.06756 0.93891
10 0.03547 0.9743811 0.01612 0.9905112 0.00638 0.9968913 0.00221 0.9991014 0.00067 0.9997715 0.00018 0.9999516 0.00004 0.9999917 0.00001 1.0000018 0.00000 1.0000019 0.00000 1.0000020 0.00000 1.0000021 0.00000 1.0000022 0.00000 1.0000023 0.00000 1.0000024 0.00000 1.0000025 0.00000 1.0000026 0.00000 1.0000027 0.00000 1.0000028 0.00000 1.0000029 0.00000 1.0000030 0.00000 1.00000
1.00000
6.000 expected value4.800 variance2.191 standard deviation
0 1 2 3 4 5 6 7 8 9 1011121314151617181920212223242526272829300.00
0.02
0.04
0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
Binomial distribution (n = 30, p = 0.2)
X
P(X)
Binomial distribution
20 n0.03 p
cumulativeX P(X) probability0 0.54379 0.543791 0.33637 0.880162 0.09883 0.978993 0.01834 0.997334 0.00241 0.999745 0.00024 0.999986 0.00002 1.000007 0.00000 1.000008 0.00000 1.000009 0.00000 1.00000
10 0.00000 1.0000011 0.00000 1.0000012 0.00000 1.0000013 0.00000 1.0000014 0.00000 1.0000015 0.00000 1.0000016 0.00000 1.0000017 0.00000 1.0000018 0.00000 1.0000019 0.00000 1.0000020 0.00000 1.00000
1.00000
0.600 expected value0.582 variance0.763 standard deviation
0 1 2 3 4 5 6 7 8 9 1011121314151617181920212223242526272829300.00
0.02
0.04
0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
Binomial distribution (n = 30, p = 0.2)
X
P(X)
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 200.00
0.10
0.20
0.30
0.40
0.50
0.60
Binomial distribution (n = 20, p = 0.03)
X
P(X)
9.-
7,56665496 × 10¯³
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 200.00
0.10
0.20
0.30
0.40
0.50
0.60
Binomial distribution (n = 20, p = 0.03)
X
P(X)
NIVEL II5.-
a) 0.13252b) 0.00124c) 0.12271d) 0.95582e) Media 0.03226
Varianza 4.800
1,24 × 10¯³
0 1 2 3 4 5 6 7 8 9 1011121314151617181920212223242526272829300.00
0.02
0.04
0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
Binomial distribution (n = 30, p = 0.2)
X
P(X)
6.-
a) 0.97899b)
0 1 2 3 4 5 6 7 8 9 1011121314151617181920212223242526272829300.00
0.02
0.04
0.06
0.08
0.10
0.12
0.14
0.16
0.18
0.20
Binomial distribution (n = 30, p = 0.2)
X
P(X)
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 200.00
0.10
0.20
0.30
0.40
0.50
0.60
Binomial distribution (n = 20, p = 0.03)
X
P(X)
10.-
a) 0.134 13.40%b)
NIVEL III
3.-
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 200.00
0.10
0.20
0.30
0.40
0.50
0.60
Binomial distribution (n = 20, p = 0.03)
X
P(X)