Download the “Voting Behavior” data and the brief data description from the book’s Web site. This is a data set manually compiled from counties all around the United States. The data is partially processed, that is, some derived variables are created. Your task is to thoroughly preprocess the data by identifying the error and anomalies and proposing remedies and solutions. At the end you should have an analytics-ready version of this data. Once the preprocessing is completed, pull this data into Tableau (or into some other data visualization software tool) to extract useful visual information from it. To do so, conceptualize relevant questions and hypotheses (come up with at least three of them) and create proper visualizations that address those questions of “tests” of those hypotheses.
Gambling Data Set For RoughSet State NoCounty NoFORAGAINSTTOTAL CASTEDEPENDENT VARIABLEBALLOT TYPEPOPULATIONPCIMEDIUM FAMILY INCOMESIZE OF COUNTYPOPULATION DENSITYPERCENT WHITEPERCENT BLACKPERCENT OTHERPERCENT MALEPERCENT FEMALENO OF CHURCHESNO OF CHURCH MEMBERSPERCENT CHURCH MEMBERS OF POPULATIONPOVERTY LEVELUNEMPLOYMENT RATEAGE LESS THAN 18AGE24AGE44AGE64AGE OLDER THAN 65MSAPERCENT MINORITYNO OF OLDERNO OF YOUNGER 1142385229926537711265038$15,607$34,6181192.00223.29.75.03.22.496.50412825110.0910.405.0080600226279472446933201541.2567087189448 122015185238671113617$13,740$23,114722.8018.81.59.00.40.491.509222427.1824.807.00428518614092211412652.4033798184 13519594840610036511391511$24,187$44,874803.20490.34.85.06.09.488.51218058252.155.903.001112432957415074070783291711.1599954301480 149578561813115345$12,816$27,3591349.403.99.74.00.26.510.490141151.2116.905.001647229167011786212.2617993340 1594211292071014556$19,017$23,0542555.901.77.93.00.07.495.50523982.2219.001.00119222012319739402.0719132462 169056461551115048$13,742$22,3251514.003.32.71.01.28.520.48014797.1620.403.001401221134611279532.2920802692 1740479395157999411225339$21,782$43,782742.50304.50.90.01.10.501.49915233182.1511.004.0055588290728636637104172091.1154313172732 182678182645041112684$13,116$25,4391013.5012.52.88.02.11.536.464292446.1914.306.0030329263935270320882.1347917870 19490422912112397$19,356$30,0531781.501.34.96.00.04.509.49111495.2111.601.007751217423833762.047591484 110192311403063117619$17,826$41,111395.5019.29.96.00.04.519.48110324.049.503.002058340311915585442.0421026238 111106313432406017453$9,534$17,1551287.305.80.39.00.61.497.50319154.0233.9011.0026944341918136410432.6124073836 1126244041028113190$11,705$15,1271227.002.59.22.00.78.500.50029.0034.6010.009452148276855192.7812041654 1137584681226113946$11,946$18,345789.004.98.68.06.25.624.3768454.1223.803.0085932514956925752.3112672990 114565403968111926$14,913$23,919738.902.63.96.00.05.501.4996306.1618.404.00538495405152842.057991080 1153645391875630120980$12,769$22,1971142.2018.43.90.00.10.493.507524045.1917.806.0053939995304459346912.10928410608 116729845733513031911467610$23,200$32,038153.303046.53.61.12.26.487.51332383631.1817.105.001082094055017330980737648051.38145542346618 117322320642111504$14,205$24,6711067.001.41.94.00.06.508.4927378.2514.504.00431794233512202.06571846 118115198261197801160391$24,740$54,244840.2073.32.95.01.04.502.498425784.093.203.00194112706253381041225241.051293650676 1193006206450701121928$21,966$41,1831688.0013.16.86.00.14.527.473251179.057.503.00582519651076826687022.14337021536 120217912053384119646$17,331$33,9321850.905.27.81.07.12.501.49911880.0910.404.003083399362718007372.1925377254 12158502388929739411397014$17,028$38,1932126.70186.81.96.01.03.502.49825968222.176.907.001152244245714183465825316741.0497499283668 12268053683104881132273$12,297$24,3501533.0021.03.88.03.10.519.481466488.2016.106.00767620579946653260622.131259419892 1234646374483901129974$16,653$32,3772947.5010.29.93.00.07.509.491433473.119.304.008678213211138504629802.07802622276 1249994611460113070$15,505$36,218149.9020.50.95.01.05.529.4713185.0610.602.0077110913616092202.068292722 125235014403790117966$16,831$34,0721849.804.33.96.00.04.531.46920620.089.303.002112573323714336112.0420446474 1261732149832301110273$13,424$29,5333239.203.18.95.01.05.530.47012800.0816.207.0024382106357714956572.0621527154 12723617741311467$17,859$30,1251117.80.42.99.00.01.527.473491.1913.902.008721176124592.01183352 12813206181938116009$11,262$18,9551590.903.76.58.00.41.487.51316735.1225.707.0016232901506132812622.4125903012 129431269700111605$13,888$23,2391613.30.99.91.00.09.533.467371.0410.002.004291085193771722.095491038 130861736427015044311438430$20,986$44,679772.20569.43.90.01.09.493.50721343287.105.803.001218293122916416685812353941.10121206328332 131472413885111688$23,888$26,7791771.10.95.96.00.04.488.5126444.2613.802.00501614743203322.04652948 132155214643016117140$19,894$27,6482161.003.29.93.00.07.495.505272756.3915.201.0021693422040143411552.0725894080 13310636311694116007$14,419$30,788376.9015.98.84.00.16.516.48411444.0715.706.001788100118739563302.1612863746 1345386421095961132284$15,922$28,9501692.1019.18.75.00.25.504.496464225.1312.305.008859402710683549532202.25871521366 13530302303006060211186136$17,274$36,9312601.4071.90.91.01.09.495.50513628260.1512.004.0050174234266491929760178571.1047617129838 1362405134837531113765$11,986$20,8444773.002.88.55.00.45.487.513351177.0926.208.0037259833537279227282.4555207074 13710237761799114529$16,445$24,1732586.301.75.97.00.03.490.510231322.2917.902.00124920812449468822.0318282488 1384102253366351117567$17,449$26,4361838.609.52.92.00.08.488.512364689.2714.903.00498412475075351727442.08626110150 1391541615418308340193145$15,280$27,6373327.9028.17.90.00.09.485.51510214847.1615.105.002636368342851217985134511.093143657024 14026416042411558$16,199$22,232875.80.63.95.00.05.514.4864134.2413.106.0012916191138842.05222382 1411886132032061111357$15,712$35,5774742.502.40.93.00.07.506.494192046.1811.105.003835627394520319192.0729507890 1422363253448970118672$13,673$25,8252036.909.19.80.00.20.487.513383092.1720.207.00609310775521366723142.20598111042 1434110397880881124423$14,268$26,8042240.7010.92.88.00.12.488.512414890.2014.206.00700212216908529539972.12929213816 1443832277966111121939$16,381$27,4631285.5017.06.81.00.19.490.510416934.3216.004.00676614486400400233232.19732512800 1453060204651061120185$13,600$22,2391262.9015.93.63.01.37.482.518524988.2523.907.00615212595390393534492.38738410780 1465296031132012295$17,066$30,669542.104.25.95.00.05.505.4956293.139.609.00590797256022992.059011450 14717288772605117174$16,961$35,4912200.803.28.96.01.04.512.4887462.069.403.002030225286215315262.0520575724 1489769541930114189$19,021$26,051687.706.09.96.00.04.472.528161884.4514.101.00114118710998838792.0417622198 1491820201738370112661$31,633$52,976970.2013.11.94.00.05.525.4758370.036.305.0022081051643424115572.05296812868 1502280173140111113347$15,333$23,9311640.508.12.76.00.24.488.512384086.3121.005.0043759303914243016982.2441287828 15126991145144150511123051$14,180$25,7842388.8051.51.61.02.37.484.51612116603.1320.207.003427095503624324311186771.394298872486 15210768901966115972$15,118$34,1223221.201.87.95.00.05.508.49217895.1513.604.001889449192211435692.0517123844 1531807172435311110770$15,326$21,370912.6011.77.59.00.41.494.506282200.2023.809.0034176543040209515642.4136596080 1542560224048001114088$21,073$37,0502361.806.02.97.00.03.535.465191268.099.804.0037271242626920428082.03285012538 1558397261565114619$11,887$23,5693168.701.46.51.00.49.513.48711637.1430.6011.00152430714147995752.4913742828 15620114534611745$16,235$28,906387.501.93.83.00.17.557.443442.0612.907.0023341293130482.17178586 1578216501471113653$18,452$32,7081286.502.89.96.00.03.530.4706300.0811.405.0085628317935631582.037213586 1586905111201112690$17,723$23,569548.304.88.90.00.10.487.513111009.3811.501.00691967015826202.1012021402 1592430173941691112881$21,645$41,450608.2021.48.96.00.04.544.45611900.077.803.0027591509667816353002.04193513356 1603301138446851112468$16,802$35,370557.1022.51.96.00.04.508.492131227.1010.104.003737493489124459022.0433479782 16112498512100114812$19,756$24,3512521.201.89.97.00.03.500.500171380.2915.702.001347234132110618492.0319102642 16221442151413658311131821$15,353$30,8003992.8033.06.77.00.22.494.50613921105.1615.405.0039338150674182922133134541.223558783658 163195218323784118954$22,370$26,4652366.103.77.96.00.04.489.511272665.3013.302.0026974342511180715052.0433125022 21106234884155071157539$15,494$22,711655.3087.81.79.20.01.476.525587947.1424.807.80177505248158141179869291.211872731628 223442159550371123997$13,530$23,365764.6031.39.69.25.06.564.448467020.3326.208.50608221128006504727502.31779716012 23119315929178601167648$20,778$37,334291.60231.99.73.25.02.491.511409478.1614.506.70211326857214831292252541.271817642966 242510118236921122683$15,726$26,381338.7066.97.64.35.02.485.517173565.1622.007.40696323196451444625042.36695012902 254069197160401140512$14,369$20,252832.5048.66.68.30.02.493.511576600.1730.109.4011315380211250837957662.321414522500 263949136453131131628$16,270$29,6181160.2027.26.81.16.02.504.4995813080.4316.308.00889930059395673035992.191032918790 27206982128901115905$15,458$21,503810.7019.62.53.46.01.477.525429165.5724.9011.20433514203904346427822.4762467808 2897665021147871191958$19,512$33,216838.50109.67.74.22.04.483.5208233600.3913.906.60257089096284391924394721.262871556878 2933673188025247511244572$21,607$28,713882.10277.26.56.42.02.466.536212112985.4622.607.0067367226647016050826335551.4484381140320 2103772294424716411178175$19,906$31,6181071.20166.33.74.25.02.485.51715052611.3116.506.2050015173445267337867202761.2658143105346 211175775225091110188$15,614$22,808529.5019.24.78.20.02.488.513274719.4821.3010.6028648822705229114462.2237375410 21212893861675118723$16,010$30,6491313.006.64.92.06.02.519.522171454.1614.106.0025327532544188510092.0828945088 213129582421191111109$15,311$20,376703.7015.79.71.28.01.484.516355309.4829.0011.7032569552974240715172.2939245948 214206588829531117059$14,844$21,704754.7022.60.51.49.00.510.491428632.5027.5010.00422416574686359129012.4964929372 2152328164939771120810$15,622$21,779696.4029.88.61.38.01.473.530409353.4527.8012.60610918345473464027542.39739410946 2162501170942101124779$17,323$22,574877.3028.24.52.47.02.476.5286411762.4625.2010.00712423036691508935722.48866113382 217701503562010577011395189$22,892$33,814455.70867.21.60.37.03.479.523214115402.3017.505.301049515303812427773955389681.40112923248554 2189444251369119103$14,099$14,340421.5021.60.32.66.01.469.535215227.5448.6017.3031679042087173812072.6829454174 2193251171549661120820$16,308$25,776453.4045.92.49.50.01.532.473298219.4322.807.70590821096627402821482.51617613254 2204388235467421134121$14,655$20,868664.3051.36.71.28.01.481.521345625.1729.506.901046431508868717344662.291163917736 2213251218254331122062$14,735$19,724623.4035.39.66.33.01.473.5295413031.5831.2010.40659020355466464033312.34797110932 2221956113930951118584$14,071$24,055645.1028.81.83.16.02.483.518488327.4821.7010.60541916715179400823072.17631510358 22377733304110771171548$17,794$26,672575.20124.39.65.32.03.485.5213910447.1521.606.20223627083205021392276792.352160141004 2243909217160801131052$17,798$25,851618.7050.19.49.49.02.487.516355758.1924.509.40883933299503599833832.51938119006 225240291033121115597$16,498$25,035570.0027.36.68.32.01.477.525478561.5519.106.60423613763925349325672.3260607850 226953351847911381411453646$22,719$34,916305.901482.99.72.19.10.480.52414561423.1414.905.301165464363814461096063527891.28148852289220 2274193139955921131734$14,523$24,269652.4048.64.78.21.01.481.520406395.2122.307.80948426888559681341902.221100317118 2281542191152453611181414$22,135$31,681269.90672.15.73.24.03.484.5187329923.1815.804.5050887210985908533854164901.2750344118170 229108292788136171187464$17,684$29,4781084.8080.63.82.14.05.489.513488454.1018.404.302512410087258101742290212.182644351620 2302617110237191113811$15,197$25,221623.9022.14.89.10.01.474.526519978.7317.306.00370211303782314320542.1151977564 2315852188977411142067$18,052$27,351471.4089.24.56.42.02.485.5175418931.4522.903.3096601076710074701045562.441156620148 23297204852145721182665$17,859$34,090648.10127.55.92.06.02.495.5059227126.3813.507.70250927691262501657670561.082363252500 233123134415751113073$14,691$18,448624.1020.95.37.62.01.480.523166382.5136.9013.00434112443433245116042.6340556866 2344437174461811131830$15,870$21,423794.3040.07.56.43.01.471.5326715206.4828.6011.90948629818182641347682.441118116364 2354527194864751137260$15,419$21,7281256.4029.66.57.41.02.476.5288014692.4028.007.901086754259336705945732.431163218672 236844062090210530811474051$22,472$22,285180.602624.87.31.64.05.468.543262117123.2433.607.801274415432614229090253597411.69149994284580 2371947365202599311146713$19,466$27,114611.00240.12.65.33.02.471.53115765910.4623.006.4042072178544111628947167241.354567182232 2383673227459471125845$18,613$28,734844.6030.60.68.25.07.506.498254664.1819.005.70781325987784526423861.32765015568 2394379247768561123113$16,727$25,304557.4041.47.56.44.01.481.521244551.2023.708.90675921136469475130212.44777212938 24019792112223101411126283$19,447$25,6381322.7095.47.68.30.02.476.52619451997.4022.106.8035408120563647926065162751.324234072958 24111515741725119698$15,843$20,079388.6024.96.58.41.01.472.529234797.5127.2013.3029378782435196814802.4234484870 242312695240781120829$15,603$19,708558.5037.29.61.38.01.470.5335812966.6330.9010.60630218645369422830662.39729410738 243126879020581123665$15,529$23,719865.3027.35.74.19.08.492.5177811043.4921.307.30654219535847549738262.26932311694 2441629814166304641166510$18,225$30,180465.20142.97.86.05.09.479.523314638.0714.706.90171086168198401442389711.142339439680 245112912308135991146930$20,698$38,940283.70165.42.70.26.03.489.515257643.1812.706.8014226406515611928137471.301302831222 246201911053124119765$14,242$21,578408.4023.91.45.54.00.478.524246070.6127.207.6029649792613196212472.5532095226 2474321135756781120905$17,905$28,768246.1084.95.47.52.01.477.525153831.1820.2011.10635022466066408621571.53624312132 2486630227389031141991$17,530$33,611218.90191.83.58.38.03.488.514164829.1217.909.5013698371413847720635261.421073227694 249137226920206421182804$16,426$21,130928.7089.16.56.43.01.477.5276914051.1730.108.302538677132190717331104671.442779843814 2504499258370821146165$13,941$24,808739.9062.39.63.35.02.486.517183541.0821.506.7014409470013488892346451.371356826976 2516800235791571157068$16,630$26,230612.9093.11.61.34.05.490.5135912445.2123.907.80176975566165681140958282.391723733136 2523741276304504211178621$22,966$41,277854.40209.06.85.12.04.493.50911831847.2211.604.9051812132555850337903171481.1555051117006 253164726501229731193873$15,925$23,384790.30118.78.68.31.02.479.52212132990.3826.509.402796510993267341837298092.322818153468 25411313801511116829$16,996$17,001602.5011.33.44.55.00.461.543213649.5139.009.3021785481744127310862.5623593488 2551325435091676311101829$17,361$28,4021255.1081.13.75.18.07.489.5145114945.1520.104.803154810061306962010094241.252952461392 2562939140343421121593$18,109$24,857877.7024.60.70.30.01.480.5227713535.6520.006.80588418685714492831992.30812711428 2575566229078561151082$16,461$24,8551173.9043.51.82.15.03.485.516394694.0921.005.70151444440141181047269082.181738028236 2584325203563601154089$14,526$24,1871328.5040.71.69.22.10.576.4357919683.3218.307.10141631289916550659238852.311047733100 25978983218111161143088$16,177$21,477669.6064.35.66.33.01.483.5187820470.4728.508.5011959366611885934262362.341557823770 2604350198963391142477$16,553$24,167595.9071.28.66.34.01.473.5287821451.5120.7010.0011212357311180968868241.341651222360 2614975233473091120480$19,621$30,819191.20107.11.60.38.01.484.51893287.1717.606.60588021196342415919801.40613912684 262172662623521112198$13,611$19,605359.4033.94.81.18.01.479.522377355.6126.4015.1034479943094277218912.1946636188 263110941215211113174$12,438$28,219406.0032.45.42.57.01.671.33593776.2925.507.6026381172611523059442.58324912230 2642503122537281117878$14,005$23,425950.6018.81.65.34.01.518.485569611.5924.307.00455718955099370826192.35632710198 315238471370013157$13,516$20,722988.003.201.00.00.00.494.506111217.3813.701.408081688716376732.0013101742 321150390650560112506$15,745$20,4191491.808.40.99.00.01.488.512415528.4417.003.20302112963249230226382.0149406498 3368517332418017191$12,633$16,9171388.605.20.62.00.38.504.496342279.3231.708.0024365901764128211192.3824013528 34218379597011094$10,476$22,6391151.501.001.00.00.00.523.477443.0429.604.30350663242181362.00354648 35190220973999017953$15,592$22,2941668.704.80.99.00.01.503.497304362.5412.904.1020186042119155316592.0132124238 3663610321668013578$15,627$21,4781162.103.101.00.00.00.490.510161645.4615.601.609811869967496662.0014151992 375248531377012953$15,992$19,1601103.602.70.99.00.01.502.498202013.6718.402.507041277277036922.0113951454 38862313635222580160267$17,218$28,4501633.2036.80.96.00.04.485.5156319015.3210.003.80163526045206521076764511.041721841304 397444240923153601103215$17,620$26,8061765.7058.30.97.00.03.498.50211933845.3311.803.1025142160603592515939101491.032608871850 31070820762784016039$14,286$21,2501489.104.10.99.00.01.500.500312287.3814.104.1015833301567137611832.0125593134 31157420552629016043$14,746$20,2481131.105.40.99.00.01.495.505252951.4817.802.5014785901480118813072.0124952960 31230711591466012878$13,453$21,5071259.402.30.99.00.01.499.501191370.4712.501.706741137006177742.0113911400 31372311561879013975$9,798$19,8242010.002.00.90.00.10.516