Home › Functions › Statistical › =CHISQ.DIST()
Statistical Excel 2010 ◉ 37 views

=CHISQ.DIST()

Returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel Web App
=CHISQ.DIST(x,deg_freedom,cumulative)
Hover argument names in the table for details.
Output typeStatistical
Popularity6 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =CHISQ.DIST() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download CHISQ.DIST.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
x Number Required The value at which you want to evaluate the distribution.
deg_freedom Number Required The number of degrees of freedom.
cumulative Logical Required A 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.

▣ Examples

The chi-squared distribution for 0.5, returned as the cumulative distribution function, using 1 degree of freedom. =CHISQ.DIST(0.5,1,TRUE)
Result: 0.52049988
The chi-squared distribution for 2, returned as the probability density function, using 3 degrees of freedom. =CHISQ.DIST(2,3,FALSE)
Result: 0.20755375

§ Remarks

  • If any argument is nonnumeric, CHISQ.DIST returns the #VALUE! error value.
  • If x is negative, CHISQ.DIST returns the #NUM! error value.
  • If deg_freedom is not an integer, it is truncated.
  • If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.DIST returns the #NUM! error value.

✦ Tips

  • If deg_freedom is not an integer, it is truncated.

⚠ Common Errors

#VALUE! If any argument is nonnumeric, CHISQ.DIST returns the #VALUE! error value.
Fix: هر سه آرگومان را به‌صورت عددی/منطقی وارد کنید.
#NUM! If x is negative, CHISQ.DIST returns the #NUM! error value. If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.DIST returns the #NUM! error value.
Fix: Correct the input value

⇄ Related Functions

=CHISQ.DIST.RT() Returns the right-tailed probability of the chi-squared distribution. The χ2 distribution is associated with a χ2 test. Use the χ2 test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid. =CHISQ.INV() Returns the inverse of the left-tailed probability of the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. =CHISQ.TEST() The CHISQ.TEXT function returns the test for independence. It returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.