anyone understand chi squared test

[Mr.Cookie]

Hi trying to help my wife with her stats data, but she's confusing me, I'm confusing her and excel is confusing both of us

observed values are 587, 1962
expected values are 1274.5, 1274.5



my math is (o-e)2 over e
so (587-1274.5)2 equals 472656.25 over 1274.5
(1962-1274.5)2 equals 472656.25 over 1274.5

472656.25+472656.25 equals 945312.5 over 1274.5
which returns a p value of 741.71243625

HEEEEEEEEEEEEELP!!!

 

[Mr.Cookie]

cheers guys you rock, it's basically to see if there are behavioural differences in a herd when at pasture vs indoors, i think that was the grooming behaviour.
Sue is out at the moment so will post more when she gets back

Cheers

 

[Mr.Cookie]

Sample size was a herd of 23 cattle which were scan sampled at 1 minute intervals for a total of 80 hours indoors and 80 outdoors.
23 different behaviours were sampled split into 7 categories (grooming, antagonistic, sedentary, locomotory, feeding, stereotypic and general), each category is being put through chi squared test to see if we reject or do not reject the hypothesis that there is a difference in behaviour at pasture and indoors.
Problem was that excels chitest came up with different numbers to me and can't understand why.

sum in excel =chisq.test(g3:h3,g4:h4)