WorksheetFunction.ChiSq_Dist_RT(Double, Double) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 double ChiSq_Dist_RT(double Arg1, double Arg2);

public double ChiSq_Dist_RT (double Arg1, double Arg2);

Public Function ChiSq_Dist_RT (Arg1 As Double, Arg2 As Double) As Double

Parameters

Arg1: Double

The value at which you want to evaluate the distribution.

Arg2: Double

The number of degrees of freedom.

Returns

Double

Remarks

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.

Applies to