Table of Contents
This guide explains how to use CHIDIST Function in Excel, including its syntax, required arguments, practical examples, and common errors.
Description: The function returns the probability of the right end of a distribution when squared.
Syntax: CHIDIST (x, deg_freedom) .
Inside:
- x : Value to evaluate distribution, is a required parameter.
- deg_freedom : the number of degrees of freedom for x, is a required parameter.
Attention:
- x, deg_freedom: required in numeric format otherwise returns the #VALUE! value.
- Where x The function returns the value #NUM!.
- Where deg_freedom is not an integer => the function takes the integer part of deg_freedom.
- Where deg_freedom 10 => The function returns the value #NUM!.
- CHDIST is calculated by CHDIST = P (X> x) where X is a random variable of χ2.
Example: Calculate the probability value of a distribution with the following data table:
In the cell to calculate, enter the formula: CHDIST (D5, D6) .
Value results:
- Where the degrees of freedom are decimal functions take integers:
The probability value result is equal to the value when the number of degrees of freedom is 32.
- If the number of degrees of freedom is less than 0 => The error function #NUM!
Above is the usage and some special cases when using the CHDIST function. Hope to help you.
Good luck!
FAQ
What does the CHIDIST function do in Excel?
The CHIDIST function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the CHIDIST function correctly?
Start with an equals sign, enter CHIDIST, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the CHIDIST function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.