Как пользоваться функцией 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