CHISQ.DIST.RT
Definition
Returns the right-tailed probability of the chi-squared distribution.
The χ2 distribution is associated with a χ2 test. Use the χ2 test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.
Sample Usage
Syntax
CHISQ.DIST.RT(x,deg_freedom)
The CHISQ.DIST.RT function syntax has the following arguments:
X Required. The value at which you want to evaluate the distribution.
Deg_freedom Required. The number of degrees of freedom.
Remarks
If either argument is nonnumeric, CHISQ.DIST.RT function returns the #VALUE! error value.
If any argument is nonnumeric, CHISQ.DIST.RT function returns the #VALUE! error value.
If deg_freedom is not an integer, it is truncated.
If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.DIST.RT returns the #NUM! error value.
In order to use the CHISQ.DIST.RT formula, start with your edited Excellentable:
Then type in the CHISQ.DIST.RT formula in the area you would like to display the outcome:
By adding the values you would like to calculate the CHISQ.DST.RT formula for, Excellentable will generate the outcome:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|
||
4
|
||
5
|
||
6
|
