WorksheetFunction.ChiSq_Dist_RT Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .ChiSq_Dist_RT(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

The value at which you want to evaluate the distribution.

Arg2

Required

Double

The number of degrees of freedom.

Return Value

Double

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:

  • If either argument is nonnumeric, ChiSq_Dist_RT generates an error.

  • If x is negative, ChiSq_Dist_RT generates an error.

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

  • If degrees_freedom < 1 or degrees_freedom > 10^10, ChiSq_Dist_RT generates an error.

  • ChiSq_Dist_RT is calculated as ChiSq_Dist_RT = P(X>x), where X is a ?2 random variable.

Show: