Syntax
=GAMMA.DIST(x, alpha, beta, cumulative)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The value (0 or more) |
alpha | Required | The shape (positive) |
beta | Required | The scale (positive) |
cumulative | Required | TRUE for the cumulative distribution, FALSE for the density |
How to use GAMMA.DIST
GAMMA.DIST takes 4 required arguments. Type =GAMMA.DIST( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=GAMMA.DIST(10.00001131, 9, 2, FALSE)Result =GAMMA.DIST(10.00001131, 9, 2, TRUE)Result Related statistical functions
- FORECAST.ETS.STATReturns a statistic of the exponential smoothing model: 1 alpha, 2 beta, 3 gamma, 4 MASE, 5 SMAPE, 6 MAE, 7 RMSE, 8 step size.
- FORECAST.LINEARPredicts a value for x from the straight line that best fits known x and y values.
- FREQUENCYCounts how many values fall into each bin and returns a vertical list with one more entry than there are bins.
- GAMMAReturns the gamma function value.
- GAMMA.INVReturns the inverse of the cumulative gamma distribution.
- GAMMALNReturns the natural logarithm of the gamma function.
- GAMMALN.PRECISEReturns the natural logarithm of the gamma function.
- GAUSSReturns the probability that a standard normal value lies between the mean and z standard deviations from it.
- GEOMEANReturns the geometric mean of positive numbers.