+ Reply to Thread
Results 1 to 4 of 4

Thread: Calculating chi-squared statistic in Excel

  1. #1
    Points: 692, Level: 13
    Level completed: 84%, Points required for next Level: 8

    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating chi-squared statistic in Excel




    Folks

    I've carried out a chi-squared test on the following observed and expected values using the CHISQ.TEST function in Excel:
    Observed: 176, 1, 3, 5, 15
    Expected: 77.92, 2.08, 2.08, 8.75, 109.17
    This gives me the p-value, but I'm told I also need to report the "chi-squared statistic". Does anyone know how to calculate this in Excel?

    Thanks

    Remster

  2. #2
    Omega Contributor
    Points: 38,303, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    6,993
    Thanks
    397
    Thanked 1,185 Times in 1,146 Posts

    Re: Calculating chi-squared statistic in Excel

    If you hover over the pvalue cell does it tell you where the test statistic cell is? If not you can look it up quickly if you have the degrees of freedom and exact pvalue or create a formula for it.
    Stop cowardice, ban guns!

  3. #3
    Points: 692, Level: 13
    Level completed: 84%, Points required for next Level: 8

    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating chi-squared statistic in Excel

    Thanks for your reply. Unfortunately I have only a tablet, and I can't simulate hovering. However, I've just come across this on the Web:
    Chi-squared test statistic = sum of ((O - E)^2)/E for each pair of observed and expected values.
    Does that sound right?

  4. #4
    Omega Contributor
    Points: 38,303, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    6,993
    Thanks
    397
    Thanked 1,185 Times in 1,146 Posts

    Re: Calculating chi-squared statistic in Excel


    Yeah off the top of my head that seems right. Then you can look up the stat and see if pvalue lines up.
    Stop cowardice, ban guns!

+ Reply to Thread

           




Posting Permissions

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






Advertise on Talk Stats