calculating p value for a 2*2 table

[mattw]

Hi there all, I have been trying to find out how to calculate P values from a 2*2 table in excel. I have programmed excel to do the X2 stuff and it works fine, but when I try to get the P value it gives me an error message, As I guess it doesn’t calculate large factorials(and numbers) I was told to use hypogeodist function but I’m pretty confused, I don’t know how. Can anyone give me a few tips??? How do I use this?

Thanks!!!!!!!!!!



2*2 example



77.0 7.0

7.0 53.00

A C

B D