GAMMA.DIST (PQL - xl)

This function returns the gamma distribution

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

GAMMA.DIST(x, alpha, beta, cumulative)

Function Arguments

Name

Description

Type

Optional

x

Value at which to evaluate the distribution

Number

alpha

Alpha parameter of the distribution

Number

beta

Beta parameter of the distribution

Number

cumulative

Logical value that determines the form of the function. If cumulative is TRUE, then this function returns the cumulative distribution function; if FALSE, it returns the probability density function

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'GAMMA.DIST' function - using the same inputs, logic and outputs.