What is the syntax for CHISQ.DIST.RT in Excel?

The syntax for CHISQ.DIST.RT is: =CHISQ.DIST.RT(x, deg_freedom)

What are common errors with CHISQ.DIST.RT?

#NUM! if deg_freedom < 1 or x < 0

How do I use the CHISQ.DIST.RT function?

To use CHISQ.DIST.RT, type =CHISQ.DIST.RT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does CHISQ.DIST.RT work with?

CHISQ.DIST.RT works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is CHISQ.DIST.RT not working in my Excel?

Common issues with CHISQ.DIST.RT include #NUM! if deg_freedom < 1 or x < 0. Start by checking the syntax =CHISQ.DIST.RT(x, deg_freedom), then verify each referenced cell or range.

Statistical

CHISQ.DIST.RT Function in Excel

Q: What is the CHISQ.DIST.RT function in Excel?

Returns the right-tailed probability of the chi-squared distribution.

Q: How do I use the CHISQ.DIST.RT function?

To use CHISQ.DIST.RT, type =CHISQ.DIST.RT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

Q: What type of data does CHISQ.DIST.RT work with?

CHISQ.DIST.RT works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Q: Why is CHISQ.DIST.RT not working in my Excel?

Common issues with CHISQ.DIST.RT include #NUM! if deg_freedom < 1 or x < 0. Start by checking the syntax =CHISQ.DIST.RT(x, deg_freedom), then verify each referenced cell or range.

Returns the right-tailed probability of the chi-squared distribution.

Syntax

=CHISQ.DIST.RT(x, deg_freedom)

Arguments

x (required): The value at which to evaluate the distribution
deg_freedom (required): The number of degrees of freedom

Examples

=CHISQ.DIST.RT(18.307, 10) - Right-tail probability - Result: 0.05

CHISQ.DIST.RT for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

#NUM! if deg_freedom < 1 or x < 0

Use cases

Hypothesis testing
Goodness of fit tests
Independence tests

Frequently asked questions

What is the CHISQ.DIST.RT function in Excel? CHISQ.DIST.RT returns the right-tailed probability of the chi-squared distribution. The syntax is =CHISQ.DIST.RT(x, deg_freedom). Typical use cases include hypothesis testing, goodness of fit tests, independence tests.
How do I use the CHISQ.DIST.RT function? To use CHISQ.DIST.RT, type =CHISQ.DIST.RT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does CHISQ.DIST.RT work with? CHISQ.DIST.RT works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is CHISQ.DIST.RT not working in my Excel? Common issues with CHISQ.DIST.RT include #NUM! if deg_freedom < 1 or x < 0. Start by checking the syntax =CHISQ.DIST.RT(x, deg_freedom), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.