Buzz
This article introduces you to the CHISQ.DIST.RT function – one of the statistical functions widely favored in Excel.
Description: Returns the probability on the right side of the distribution when squared. Supported since Excel 2010.
Syntax: CHISQ.DIST.RT(x,deg_freedom)
In this context:
- x: Value to assess distribution.
- deg_freedom: Degree of freedom.
Note:
- If any parameter is non-numeric -> the function returns the error value #VALUE!
- If deg_freedom is not an integer -> it gets truncated to an integer.
- If deg_freedom < 1 or deg_freedom > 10^10 -> the function returns the error value #NUM!
Example:
Calculate the probability on the right side of the squared distribution based on the data in the table below:
- In the cell where you want to calculate, enter the formula: =CHISQ.DIST.RT(C6,C7)
- Press Enter -> the probability on the right side of the squared distribution is:
- If any parameter is non-numeric -> the function returns the error value #VALUE!
- If the degree of freedom is less than 1 or greater than 10^10 -> the function returns the error value #NUM!
Here is a guide and some specific examples of using the CHISQ.DIST.RT function in Excel.
Wishing you all success!
