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

GAMMA.DIST

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

 

Sample Usage

GAMMA.DIST(4.5,1.5,7,TRUE)
GAMMA.DIST(A2,A3,A4,FALSE)

Syntax

GAMMA.DIST(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

GAMMA.DIST(4.5,1.5,7,TRUE) returns a value of 0.2674.
GAMMA.DIST(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.
  • GAMMA.DIST is synonymous with GAMMADIST