Difference between revisions of "Documentation/How Tos/Calc: GAMMADIST function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
(→Syntax:) |
||
Line 11: | Line 11: | ||
: If mode is <tt>'''1'''</tt>, <tt>'''GAMMADIST'''</tt> calculates the cumulative distribution function of the gamma distribution. | : If mode is <tt>'''1'''</tt>, <tt>'''GAMMADIST'''</tt> calculates the cumulative distribution function of the gamma distribution. | ||
+ | |||
+ | : <tt>'''x'''</tt> must be greater than or equal to <tt>'''0'''</tt>. | ||
=== Example: === | === Example: === |
Revision as of 12:07, 26 April 2008
GAMMADIST
Calculates values for a gamma distribution.
Syntax:
GAMMADIST(x; α; λ; mode)
- The gamma distribution is a family of continuous probability distributions, with two controlling parameters α and λ.
- If mode is 0, GAMMADIST calculates the probability density function of the gamma distribution.
- If mode is 1, GAMMADIST calculates the cumulative distribution function of the gamma distribution.
- x must be greater than or equal to 0.
Example:
GAMMADIST(2; 1; 1; 1)
- returns approximately 0.86.