Chi Squared ?

Occurences Group A Group B
0 231 260
1 203 263
2 77 109
3 14 30
4 3 3
5 0 1

528 666


The above is a snippet of data from something I've been working on for many years, comparing thoroughbred horse pedigrees with horse ratings/results.
I wrote programs to compare things (occurences) in the family tree of each horse with its rating.

This week I finally completed database programs that analysed 159,660 horse pedigrees, and threw out the results.
The results data is 4116 rows by 40 columns = 164,640 cells.
That data is a combined file for colts, gelding, and fillies.
I will later split the initial data into three files of colts, geldings, fillies.

The rows are groups from 1 to 147. Each of those groups has 28 rows (values 0 to 27).
Most of the data is clustered as in the above example, in the first few rows of each group, from 0 to 6 or 7.
(group 1 has 0 to 27, group 2 has 0 to 27, and so on down to 147 with 0 to 27). The 4,116 is 147 X 28 = 4,116).

I have a book that mentions the Chi squared test for data like this.
It mentions comparing values with expected values. I'm at a loss to know what should be my expected values.

I've tried CHITEST in Excel but it doesn't like zero values.

In the above example Group B are the better horses.
Are the higher numbers at occurences 2, 3, 5 significant?
Ideally I would like to analyse all the output, the 164,640 cells.

Any help welcomed.