1. Provide a brief introduction – a reminder of the main purpose of the sales pitch and the data used
2. Explain what regression analysis is and why it is valuable
3. Find interesting and informative ways to visualize the different regression results
4. Find visuals that emphasize the most important conclusions
5. Address the potential impact of North Carolina adopting a lottery on VA lottery sales. Be sure to incorporate data visualization for this
6. Provide a brief summary of the work.
[removed],
Sheet1
County | population | %under18 | %white | %Hsgrad | %coll | TravelTme | percapinc | metarea | pop18 | %nonwh | Retail | Retailpercap | Scratcher | Kicker | Lotto | biggame | pick3 | pick4 | cash5 | totalsales | totcap | scrcap | kickcap | lottcap | bigcap | p3cap | p4cap | c5cap | Ten | Ken | wv | nc | my | dc | percapinc | nonwh | TravelTme | metarea | retpercap | %Hsgrad | %coll | logtot | logbigg | loglotto | logpic3 | logpic4 | logcash5 | Ten | Ken | wv | nc | my | dc |
Accomack | 38,305 | 24.3 | 63.4 | 67.9 | 13.5 | 23 | 16,309 | 0 | 28996.885 | 36.6 | 46 | 1.5863772954 | $2,104,856 | $25,668 | $290,464 | $334,259 | $2,376,497 | $1,122,857 | $66,875 | $6,321,476 | $218.01 | $72.59 | $0.89 | $10.02 | $11.53 | $81.96 | $38.72 | $2.31 | 0 | 0 | 0 | 0 | 1 | 0 | 16,309 | 36.6 | 23 | 0 | 1.5863772954 | 67.9 | 13.5 | 5.3845196148 | 2.4447270134 | 2.3042913096 | 4.4061944233 | 3.6564431987 | 0.835636523 | 0 | 0 | 0 | 0 | 1 | 0 |
Albemarle | 79,236 | 24.8 | 85.2 | 87.4 | 47.7 | 22.3 | 28,852 | 1 | 59585.472 | 14.8 | 51 | 0.855913334 | $3,065,311 | $56,371 | $644,426 | $531,978 | $1,723,791 | $757,907 | $185,725 | $6,965,507 | $116.90 | $51.44 | $0.95 | $10.82 | $8.93 | $28.93 | $12.72 | $3.12 | 0 | 0 | 0 | 0 | 0 | 0 | 28,852 | 14.8 | 22.3 | 1 | 0.855913334 | 87.4 | 47.7 | 4.761313905 | 2.189190055 | 2.3809476527 | 3.3648691684 | 2.5431486412 | 1.1368542931 | 0 | 0 | 0 | 0 | 0 | 0 |
Alleghany | 12,926 | 22.8 | 96.3 | 77.5 | 13.6 | 24.6 | 19,635 | 0 | 9978.872 | 3.7 | 11 | 1.1023290007 | $801,201 | $16,221 | $156,825 | $121,415 | $271,099 | $106,969 | $58,364 | $1,532,095 | $153.53 | $80.29 | $1.63 | $15.72 | $12.17 | $27.17 | $10.72 | $5.85 | 0 | 0 | 1 | 0 | 0 | 0 | 19,635 | 3.7 | 24.6 | 0 | 1.1023290007 | 77.5 | 13.6 | 5.0339210679 | 2.4987484445 | 2.7546592724 | 3.3020139643 | 2.3720732865 | 1.7662374303 | 0 | 0 | 1 | 0 | 0 | 0 |
Amelia | 11,400 | 25.3 | 70.6 | 68.3 | 9.8 | 41.5 | 18,858 | 0 | 8515.8 | 29.4 | 14 | 1.6440029122 | $603,663 | $9,051 | $95,078 | $108,689 | $603,618 | $272,410 | $34,198 | $1,726,706 | $202.76 | $70.89 | $1.06 | $11.16 | $12.76 | $70.88 | $31.99 | $4.02 | 0 | 0 | 0 | 0 | 0 | 0 | 18,858 | 29.4 | 41.5 | 0 | 1.6440029122 | 68.3 | 9.8 | 5.3120476724 | 2.5465692408 | 2.4127694929 | 4.2610177164 | 3.4653850091 | 1.3902543632 | 0 | 0 | 0 | 0 | 0 | 0 |
Amherst | 31,894 | 23.5 | 77.7 | 70.6 | 13.1 | 23.6 | 16,952 | 1 | 24398.91 | 22.3 | 29 | 1.1885776865 | $2,413,409 | $44,400 | $390,868 | $336,050 | $1,785,062 | $671,584 | $130,163 | $5,771,537 | $236.55 | $98.91 | $1.82 | $16.02 | $13.77 | $73.16 | $27.53 | $5.33 | 0 | 0 | 0 | 0 | 0 | 0 | 16,952 | 22.3 | 23.6 | 1 | 1.1885776865 | 70.6 | 13.1 | 5.4661552316 | 2.6227219878 | 2.7738306551 | 4.2926701095 | 3.315101159 | 1.6742501654 | 0 | 0 | 0 | 0 | 0 | 0 |
Appomattox | 13,705 | 24.7 | 75.9 | 70.7 | 10.5 | 29 | 18,086 | 0 | 10319.865 | 24.1 | 13 | 1.2597064012 | $962,182 | $15,464 | $153,627 | $109,138 | $859,537 | $378,746 | $53,354 | $2,532,048 | $245.36 | $93.24 | $1.50 | $14.89 | $10.58 | $83.29 | $36.70 | $5.17 | 0 | 0 | 0 | 0 | 0 | 0 | 18,086 | 24.1 | 29 | 0 | 1.2597064012 | 70.7 | 10.5 | 5.5027128879 | 2.3585453132 | 2.7004560512 | 4.4223227007 | 3.602794791 | 1.6428874831 | 0 | 0 | 0 | 0 | 0 | 0 |
Arlington | 189,453 | 16.5 | 68.9 | 87.8 | 60.2 | 27.3 | 37,706 | 1 | 158193.255 | 31.1 | 118 | 0.74592308 | $6,330,114 | $81,581 | $1,225,714 | $3,033,103 | $4,030,748 | $3,238,682 | $579,310 | $18,519,252 | $117.07 | $40.02 | $0.52 | $7.75 | $19.17 | $25.48 | $20.47 | $3.66 | 0 | 0 | 0 | 0 | 0 | 1 | 37,706 | 31.1 | 27.3 | 1 | 0.74592308 | 87.8 | 60.2 | 4.7627486983 | 2.9535239647 | 2.0474614277 | 3.2378897934 | 3.0191044078 | 1.2980203203 | 0 | 0 | 0 | 0 | 0 | 1 |
Augusta | 65,615 | 23.7 | 95 | 78.2 | 15.4 | 23.7 | 19,744 | 0 | 50064.245 | 5 | 42 | 0.838922069 | $2,636,718 | $51,782 | $622,914 | $454,478 | $252,714 | $131,458 | $133,130 | $4,283,195 | $85.55 | $52.67 | $1.03 | $12.44 | $9.08 | $5.05 | $2.63 | $2.66 | 0 | 0 | 1 | 0 | 0 | 0 | 19,744 | 5 | 23.7 | 0 | 0.838922069 | 78.2 | 15.4 | 4.4491474489 | 2.2058431188 | 2.5211016619 | 1.6189506539 | 0.9653835476 | 0.9780176073 | 0 | 0 | 1 | 0 | 0 | 0 |
Bath | 5,048 | 21 | 92.3 | 74 | 11.1 | 24.4 | 23,092 | 0 | 3987.92 | 7.7 | 8 | 2.0060582961 | $221,292 | $5,315 | $52,984 | $52,209 | $75,226 | $38,241 | $22,462 | $467,729 | $117.29 | $55.49 | $1.33 | $13.29 | $13.09 | $18.86 | $9.59 | $5.63 | 0 | 0 | 1 | 0 | 0 | 0 | 23,092 | 7.7 | 24.4 | 0 | 2.0060582961 | 74 | 11.1 | 4.7646185693 | 2.5719918891 | 2.5867264676 | 2.937226105 | 2.2606288231 | 1.7285338497 | 0 | 0 | 1 | 0 | 0 | 0 |
Bedford | 60,371 | 24 | 92.2 | 80.1 | 20.9 | 27.8 | 21,582 | 1 | 45881.96 | 7.8 | 35 | 0.7628270457 | $2,400,252 | $48,257 | $460,039 | $354,464 | $947,402 | $453,708 | $132,047 | $4,796,170 | $104.53 | $52.31 | $1.05 | $10.03 | $7.73 | $20.65 | $9.89 | $2.88 | 0 | 0 | 0 | 0 | 0 | 0 | 21,582 | 7.8 | 27.8 | 1 | 0.7628270457 | 80.1 | 20.9 | 4.6495010403 | 2.0445360046 | 2.3052401712 | 3.0276513746 | 2.2913828139 | 1.0570848683 | 0 | 0 | 0 | 0 | 0 | 0 |
Bland | 6,871 | 19.4 | 94.8 | 70.9 | 9.2 | 33.4 | 17,744 | 0 | 5538.026 | 5.2 | 8 | 1.4445580429 | $450,317 | $4,949 | $50,581 | $111,839 | $16,347 | $6,550 | $10,102 | $650,685 | $117.49 | $81.31 | $0.89 | $9.13 | $20.19 | $2.95 | $1.18 | $1.82 | 0 | 0 | 1 | 0 | 0 | 0 | 17,744 | 5.2 | 33.4 | 0 | 1.4445580429 | 70.9 | 9.2 | 4.7663878701 | 3.0054217796 | 2.2119426823 | 1.0824013165 | 0.1678717259 | 0.6010983268 | 0 | 0 | 1 | 0 | 0 | 0 |
Botetourt | 30,496 | 23.4 | 94.9 | 81.4 | 19.6 | 26.7 | 22,218 | 1 | 23359.936 | 5.1 | 29 | 1.2414417574 | $1,699,648 | $28,362 | $333,760 | $248,736 | $226,071 | $110,822 | $77,875 | $2,725,274 | $116.66 | $72.76 | $1.21 | $14.29 | $10.65 | $9.68 | $4.74 | $3.33 | 0 | 0 | 0 | 0 | 0 | 0 | 22,218 | 5.1 | 26.7 | 1 | 1.2414417574 | 81.4 | 19.6 | 4.7593017835 | 2.3653676849 | 2.6593991624 | 2.2698276638 | 1.5569067149 | 1.2040869645 | 0 | 0 | 0 | 0 | 0 | 0 |
Brunswick | 18,419 | 20.5 | 42 | 63.2 | 10.8 | 30.8 | 14,890 | 0 | 14643.105 | 58 | 21 | 1.4341220663 | $1,969,197 | $24,941 | $290,625 | $333,394 | $2,075,233 | $916,705 | $109,272 | $5,719,367 | $390.58 | $134.48 | $1.70 | $19.85 | $22.77 | $141.72 | $62.60 | $7.46 | 0 | 0 | 0 | 1 | 0 | 0 | 14,890 | 58 | 30.8 | 0 | 1.4341220663 | 63.2 | 10.8 | 5.9676438157 | 3.1253542974 | 2.9880629609 | 4.9538592895 | 4.136815639 | 2.009874179 | 0 | 0 | 0 | 1 | 0 | 0 |
Buchanan | 26,978 | 21.4 | 96.7 | 52.9 | 8 | 33.4 | 12,788 | 0 | 21204.708 | 3.3 | 39 | 1.8392141971 | $1,548,375 | $15,996 | $142,856 | $198,391 | $70,399 | $10,670 | $35,083 | $2,021,770 | $95.35 | $73.02 | $0.75 | $6.74 | $9.36 | $3.32 | $0.50 | $1.65 | 0 |