+ Reply to Thread
Results 1 to 4 of 4

Is there an Excel function calculating the Chi Square probability from a Chi Statistics?

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Is there an Excel function calculating the Chi Square probability from a Chi Statistics?

    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.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Is there an Excel function calculating the Chi Square probability from a Chi Statistic

    Does this native Excel function help?
    CHIDIST()
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    02-12-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Is there an Excel function calculating the Chi Square probability from a Chi Statistic

    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.

  4. #4
    Registered User
    Join Date
    02-12-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Is there an Excel function calculating the Chi Square probability from a Chi Statistic

    I read more about this topic. It turns out that the equivalent of CHIDIST in Excel 2010 and later is CHISQ.DIST.RT.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating probability
    By bknowles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2013, 05:18 PM
  2. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  3. calculating probability with unknown sample mean
    By mikeyyohan in forum Excel General
    Replies: 10
    Last Post: 01-26-2012, 03:06 PM
  4. Calculating Probability help needed
    By misterboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2011, 05:17 AM
  5. Tan inverse function and its's square in excel
    By venkatatcts in forum Excel General
    Replies: 3
    Last Post: 05-06-2009, 08:36 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1