Is there an Excel function calculating the Chi Square probability from a Chi Statistics? If not, any formula for it that can be easily used in Excel?
Thanks in advance.
Is there an Excel function calculating the Chi Square probability from a Chi Statistics? If not, any formula for it that can be easily used in Excel?
Thanks in advance.
Does this native Excel function help?
CHIDIST()
Thanks Ron. I actually tried CHISQ.DIST with Excel 2013 and got results that were different from using CHITEST. CHITEST returns results that were consistent with those from the calculators on the Internet while CHISQ.DIST generated results that were the same as those from CHITEST when the DF was 1 or 2. Beyond that, the results from the two methods were quite different. After seeing your message, I tried CHIDIST, that is the old version of CHISQ.DIST as you know, it works fine. I may have to tried it again when I get home this evening with CHISQ.DIST that is on my home computer, or is there any difference between this two and they are not inter-replaceable? I noticed that CHISQ.DIST requires three parameters and may be used to calculate the cumulative distribution function and calculate the probability density function while CHIDIST requires only two.
Thanks again for your help.
I read more about this topic. It turns out that the equivalent of CHIDIST in Excel 2010 and later is CHISQ.DIST.RT.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks