POISSON DISTRIBUTION EXCEL

POISSON DISTRIBUTION EXCEL - 0.149361205 0.224041808...

This preview shows pages 1–5. Sign up to view the full content.

POISSON DISTRIBUTION Characteristics A time interval of size t is observed No two events occur simultaneously P(k events in the interval) does not depend on when the interval occurs The time until the next event is independent of when the last event occurred The average number of events in an interval of size t is λ EXCEL POISSON(k, λ ,FALSE) = P(X=k) in an interval in which the average number of events is λ POISSON(k, λ ,TRUE) = P(X k) in an interval in which the average number of events is λ Examples Example 1 Poisson Probablity for lambda = 3 P(X=4) 0.049787068 0.149361205 0.224041808 0.224041808 0.168031356 0.100818813 0.050409407 0.021604031 0.008101512 0 0.05 0.1 0.15 0.2 0.25 0 1 2 3 4 5 6 7 8 X P(X) P(X=4) =POISSON(4,3,FALSE) .168031

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Example 2 Poisson Probablity for lambda = 3 P(X<=2) 0.049787068

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0.149361205 0.224041808 0.224041808 0.168031356 0.100818813 0.050409407 0.021604031 0.008101512 0.05 0.1 0.15 0.2 0.25 1 2 3 4 5 6 7 8 X P(X) P(X<=2) =POISSON(2,3,TRUE) .423190 Example 3 Poisson Probablity for lambda = 3 P(X>=5) 0.049787068 0.149361205 0.224041808 0.224041808 0.168031356 0.100818813 0.050409407 0.021604031 0.008101512 0.05 0.1 0.15 0.2 0.25 1 2 3 4 5 6 7 8 X P(X) P(X>=5) =1-POISSON(4,3,TRUE) .184737 Example 4 Poisson Probablity for lambda = 3 P(3<=X<=5) 0.049787068 0.149361205 0.224041808 0.224041808 0.168031356 0.100818813 0.050409407 0.021604031 0.008101512 0.05 0.1 0.15 0.2 0.25 1 2 3 4 5 6 7 8 X P(X) P(3<=X<=5) = POISSON(5,3,TRUE)-POISSON(2,3,TRUE) .492892...
View Full Document

{[ snackBarMessage ]}

Page1 / 5

POISSON DISTRIBUTION EXCEL - 0.149361205 0.224041808...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online