Mathematics desk
< February 24	<< Jan \| February \| Mar >>	February 26 >

Welcome to the Wikipedia Mathematics Reference Desk Archives
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

February 25

Pearson's chi square for null values in the "expected" range

I wanted to use MS Excel to calculate p-values using Pearson's (new and improved!) Chi square formula. The problem I've run into is that some of the values in my "expected" range are zero. Excel therefore gives the error #DIV/0. How can I proceed? Do I need to find an alternative statistical test or could I just put very low values (e.g 0.001). In case that was incoherent, I made an example to see if the red-blue berry ratio was significantly different in my garden compared to my friend's garden; the relevant cells are highlighted. — Preceding unsigned comment added by 129.215.47.59 (talk) 12:00, 25 February 2014 (UTC)[reply]

Actually, nevermind. There are a load of promising results after searching Google for "pearson chi square zero". 129.215.47.59 (talk) 12:04, 25 February 2014 (UTC)[reply]