BINOMIAL DISTRIBUTION EXCEL

# BINOMIAL DISTRIBUTION EXCEL - 0.193536 0.0774144 0.0172032...

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

BINOMIAL DISTRIBUTION Characteristics Sample of size n is observed Result of each observation is either success = 1 of failure = 0 The observations are independent so that the probability of success on any observation = p EXCEL BINOMDIST(k,n,p,FALSE) = P(X=k) in a sample of size n with probability p on any single observation BINOMDIST(k,n,p,TRUE) = P(X k) in a sample of size n with probability p on any single observation Examples Example 1 P(X=4) When n = 7, p = .4 0.0279936 0.1306368 0.2612736 0.290304 0.193536 0.0774144 0.0172032 0.0016384 0 0.05 0.1 0.15 0.2 0.25 0.3 0.35 0 1 2 3 4 5 6 7 X P(X) P(X=4) =BINOMDIST(4,7,.4,FALSE) .193536

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

View Full Document
Example 2 P(X<=2) When n = 7, p = .4 0.0279936 0.1306368 0.2612736 0.290304

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.193536 0.0774144 0.0172032 0.0016384 0.05 0.1 0.15 0.2 0.25 0.3 0.35 1 2 3 4 5 6 7 X P(X) P(X<=2) =BINOMDIST(2,7,.4,TRUE) .419904 Example 3 P(X>=5) When n = 7, p = .4 =1-P(X<=4) 0.0279936 0.1306368 0.2612736 0.290304 0.193536 0.0774144 0.0172032 0.0016384 0.05 0.1 0.15 0.2 0.25 0.3 0.35 1 2 3 4 5 6 7 X P(X) P(X>=5) 1-BINOMDIST(4,7,.4,TRUE) .096256 Example 4 P(3<=X<=5) When n = 7, p = .4 =P((X<=5) - P(X<=2) 0.0279936 0.1306368 0.2612736 0.290304 0.193536 0.0774144 0.0172032 0.0016384 0.05 0.1 0.15 0.2 0.25 0.3 0.35 1 2 3 4 5 6 7 X P(X) P(3<=X<=5) =BINOMDIST(5,7,.4,TRUE) -BINOMDIST(2,7,.4,TRUE) .561254...
View Full Document

## This note was uploaded on 08/29/2011 for the course STATISTICS 361 taught by Professor Gupta during the Spring '11 term at California State University , Monterey Bay.

### Page1 / 4

BINOMIAL DISTRIBUTION EXCEL - 0.193536 0.0774144 0.0172032...

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

View Full Document
Ask a homework question - tutors are online