Returns the left tail probability of the χ2 distribution.
Grammar
CHISQ.DIST(x, deg_freedom, cumulative)
x is the numerical value used to calculate the distribution.
Deg_freedom Number of degrees of freedom.
cumulative CHISQ.DIST returns the cumulative distribution function if cumulative is TRUE, or the probability density function if cumulative is FALSE.
Description
If any argument is nonnumeric, CHISQ.DIST returns the #VALUE! error value.
If x is negative, CHISQ.DIST returns the #NUM! error value.
If deg_freedom is not an integer, it will be truncated.
If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.DIST returns the #NUM! error value.
When doing probability calculations, we will use the CHISQ.DIST function.
The main function of its function is to calculate the left tail probability of the χ2 distribution.
Next, I will show you the specific steps of using this function in this table.
Select cell B3 and click Insert Function.
Find and select the CHISQ.DIST function in the search box and click OK.
A dialog box pops up with three parameters.
The value is used to calculate the probability of the left tail of the χ2 distribution. It is a non-negative number. Fill in B1 here.
The degrees of freedom are between 1 and
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ying-yong-CHISQ-DIST-han-shu-jin-xing-ka-fang-fen-bu-ji-suan.html
评论列表(196条)
测试