Hi,

I've being trying to run CHISQ.TEST and CHISQ.INV.RT to assess some data I've collected. I've used the example from the Excel help page as a starting point, and got that working fine. However, when I lay out my own data in the same way I get erroneous results. I've tried working out the cumulative probaility function manually, and the way I've done it works perfectly for the Excel example (ie same result as the Excel function), but when used on my data gives a completely different result to the Excel function.

chi-square.xlsx

The attached file shows my attempt at the Excel example on tab one, and my own data on tab 2. If anyone can see what I've done wrong I'd be eternally grateful!