DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to use the CHISQ.DIST function in Excel office 365?

#tousethechisqdistfun #excel #excelfunctions

The CHISQ.DIST function in Excel returns the chi-squared percentage of something across samples, such as the fraction of the day people spend watching television. The function takes variables and degrees of freedom for the distribution, along with the type of distribution. In this tutorial, we are going to see how to use the CHISQ.DIST Function In Excel Office 365. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

CHISQ.DIST Function syntax 

=CHISQ.DIST(x , deg_freedom , cumulative)
Enter fullscreen mode Exit fullscreen mode

Syntax Explanation:

  • x : value at which distribution is evaluated.
  • deg_freedom : degrees of freedom.
  • cumulative : logical value that determines the form of the function. If cumulative is TRUE , CHISQ.DIST returns the cumulative distribution function ; if FALSE , it returns the probability density function.

Example

  • Firstly, you have to create a sample variable x ** and **degree of freedom.

Sample data

  • Then, you have to calculate the chi square percentage using the CHISQ.DIST function in Excel.
  • Now, you need to use the following formula given below. 
=CHISQ.DIST(B2 , B3 , TRUE)
Enter fullscreen mode Exit fullscreen mode

probability mass distribution

  • After that, the chi square value is in decimal you can convert the value to percentage , by changing the format of the cell to percentage.

Change to percentage

  • Then, the chi square value at least 0.5 comes out to be 22 % for the probability mass distribution.
  • Now, you have to calculate chi square PDF or probability density value for the same parameters.
  • You need to use the following formula given below. 
=CHISQ.DIST(B2 , B3 , FALSE)
Enter fullscreen mode Exit fullscreen mode

Cumulative distribution

NOTE:

  • The CONFIDENCE.NORM Function only works with numbers.
  • If any argument other than cumulative is non-numeric , the function returns #VALUE! error.
  • The function returns #NUM! Error.
    • If x is negative
    • If the degree of freedom is < 1 or >10^10.
  • Now, the cumulative argument can be used with boolean numbers (0 and 1) or (FALSE or TRUE).
  • The value in decimal and value in percentage is the same value in Excel and convert the value to percentage , if required.
  • Finally, you can feed the arguments to the function directly or using the cell reference, as explained in the example.

Verdict

We hope that this short tutorial gives you guidelines to use the CHISQ.DIST Function In Excel Office 365. ** Please leave a comment in case of any **queries, and don’t forget to mention your valuable suggestions as well. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!

Keep Reading:

Top comments (0)