# probdist - EXCEL Probability Distribution Functions Note:...

This preview shows pages 1–4. 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
Exponential Distribution (Hardly worth the effort. Note: must use reciprocal of mean)

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.

## This note was uploaded on 06/04/2011 for the course STA 4321 taught by Professor Staff during the Spring '08 term at University of Florida.

### Page1 / 7

probdist - EXCEL Probability Distribution Functions Note:...

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

View Full Document
Ask a homework question - tutors are online