Hi,
I'm trying to run a Chi Squared test (for the first time and for the first time in Excel so there may be quite a few things that I have done wrong). I have followed the general formula through (I think, I found a lot of information on this site in terms of pointers: http://blog.excelmasterseries.com/20...d-easiest.html) and the histrogram distribution looks fairly normal, but when I follow everything through I have a fairly high Chi Squared Statistic in cell T30, resulting in a P Value of 0 (which is unhelpful to what I am trying to prove) in T32.
The distribution in the Histogram data (around F22) looks fairly reasonable so I am struggling to figure quite where I have gone wrong. Do I need more bins, small bins, to balance my observations per bin up (so they are more balanced etc.). Any advice would be greatly appreciated.
AFL_Chi_Squared.xls
Bookmarks