tarea excel proes

Post on 11-Apr-2016

233 Views

Category:

Documents

4 Downloads

Preview:

Click to see full reader

DESCRIPTION

excel

TRANSCRIPT

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)

top related