Tarea Excel Proes

Post on 11-Apr-2016

233 views 4 download

description

excel

Transcript of Tarea Excel Proes

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)