Chi-Squared Test Process Validation

Question

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 correct? Basically I did it in excel, taking 50 random numbers between 0-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

Answer 1

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$.