Load the dataset representing census block level voting data from Virginia into Excel. From the given data estimate the

[answerhappygod]

Load the dataset representing census block level voting
data from Virginia into Excel. From the given data estimate the
percentage of voters that supported the Democratic candidate for
Governor. Justify any choice you make in cleaning/processing the
data and explain your final computation.

Load The Dataset Representing Census Block Level Voting Data From Virginia Into Excel From The Given Data Estimate The 1 (234.8 KiB) Viewed 88 times

Load The Dataset Representing Census Block Level Voting Data From Virginia Into Excel From The Given Data Estimate The 2 (247.67 KiB) Viewed 88 times

Load The Dataset Representing Census Block Level Voting Data From Virginia Into Excel From The Given Data Estimate The 3 (70.46 KiB) Viewed 88 times

BLOCKID Population Voters 5200653 89 5200368 159 5200971 4 5200269 112 5200516 72 5200600 272 5200271 35 5200753 490 5200773 57 5200745 7 VA_VOTES GOV R GOV 4 4 67 45 0 0 77 15 62 3 1 1 37 6 352 319 79 55 36 4 D Percent R_Percent 0 100.00% 0.00% 22 67.16% 32.84% 0 62 19.48% 80.52% 59 4.84% 95.16% 0 100.00% 0.00% 30 17.14% 82.86% 33 90.63% 9.38% 24 69.62% 30.38% 3 57.14% 42.86% 5200408 110 75 37 38 49.33% 50.67% 0 5200658 5200317 5200773 5200382 5200744 5200792 153 250 87 63 26 219 79 24 169 55 5 26 50 24 29 0.00% 77.17% 69.62% 20.83% 100.00% 22.83% 30.38% 79.17% 80 4 1 3 25.00% 75.00% 11 9 16 62 2 44 0 8 8 4 5200235 5200534 5200912 5200517 5200754 5200996 5200487 5200383 210 100 42 28 185 160 112 36 2 33 10 81.82% 25.81% 100.00% 50.00% 67.35% 47.62% 11.11% 5.88% 2 16 11 16 16 18.18% 74.19% 0.00% 50.00% 32.65% 52.38% 88.89% 94.12% 49 21 18 17 1 5200805 11 9 9 28 28 96 8 124 72 315 5200655 5200862 5200788 5200545 5200546 5200076 18 56 5 م م ه ه م ه ی 13 1 11 31 81.82% 50.00% 76.79% 80.00% 52.17% 16.22% 62.50% 18.18% 50.00% 23.21% 20.00% 47.83% 83.78% 37.50% 23 37 8 5200396 29 5200250 5200549 38 162 186 101 153 10 21 29 19 80 124 34.48% 20.79% 18.95% 65.52% 79.21% 81.05% 5200849 5200762 10 213 5 1 1 0 100.00% 0.00%

80 42 4 5200131 5200113 5200061 5200829 18 112 279 52 11 89 237 80.77% 36.36% 47.19% 71.73% 19.23% 63.64% 52.81% 28.27% 42 - 170 47 -67 420 351 113 10 150 27 4 84 0 -83 238 4 1 4 5200886 5200385 5200790 5200779 5200994 5200804 5200028 5200382 6 20 38 48 15 32. 19% 0.00% 98.81% 66.67% 75.00% 21.05% 81.25% 26.67% 33 162 84 67.81% 100.00% 1.19% 33.33% 25.00% 78.95% 18.75% 73.33% 2 5 30 9 15 8 38 30 4 11 194 84 9 65 4 25 9 78 5 40 32 2 70 21 5 164 188 9 80 9 6 5200840 5200365 5200124 5200934 5200571 5200838 5200282 5200410 5200909 5200688 5200553 5200204 5200292 5200413 5200529 5200365 134 280 244 58 118 41 7 70 30 10 11 222 154 57 11 25 36 190 65 1 5 167 121 39 55.56% 61.54% 78.05% 28.57% 100.00% 70.00% 10.00% 45.45% 75.23% 78.57% 68.42% 9.09% 8.00% 63.89% 78.95% 61.54% 55 44.44% 38.46% 21.95% 71.43% 0.00% 30.00% 90.00% 54.55% 24.77% 21.43% 31.58% 90.91% 92.00% 36.11% 21.05% 38.46% 33 18 1 10 69 44 212 84 2 23 135 23 13 45 25 40 256 82 129 5200111 5200627 211 16 38.86% 56.25% 61.14% 43.75% 18 9 7 31 101 38 98 18 29 44 5200129 5200834 5200596 5200905 5200678 5200110 5200384 5200181 5200754 325 330 42 132 52 255 190 85 27 83 9 54 2. 102 3 4 12.90% 17.82% 76.32% 44.90% 50.00% 10.53% 70.00% 53.85% 43.75% 87.10% 82.18% 23.68% 55.10% 50.00% 89.47% 30.00% 46.15% 56.25% 114 10 13 32 6 18 5200044 180 51 14 37 27.45% 72.55%

5200990 5200255 5200033 5200680 105 201 200 195 14 16 47 153 4 12 20 135 10 4 27 18 28.57% 75.00% 42.55% 88.24% 71.43% 25.00% 57.45% 11.76% 40 4 8 122 27 5200455 5200700 5200939 5200779 5200929 5200913 5200923 220 54 364 284 66 16 128 52 131 240 53 4 4 6 25 63 66 13 1 68 180 40 3 33.33% 4.69% 48.08% 48.09% 25.00% 24.53% 25.00% 66.67% 95.31% 51.92% 51.91% 75.00% 75.47% 75.00%