Как пользоваться функцией CHISQ.DIST в Excel
| Русский | Английский |
|---|---|
| ХИ2.РАСП | CHISQ.DIST |
The CHISQ.DIST function in Excel and Google Sheets is used to calculate the probability density function or the cumulative distribution function of the chi-square (χ²) distribution for a given value and degrees of freedom. The chi-square distribution is widely used in working with sample data and statistical tests.
Syntax and Arguments
In Excel, the CHISQ.DIST function has the following syntax:
CHISQ.DIST(x, degrees_freedom, cumulative)x— The value at which the chi-square distribution is evaluated.degrees_freedom— The number of degrees of freedom in the distribution.cumulative— A logical value that determines the function type (TRUE for cumulative distribution function, FALSE for probability density function).
The syntax for the CHISQ.DIST function in Google Sheets is similar:
CHISQ.DIST(x, degrees_freedom, cumulative)The arguments are the same: x — value evaluation, degrees_freedom — degrees of freedom, cumulative — function type.
Examples
1. Calculating the chi-square distribution value for a given value and degrees of freedom.
Example in Excel:
| x | Degrees of Freedom | Cumulative? | CHISQ.DIST |
|---|---|---|---|
| 3 | 2 | TRUE | =CHISQ.DIST(3, 2, TRUE) |
2. Calculating the probability density value of the chi-square distribution for a specified point and degrees of freedom.
Example in Google Sheets:
| x | Degrees of Freedom | Cumulative? | CHISQ.DIST |
|---|---|---|---|
| 4 | 3 | FALSE | =CHISQ.DIST(4, 3, FALSE) |
The CHISQ.DIST function facilitates the handling of chi-square distributions in Excel and Google Sheets, which is invaluable for analyzing statistical data and hypothesis testing.
Больше информации: https://support.microsoft.com/ru-ru/office/функция-хи2-расп-8486b05e-5c05-4942-a9ea-f6b341518732