- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
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
Advertisements