statistics - How do I calculate the CDF of the chi-square distribution in excel? -


does excell have function cdf of chi-square distribution?

if not how calculate manually?

i cant seem find i'm looking when try searching online. formula: enter image description here

i don't understand how plug values formula calculate result.

if have excel 2010 or later, there function this.

=chisq.dist(x, degrees_freedom, cumulative)

this function accepts 3 parameters:

  • x, value @ chi-square distribution calculated
  • degrees_freedom, number of degrees of freedom
  • cumulative, true or false conditional, false gives pdf , true gives cdf, you'd want true

you can read more microsoft.

if you're using excel 2007 or earlier, require more creativity excel's built in chi-square distribution functions right-tailed probabilities.


Popular posts from this blog

c# - ODP.NET Oracle.ManagedDataAccess causes ORA-12537 network session end of file -

matlab - Compression and Decompression of ECG Signal using HUFFMAN ALGORITHM -

utf 8 - split utf-8 string into bytes in python -