How to use the CHISQ.TEST function in Excel Worksheet?
Tags: tousethechisqtestfun, excel, excelfunctions
Published: 2021-08-23 11:52:42

---
title: How to use the CHISQ.TEST function in Excel Worksheet?
published: true
date: 2021-08-17 18:08:51 UTC
tags: ToUseTheCHISQTESTFun,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-chisq-test-function-in-excel-worksheet/
---

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](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**.

![](https://geekexcel.com/wp-content/uploads/2021/08/women-clothes-data.png)<figcaption>Men’s clothes sample data</figcaption>

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

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

![](https://geekexcel.com/wp-content/uploads/2021/08/for-men-value-1024x542.png)<figcaption>Use the formula for test value</figcaption>

- 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**.

![](https://geekexcel.com/wp-content/uploads/2021/08/women-sample-data.png)<figcaption>Women sample data</figcaption>

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

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

![](https://geekexcel.com/wp-content/uploads/2021/08/women-value-1024x540.png)<figcaption>Women test value</figcaption>

- 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](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[Insert Sheet in Microsoft Excel 2007?](https://geekexcel.com/insert-sheet-in-microsoft-excel-2007/)**
- **[Excel Formulas to Test if the Cell Contains all of Many Things ~ Easy Tips!!](https://geekexcel.com/excel-formulas-cell-contain-all-of-many-things/)**
- **[Excel Formulas to Test the Cells that Contains Specific Text!!](https://geekexcel.com/excel-formulas-to-test-the-cell-that-contains-specific-text/)**