# DAX Statistical - CHISQ.DIST function

## Description

Returns the chi-squared distribution.

DAX CHISQ.DIST function is new in Excel 2016.

## Syntax

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

## Parameters

Sr.No. Term & Definition
1

x

The value at which you want to evaluate the distribution.

2

deg_freedom

The number of degrees of freedom.

3

cumulative

A logical value that determines the form of the function.

TRUE: CHISQ.DIST returns the cumulative distribution function.

FALSE: CHISQ.DIST returns the probability density function.

## Return Value

The chi-squared distribution.

## Remarks

• If deg_freedom is not an integer, it is rounded to the nearest integer.

• If any of the parameters – x, deg_freedom is nonnumeric, CHISQ.DIST returns an error value.

• If any of the parameters – x, deg_freedom is negative, CHISQ.DIST returns an error value.

## Example

```= CHISQ.DIST(0.5,1, TRUE ()) returns 0.520499877813047.
```
dax_functions_statistical.htm

Get certified by completing the course