{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# probdist - EXCEL Probability Distribution Functions Note...

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

EXCEL Probability Distribution Functions Note: The “=” before each function name causes EXCEL to use the function as opposed to simply typing it in as text. I. Common Discrete Distributions Binomial Distribution = BINOMDIST( x , n , p ,False) Probability of x successes in n trials with P (Success)= p n x p p x n x n p p x n x X P x n x x n x ,..., 1 , 0 ) 1 ( )! ( ! ! ) 1 ( ) ( = - - = - = = - - = BINOMDIST( x , n , p ,True) Probability of at most x successes in n trials with P (Success)= p n x p p k n x p p x X P x k k n k , , 1 , 0 ) 1 ( ) ( ) 0 ( ) ( 0 = - = + + = = - Geometric/Negative Binomial Distribution =NEGBINOMDIST( x , r , p ) Probability of having x failures prior to the r th success in independent Bernoulli trials with P (Success)= p . This is equivalent to observing the r th success on the ( x+r ) th trial. Geometric distribution arises when r = 1. ,... 2 , 1 ,... 2 , 1 , 0 ) 1 ( 1 1 = = - - - + r x p p r r x x r

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

View Full Document
Poisson Distribution = POISSON( x , λ ,False) Probability of x outcomes when X ~Poisson( λ ) ,... 1 , 0 ! ) ( = = = - x x e x X P x λ λ = POISSON( x , λ ,TRUE) Probability of at most x outcomes when X ~Poisson( λ ) ,... 1 , 0 ! ) ( 0 = = - = x k e x X P k x k λ λ Hypergeometric Distribution =HYPGEOMDIST( x , n,k,N ) Probability of x successes in n Trials in population with k Successes in N elements N n x N k x n N x n k N x k x X P - - = = 0 0 ) ( II. Common Continuous Distributions
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 7

probdist - EXCEL Probability Distribution Functions Note...

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

View Full Document
Ask a homework question - tutors are online