Chi-Square and 0

#1
Hello all,
I am a masters-level social work student, and I am trying to conduct a bit of statistical analysis on my own for a paper I am writing. The data come from a governmental publication on juvenile court statistics. I am interested in determining the significance of race across a number of court proceedings, and I am using excel for mac. The first contingency table I set up has to do with cases that petitioned (formally processed) vs not, and my race variable has 5 levels (see attachment). After setting up my observed and expected tables, I ran ChiSqTests on the table as a whole and each individual level of race. Despite a (seemingly) obvious and large difference in the data for White and Black youth, I keeping a significance of 0 for both those levels of race. The other levels of race (Hispanic, Native, and Asian) are returning significance levels that are surprising given the much smaller discrepancies between observed and expected. I am attaching a picture of my tables, and help on this would be much appreciated!



Screen Shot 2020-11-23 at 9.21.04 PM.png
 

Karabiner

TS Contributor
#4
Maybe this means 0.00000000000000000000000000000000000000000000000000000...?
Have you tried reformatting the cell of the zero result?

With kind regards

Karabiner
 
#5
I did indeed, and to no avail. However, I ran the same matrix on a graphing calculator, and it appears that the 0 means exactly that. 0.00000000000000000000000000000000000000 toward infinity