How to use the CHISQ.DIST function in Excel office 365?
Tags: tousethechisqdistfun, excel, excelfunctions
Published: 2021-08-23 11:52:51

---
title: How to use the CHISQ.DIST function in Excel office 365?
published: true
date: 2021-08-17 18:09:02 UTC
tags: ToUseTheCHISQDISTFun,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-chisq-dist-function-in-excel-office-365/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

## CHISQ.DIST Function syntax

```
=CHISQ.DIST(x , deg_freedom , cumulative)
```

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

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

- 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)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/probabiltiy-mass-distribution-1024x181.png)<figcaption>probability mass distribution</figcaption>

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

![](https://geekexcel.com/wp-content/uploads/2021/08/in-percentage-1-1024x182.png)<figcaption>Change to percentage</figcaption>

- 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)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/cumulative-distribution-3-1024x219.png)<figcaption>Cumulative distribution</figcaption>

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

**Keep Reading:**

- **[Insert Sheet in Microsoft Excel 2007?](https://geekexcel.com/insert-sheet-in-microsoft-excel-2007/)**
- **[How to Use “CONVERT function” in Microsoft Excel 365? [With Examples]](https://geekexcel.com/how-to-use-convert-function-in-microsoft-excel-365-with-examples/)**
- **[How to use the T.INV function in Excel office 365? – Easy Tricks!!](https://geekexcel.com/how-to-use-the-t-inv-function-in-excel-office-365-easy-tricks/)**