1
$\begingroup$
Category  Observed  Expected  (O-E)  (O-E)^2  (O-E)^2 / E     0         6         5       1       1          0.5     1         6         5       1       1          0.5     2         3         5       2       4          2     3         3         5       2       4          2     4         4         5       1       1          0.5     5         5         5       0       0          0     6         3         5       2       4          2     7         8         5       3       9          4.5     8         5         5       0       0          0     9         7         5       2       4          2   50    14 <---- ChiSquare Value 

Can anyone confirm that I did this correctly? Basically I did it in Excel, taking $50$ random numbers between $0$ and $9$ using = RANDBETWEEN(0,9).

I am interested in knowing if I did the process correctly.

Referenced: http://math.hws.edu/javamath/ryan/ChiSquare.html

  • 1
    You *may* also/instead want to try http://stats.stackexchange.com/.2011-01-19

1 Answers 1

4

I agree with most of your spreadsheet; however, I think the last column needs some attention. I think it should be

0.2 0.2 0.8 0.8 0.2 0.0 0.8 1.8 0.0 0.8 

It looks like you might have divided by $2$ instead of dividing by the Expected column. Of course, this would change the sum, so $\chi^2 = 5.6$.