# CHISQ.DIST Function

Returns the chi-square distribution

## Chi Square Test Excel Function

The CHISQ.DIST Function is categorized under Statistical functions. It will return the chi-square distribution. The distribution is generally used for studying the variation in percentage across samples. This guide will break down the Chi Square Test Excel function in detail.

In financial analysis, the function can be useful in finding out the variations in an individual’s assumptions. For example, we are into manufacturing of jeans. We manufacture jeans of two colors only – black and blue. If we want to find out the proportion of blue jeans sold in proportion to the total number of jeans manufactured, we can use Chi Square in Excel to find out.

The CHISQ.DIST function was introduced in MS Excel 2010 and hence is unavailable in earlier versions.

### Chi Square Excel Formula

=CHISQ.DIST(x,deg_freedom,cumulative)

The CHISQ.DIST uses the following arguments:

1. X (required argument) – It is the value at which the chi-square distribution is to be evaluated. It should be greater than or equal to zero.
2. Deg_freedom (required argument) – It is the number of degrees of freedom. It must be an integer between 1 and 1010.
3. Cumulative (required argument) – It is a logical value that determines the form of the function. It can either be TRUE (use the cumulative distribution function) or FALSE (will use the probability density function).

### How to use the Chi Square Test Excel function

To understand the uses of the Chi Square in Excel function, let’s consider an example:

#### Example

Suppose we are given the following data:

The formula for calculating the CHISQ distribution using the cumulative distribution function is shown below:

We get the result below:

The formula for calculating the CHISQ distribution using the probability density function is shown below:

We get the result below:

### Notes about the Chi Square Test Excel function

1. If the deg_freedom argument is not an integer, it is truncated by MS Excel.
2. #VALUE! error – Occurs when any of the arguments provided are non-numeric.
3. #NUM! error – Occurs when:
1. The given value of x is negative.
2. The deg_freedom argument is less than 1 or greater than 1010.

Thanks for reading CFI’s guide to the Chi Square Test Excel function! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

• Excel Functions for Finance