# Thread: Calculating chi-squared statistic in Excel

1. ## 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. ## 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.

3. ## 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. ## 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.

 Tweet

#### Posting Permissions

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