How do I answer these problems?

Auto Save (O Off) W/S5Practice-2.xIsx_NitaxIsx * Search (Alt+0) Vernitta Wilson 19 X File Home Insert Drawy Page Layout Formulas Data Review View Help Share Comments X Calibri v 11 AA ab Wrap Text General Insert Ex AY O Delete * Paste BIU~ E Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles v Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity 216 X V fc =SUM(C6: C15) A X Y Z AA AB AC AD AE AF AG AH Al Magnitude (Richter) J-10 10-20 Total Notice that >1 takes into account 2 lines of the pivot. This is step 2 of the process. 0-1 13 7 20 Entering values correctly into table: (10 points) >1 17 13 30 16 Tota 20 50 Access this helpful video: Video 17 18 Expected Frequencies DO NOT touch the non-blue areas of the tables. 19 Depth (km) 20 Magnitude (Richter) 0-10 10-20 Total 21 0-1 12.0000 8.0000 20 22 >1 18.0000 12.0000 30 31 Total 201 50 This is what the rows 33 through 43 should look like: 32 33 Data Data 34 Level of Significance 0.01 Entering correct alpha value (10 points) Level of Significance 0.01 35 Number of Rows Number of Rows 36 Number of Columns 2 Number of Column 37 Degrees of Freedom Degrees of Freedom 38 39 Result: Results 40 Critical Value 6.6349 Critical Value 6.6349 41 Chi-Square Test Statistic 1.3472 Chi-Square Test Statistic 0.1202 42 p-Value 0.5557 p-Value 0.7288 43 Do not reject the null hypothesis Do not reject the null hypothesis 44 45 46 47 RawData Quake Data + D Ready -H + 87% B M a X 20 31'F Cloudy ENG 7:37 PM 12/18/2021Auto Save (O Off ) W/S5AppliedStatistics.xIs - Compatibility Mode - Excel Search (Alt+ 0) Vernitta Wilson 9 X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AA ab Wrap Text General Insert LO Arial v 10 Ex AY O Delete ~ Paste BIU ~ VA E = Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity -20 Formatting * Table ~ Styles v Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity E16 X V A B C D E F G H J K L M N MAG (Richter scale) DEPTH (km) 0.70 6.6 0.74 2.0 Count of DEPTH (km) DEPTH (km) DAWN 0.64 15.3 MAG (Richter scale) * 0-10 10-20 Grand Total 0.39 17.2 0-1 13 20 0.70 3.2 1-2 15 11 26 2.20 2.2 2-3 2 2 4 10 00 -40 1.98 14.8 Grand Total 30 20 0.64 5.6 10 1.22 6.1 11 0.20 9.1 12 1.64 18.5 13 1.32 81 14 2.95 10.0 15 0.90 13.7 16 1.76 8.0 17 1.01 70 18 1.26 18.6 19 0.00 8.2 20 0.65 5.7 21 1.46 18.9 22 1.62 13.7 23 1.83 4.5 24 0.99 8.3 25 1.56 6.0 26 0.40 14.2 27 1.28 5.4 RawData Quake Data + Ready + 100% 20 30'F Cloudy ENG 10:57 PM S 12/18/2021