Как пользоваться функцией GAMMA в Excel
Русский | Английский |
---|---|
ГАММА | GAMMA |
The GAMMA function in MS Excel and Google Sheets is designed to calculate the gamma function of a given number.
Syntax
The syntax for the GAMMA function is:
GAMMA(number)
where:
number
— is the number for which the gamma function needs to be computed.
Usage Examples
Example 1: Calculating the gamma function for the number 5.
Data | Result |
---|---|
5 | =GAMMA(5) |
The result is 24 (the gamma function for the number 5 equals 24).
Example 2: Using the GAMMA function in a formula to compute the factorial of the number 6.
Data | Result |
---|---|
6 | =GAMMA(6+1) |
The result is 720 (the factorial of the number 6 is 720, calculated using GAMMA(6+1)).
The GAMMA function can be incredibly useful for tasks involving probability distributions, statistical calculations, and other scenarios that require the computation of the gamma function.
Больше информации: https://support.microsoft.com/ru-ru/office/гамма-функция-гамма-ce1702b1-cf55-471d-8307-f83be0fc5297