probdist - EXCEL Probability Distribution Functions Note:...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Exponential Distribution (Hardly worth the effort. Note: must use reciprocal of mean)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
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 Right Arrow Icon
Ask a homework question - tutors are online