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:
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 calculateddegrees_freedom
, number of degrees of freedomcumulative
,true
orfalse
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.