Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

GAMMADIST

Calculates the gamma distribution, a two-parameter continuous probability distribution.

 

Sample Usage

GAMMADIST(4.5,1.5,7,TRUE)
GAMMADIST(A2,A3,A4,FALSE)

Syntax

GAMMADIST(number, alpha, beta, cumulative)

  • number - The value on which the function will be evaluated.
  • alpha - A parameter to the distribution.
  • beta - A parameter to the distribution.
  • cumulative - A logical value that determines the form of the function.

 

Examples

GAMMADIST(4.5,1.5,7,TRUE) returns a value of 0.2674.
GAMMADIST(A2,A3,A4,FALSE) returns the cumulative gamma distribution function for the arguments specified in A2 through A4.
 

Notes

  • number, alpha and beta must be numeric.
  • alpha and beta must be greater than zero.
  • If alpha is less than or equal to 1 and cumulative is FALSE, then number must be greater than zero; otherwise, cumulative must be greater than or equal to zero.
  • GAMMADIST is synonymous with GAMMA.DIST