How do I do this question?

A B C L Z AA AB AC AD AE Chi-Square Test Is depth of earthquake independent of the magnitude? Use . 01 level of significance and quake raw data in worksheet RawData to summarize into counts. NOTE: Observed Frequencies Your counts will come from the RawDa Depth (km ) when you create the pivot table there. Magnitude (Richter) 0-10 10-20 Total Notice that >1 takes into account 2 lines of the pivot. This is step 2 of the process. 0-1 Entering values correctly into table: (10 points) >1 Total 0 Access this helpful video: Video Expected Frequencies DO NOT touch the non-blue areas of the tables. Depth (km ) Magnitude (Richter) 0-10 10-20 Total 0-1 #DIV/O! #DIV/O! #DIV/O! >1 #DIV/O! #DIV/O! #DIV/O! Total #DIV/O! #DIV/O! #DIV/O! This is what the rows 33 through 43 should look like: Data Data Level of Significance 0.01 Entering correct alpha value (10 points) Level of Significance 0.01 Number of Rows Number of Rows 2 Number of Columns Number of Columns Degrees of Freedom 1 Degrees of Freedom 1