Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > GAMMADIST
 

GAMMADIST(x, alpha, beta, cumulative)

 
 Returns the gamma distribution.

 xThe value at which you want to evaluate the distribution.
 alphaThe first parameter to the distribution.
 betaThe second parameter to the distribution.
 cumulativeTrue or False to specify the form of the function.

 REMARKS
 
  		• If "x" < 0, then #NUM! is returned.
     
  		• If "x" is not numeric, then #VALUE! is returned.
     
  		• If "alpha" = 0, then #NUM! is returned.
     
  		• If "alpha" is not numeric, then #VALUE! is returned.
     
  		• If "beta" = 1, then the standard gamma distribution is used.
     
  		• If "beta" = 0, then #NUM! is returned.
     
  		• If "beta" is not numeric, then #VALUE! is returned.
     
  		• If "cumulative" = True the cumulative distribution function is used.
     
  		• If "cumulative" = False then probability mass function is used.
     
  		• For a positive integer n, when alpha = n/2, beta = 2, and cumulative = TRUE, GAMMADIST returns (1 - CHIDIST(x)) with n degrees of freedom.
     
  		• When alpha is a positive integer.
     
  		• This function is also known as the Erlang distribution.

     EXAMPLES
     
     A
    1=GAMMADIST(10,9,2,FALSE) = 0.033
    2=GAMMADIST(10,9,2,TRUE) = 0.068
    3=GAMMADIST(10,10,5,TRUE) = 0
    4=GAMMADIST(7,5,1,TRUE) = 1
    5=GAMMADIST(10,9,0,TRUE) = #NUM!
    6=GAMMADIST(10,-2,2,TRUE) = #NUM!
    7=GAMMADIST(-1,9,2,TRUE) = #NUM!
    8=GAMMADIST(-1,"some text",2,TRUE) = #VALUE!
    9=GAMMADIST(-1,9,2,"some text") = #VALUE!
    		 
     Functions - G | Index - G | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top