How to use the CHISQ.TEST function in Excel Worksheet?

#tousethechisqtestfun #excel #excelfunctions

The CHISQ.TEST function in Excel returns the chi-squared probability of something across datasets. The function takes the actual dataset and expected dataset as arguments and returns the probability relation between the two. In this tutorial, we are going to see how to use the CHISQ.TEST 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.TEST Function syntax

=CHISQ.TEST(actual_range , expected_range)

Syntax Explanation:

actual_range : actual range or observed range.
expected_range : expected range before the actual range.

Example 1

Firstly, you have to create a sample dataset of dress styles worn by men.
Then, the manufacturing company decided to measure the p value relation between the observed sales and actual sales.

Now, for the given chi square distributed dataset, you need to find the relation using the formula.

=CHISQ.TEST(B3:B10,C3:C10)

After that, you can see the test returned around 0.97 or 97% relation between the two, it means the observed sales is close to the expected sales result.

Example 2

Firstly, you have to create a sample dataset of dress styles worn by women.
Then, the manufacturing company decided to measure the p value relation between the observed sales and actual sales.

Now, for the given chi square distributed dataset, you need to find the relation using the formula.

 =CHISQ.TEST(B3:B10,C3:C10)

Finally, the p value for the calculated by chi square test comes out to be 0.0014 which is even less than 1.

NOTE:

The CHISQ.TEST Function only works with numbers.
If any argument other than cumulative is non-numeric , the function considers the non-numeric value as 0 and returns the result.
Then, the value in decimal and value in percentage is the same value in Excel and convert the value to percentage , if required.
Now, the function returns #N/A error if the length of the two range arguments is not equal or the dataset contains only one value, i.e. the length and width equal to 1.
After that, the function returns #DIV/0 error if any of the values provided in expected_range is zero.
Finally, the function returns #NUM! Error , if any number in range is negative.

Closure

From this article, you can get to know the formulas for how to use the CHISQ.TEST Function In Excel Office 365. Hope that this article is useful to you. Kindly, drop your feedback in the below sections. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!

Related Articles:

Built for developers, by developers.

Whether you're building a simple prototype or a business-critical product, Heroku's fully-managed platform gives you the simplest path to delivering apps quickly — using the tools and languages you already love!

Learn More