Creating a table to perform a chi-squared analysis. Only need assistance with creating the table sample from the given data.

Excel Edit View Insert Format Tools Data Window Help O 2 Q 8 0 Fri Jul 14 2:22 PM AutoSave OFF W A F ? C ... SchoolsData Home Insert Draw Page Layout Formulas Data Review View Automate Acrobat PivotTable Analyze Design Tell me Comments LE Share fx A V v e Define Name v Ey Trace Precedents Calculate Now Use in Formula "Trace Dependents se Show Error Watch Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Calculation Calculate Sheet Function Used Time Reference Trig Functions Manager i Create from Selection My Remove Arrows v Formulas Checking Window Options ept... L23 X V fx D K M N O P Q R S T U V W X Y Z AA AB AC AD AE Schools Number of Average Average Welfare Avg Salary spend per Average assing Students Family Property Value Percent Student Attendance Percent Income Percent Example Descriptive Statistics Bluffton 1 132 $ 24,487 $ 62,678.00 1.80 $ 31,221 $ 2,130 95.7 85 Shawnee 2472 $ 29,777 $ 130,910.00 2.60 $ 34,860 2,57 4.7 73 Teachers Salary U A W N 1026 $ 23, 161 $ 51,645.00 5.40 $ 30, 155 2,262 35.5 68 Spencervil Delphos 104 $ 21,792 $ 88,453.00 6.20 $ 32,273 $ 2,506 6.5 65 Mean Teachers Sall $ 33,181.40 Elida 3204 $ 24,446 $ 65,550.00 8.90 $ 32,876 $ 2,250 14.1 62 Median Teachers Sa $ 2,708.00 Lima 5963 $ 18,394 $ 44, 138.00 33.80 $ 33, 142 2,657 2.3 40 Standard Deviation $ 3,548.50 Northeaste 1194 $ 26,428 $ 88,789.00 1.70 $ 30,919 $ 2,431 96.1 72 Coefficient of Ske 0.67 Ayersvill 921 $ 28,228 $ 82,707.00 3.90 32,850 2,693 35.6 68 10 Defiance 046 $ 23,812 $ 56,333.00 11.20 34,750 A CA CA CA CA CA CA CA CA 2.438 34.2 63 Number of Students Hicksville 990 $ 22,448 $ 56,411.00 7.00 34,224 2,351 95.7 59 Central 1216 $ 24, 189 $ 53,923.00 4.60 34,430 2,496 4.8 56 Mean Number of Stu 2,134 Berlin-Milar 593 $ 25,223 $ 76,878.00 4.00 $ 32, 166 2,564 36.1 77 Median Number of Stu 1,227 AWA Perkins 2038 $ 25,586 $ 117,545.00 3.30 39,352 2.861 35.8 74 Standard Deviati 3,880 15 Huron 1494 $ 27,135 $ 105,588.00 4.60 $ 33,433 2,968 5.4 74 Coefficient of Ske 7.80 Margaretta 1560 $ 23,849 $ 74,601.00 o $ 37,084 2,464 95.5 66 17 Sandusky 4426 $ 19,529 $ 72,425.00 25.20 $ 36,042 2,766 93 37 Kelleys Isla 20 $ 19,854 $ 802,081.00 11.40 27, 144 11,226 95 100 Pettisville 503 $ 25,079 3,948.0 3 90 31,159 2.834 96.1 78 20 Wauseon 1864 $ 23,408 $ 60,896.00 4.90 32,499 2,252 5.3 75 Evergreen 1238 $ 23,826 $ 69,432.00 5.20 $ 32,353 $ 2,250 95 72 22 Archbold-A 1401 $ 26,706 $ 107,547.0 4.10 35,982 2,837 6.2 69 Chart 1 3 Pike-Delta- 559 $ 23,396 $ 48,638.00 6.10 31,310 $ 2 ,309 34.8 66 Gorham-Fa 487 $ 22,405 $ 57,221.00 6.90 33, 166 2,492 94.6 51 Turn on the PivotChart Field List to work with the PivotChart. Swanton 1725 $ 24,596 $ 69,320.00 6.30 $ 33,690 2,615 4.9 50 PivotTable 1 Arlington 685 $ 26,175 $ 55,478.00 2.70 $ 31,821 2,205 96.5 84 Tum on the PivotTable Field List to work with the Vanlue 346 $ 24,709 $ 49,606.00 4.10 $ 28,411 2,420 96.2 83 PivotTable 28 Liberty-Ber 954 $ 28,718 $ 77,503.00 1.50 $ 30,330 2,063 96.7 78 29 Van Buren 840 $ 28,964 $ 151,992.00 1.80 33,447 2,584 96.4 75 30 Cory-Raws 194 $ 23,904 $ 69,242.0 2.40 31,241 2,416 6.4 73 31 Arcadia 597 $ 24,305 $ 78, 102.00 2.50 30,738 2,752 95.9 64 32 Mccomb 805 $ 23,754 $ 69,347.0 5.70 28,986 2,321 95.9 61 Findlay 5758 $ 24,269 $ 92,648.0 7.60 35,879 2,860 94.9 60 and 34 Ada 855 $ 23,029 $ 52,655.00 5.30 $ 28,479 $ 2,38 5.9 69 5 Kenton 2228 $ 20,418 $ 61, 155.00 13.80 $ 30,907 2,512 93.7 54 ptx 6 Liberty Cer 1009 $ 24,723 $ 57,685.00 4.10 $ 30,904 2.431 95.8 82 Patrick He 1176 $ 23,061 $ 63, 134.00 5.20 $ 31,895 2,552 95.9 75 38 Napoleon 2331 $ 25,304 $ 84,245.00 6.60 32,773 2,422 94.6 73 39 Holgate 605 $ 23,962 $ 49,709.00 6.00 $ 31,324 2.454 34.9 71 40 Monroeville 686 $ 22,942 $ 63,103.00 4.30 $ 30,838 2,474 95.8 64 Bellevue 276 $ 24,025 66,912.00 6.90 32, 164 2 ,374 95 .1 55 15 Willard 23 204 58 832 0n 11 20 25 047 2 247 04 6 SchoolData Variables 7 AM 100% Ready x Accessibility: Investigate JUL 2 14 tvExcel Edit View Insert Format Tools Data Window Help O 2 Q 8 0 Fri Jul 14 2:22 PM AutoSave OFF W A F ? C ... SchoolsData Home Insert Draw Page Layout Formulas Data Review View Automate Acrobat PivotTable Analyze Design Tell me Comments LE Share fx A V v e Define Name v Ey Trace Precedents Calculate Now Use in Formula "Trace Dependents se Show Error Watch Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Calculation Calculate Sheet Function Used Time Reference Trig Functions Manager i Create from Selection My Remove Arrows v Formulas Checking Window Options ept... L23 X V fx D K M N O P Q R S T U V W X Y Z AA AB AC AD AE Schools Number of Average Average Welfare Avg Salary spend per Average assing Students Family Property Value Percent Student Attendance Percent Income Percent Example Descriptive Statistics Bluffton 1 132 $ 24,487 $ 62,678.00 1.80 $ 31,221 $ 2,130 95.7 85 Shawnee 2472 $ 29,777 $ 130,910.00 2.60 $ 34,860 2,57 4.7 73 Teachers Salary U A W N 1026 $ 23, 161 $ 51,645.00 5.40 $ 30, 155 2,262 35.5 68 Spencervil Delphos 104 $ 21,792 $ 88,453.00 6.20 $ 32,273 $ 2,506 6.5 65 Mean Teachers Sall $ 33,181.40 Elida 3204 $ 24,446 $ 65,550.00 8.90 $ 32,876 $ 2,250 14.1 62 Median Teachers Sa $ 2,708.00 Lima 5963 $ 18,394 $ 44, 138.00 33.80 $ 33, 142 2,657 2.3 40 Standard Deviation $ 3,548.50 Northeaste 1194 $ 26,428 $ 88,789.00 1.70 $ 30,919 $ 2,431 96.1 72 Coefficient of Ske 0.67 Ayersvill 921 $ 28,228 $ 82,707.00 3.90 32,850 2,693 35.6 68 10 Defiance 046 $ 23,812 $ 56,333.00 11.20 34,750 A CA CA CA CA CA CA CA CA 2.438 34.2 63 Number of Students Hicksville 990 $ 22,448 $ 56,411.00 7.00 34,224 2,351 95.7 59 Central 1216 $ 24, 189 $ 53,923.00 4.60 34,430 2,496 4.8 56 Mean Number of Stu 2,134 Berlin-Milar 593 $ 25,223 $ 76,878.00 4.00 $ 32, 166 2,564 36.1 77 Median Number of Stu 1,227 AWA Perkins 2038 $ 25,586 $ 117,545.00 3.30 39,352 2.861 35.8 74 Standard Deviati 3,880 15 Huron 1494 $ 27,135 $ 105,588.00 4.60 $ 33,433 2,968 5.4 74 Coefficient of Ske 7.80 Margaretta 1560 $ 23,849 $ 74,601.00 o $ 37,084 2,464 95.5 66 17 Sandusky 4426 $ 19,529 $ 72,425.00 25.20 $ 36,042 2,766 93 37 Kelleys Isla 20 $ 19,854 $ 802,081.00 11.40 27, 144 11,226 95 100 Pettisville 503 $ 25,079 3,948.0 3 90 31,159 2.834 96.1 78 20 Wauseon 1864 $ 23,408 $ 60,896.00 4.90 32,499 2,252 5.3 75 Evergreen 1238 $ 23,826 $ 69,432.00 5.20 $ 32,353 $ 2,250 95 72 22 Archbold-A 1401 $ 26,706 $ 107,547.0 4.10 35,982 2,837 6.2 69 Chart 1 3 Pike-Delta- 559 $ 23,396 $ 48,638.00 6.10 31,310 $ 2 ,309 34.8 66 Gorham-Fa 487 $ 22,405 $ 57,221.00 6.90 33, 166 2,492 94.6 51 Turn on the PivotChart Field List to work with the PivotChart. Swanton 1725 $ 24,596 $ 69,320.00 6.30 $ 33,690 2,615 4.9 50 PivotTable 1 Arlington 685 $ 26,175 $ 55,478.00 2.70 $ 31,821 2,205 96.5 84 Tum on the PivotTable Field List to work with the Vanlue 346 $ 24,709 $ 49,606.00 4.10 $ 28,411 2,420 96.2 83 PivotTable 28 Liberty-Ber 954 $ 28,718 $ 77,503.00 1.50 $ 30,330 2,063 96.7 78 29 Van Buren 840 $ 28,964 $ 151,992.00 1.80 33,447 2,584 96.4 75 30 Cory-Raws 194 $ 23,904 $ 69,242.0 2.40 31,241 2,416 6.4 73 31 Arcadia 597 $ 24,305 $ 78, 102.00 2.50 30,738 2,752 95.9 64 32 Mccomb 805 $ 23,754 $ 69,347.0 5.70 28,986 2,321 95.9 61 Findlay 5758 $ 24,269 $ 92,648.0 7.60 35,879 2,860 94.9 60 and 34 Ada 855 $ 23,029 $ 52,655.00 5.30 $ 28,479 $ 2,38 5.9 69 5 Kenton 2228 $ 20,418 $ 61, 155.00 13.80 $ 30,907 2,512 93.7 54 ptx 6 Liberty Cer 1009 $ 24,723 $ 57,685.00 4.10 $ 30,904 2.431 95.8 82 Patrick He 1176 $ 23,061 $ 63, 134.00 5.20 $ 31,895 2,552 95.9 75 38 Napoleon 2331 $ 25,304 $ 84,245.00 6.60 32,773 2,422 94.6 73 39 Holgate 605 $ 23,962 $ 49,709.00 6.00 $ 31,324 2.454 34.9 71 40 Monroeville 686 $ 22,942 $ 63,103.00 4.30 $ 30,838 2,474 95.8 64 Bellevue 276 $ 24,025 66,912.00 6.90 32, 164 2 ,374 95 .1 55 15 Willard 23 204 58 832 0n 11 20 25 047 2 247 04 6 SchoolData Variables 7 AM 100% Ready x Accessibility: Investigate JUL 2 14 tv