CHISQ. DIST. RT Function in Excel

This guide provides a practical overview of CHISQ. DIST. RT Function, including its main features, benefits, limitations, and important considerations.

CHISQ. DIST. RT Function in Excel screenshot

Description: The function returns the probability of the right end of the distribution when squared. Support function from Excel 2010 version.

Syntax: CHISQ. DIST. RT (x, deg_freedom)

Inside:

- x: Value to evaluate distribution.

- deg_freedom: Number of degrees of freedom.

Attention:

- If any value of the parameter is not numeric -> the function returns the error value #VALUE!

- If deg_freedom is not an integer -> it is truncated to an integer.

- If deg_freedom <1 or deg_freedom> 10 ^ 10 -> the function returns the #NUM! Error value

For example:

Calculate the probability of right end when the square of the distribution according to the data in the table below:

CHISQ. DIST. RT Function in Excel screenshot 2

- In the cell to calculate enter the formula: = CHISQ. DIST. RT (C6, C7)

CHISQ. DIST. RT Function in Excel screenshot 3

- Press Enter -> probability of the right end of the distribution when the square is:

CHISQ. DIST. RT Function in Excel screenshot 4

- Case 1 of the values of the parameters is not a number -> the function returns the error value #VALUE!

CHISQ. DIST. RT Function in Excel screenshot 5

- If the number of degrees of freedom is less than 1 or greater than 10 ^ 10 -> the function returns the #NUM! Error value

CHISQ. DIST. RT Function in Excel screenshot 6

Above are instructions and some specific examples when using the CHISQ. DIST. RT function in Excel.

Good luck!

FAQ

What does the CHISQ. DIST. RT Function function do in Excel?

The CHISQ. DIST. RT Function function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.

How do I enter the CHISQ. DIST. RT Function function correctly?

Start with an equals sign, enter CHISQ. DIST. RT Function, add the required arguments inside parentheses, and confirm that cell references and separators are correct.