Statistical - CHISQ.DIST.RT Function



Description

The CHISQ.DIST.RT function returns the right-tailed probability of the chi-squared distribution.

The X2 distribution is associated with a X2 test. Use the X2 test to compare observed and expected values. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.

Syntax

CHISQ.DIST.RT(x,deg_freedom)

Arguments

Argument Description Required/ Optional
X The value at which you want to evaluate the distribution. Required
Deg_freedom The number of degrees of freedom. Required

Notes

  • If deg_freedom is not an integer, it is truncated.

  • 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 < 1 or deg_freedom > 10^10, CHISQ.DIST.RT returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

ChisqDistRt Function
advanced_excel_statistical_functions.htm
Advertisements