Major 2 Decision Analysis Using Correlation and Regression Download a copy of BUSI… 1 answer below »

Major 2: Decision Analysis Using Correlation and Regression Download a copy of BUSI 5423.Major2.SampleData.xlsx for this project. You will conduct correlation analysis on the factors that best predict sales at a restaurant chain, and develop a basic linear regression equation to predict the optimal location for a new outlet. Your response will consist of two parts: Part 1: A write-up of your analysis. The write-up should consist of a statement of the business problem, a discussion of the available data, your analysis and the conclusions you have drawn. Proper formatting of text and tabular data is essential to the successful completion of this part. Part 2: Management summary PowerPoint. Create a PowerPoint presentation that is suitable to a management review. Present the business problem, summarize the significant correlations with graphs, and present a summary of the regression model, with your recommended actions.ZIPLocationNameMonthly_SalesPercent_Target_Lifestyle_ClusterMedian_IncomePopulation_per_sq_mileEmployee_Turnover_RateManager_tenure_monthsBrand_recognitionAdvertising_budget_per_monthCompetitors_within_5_miles10031New York$676,1870.50$75,00020,1450.61260.59$5,238.481810040New York 2$482,1240.40$45,10018,3900.6930.41$4,920.901410110Brooklyn$510,5460.51$70,4042,8960.5090.40$4,257.72410846Hudson$578,6200.64$73,6352,7310.57130.42$8,669.27312460Fishkill$551,5510.46$75,0632,4590.93140.46$7,322.16712589Platekill$611,4520.23$36,5133,9900.45250.46$5,429.76613280Schenectedy$562,6470.50$61,6592,3160.67110.52$8,556.03613501Utica$545,4850.23$30,0004,4690.93100.42$4,035.03313660Madrid$658,8320.24$28,4924,0090.85190.46$6,733.19314220West Seneca$525,9150.39$62,9031,3270.2420.40$9,132.64314221Williamsville$550,2390.48$75,0002,3080.76140.44$5,285.83314223Kenmore$584,8860.36$53,0006,6010.1860.48$3,675.41514730Randolph$540,7670.32$53,0805920.2740.40$8,336.28314781Sherman$486,3610.04$54,78413,0030.3450.42$5,009.711015901Johnstown$531,5120.23$26,3092,6500.60110.48$3,836.89516001Butler$568,4140.47$53,4652,4370.53130.49$8,867.32416301Oil City$611,3180.20$29,2922,5480.41110.54$5,240.84516701Bradford$598,2090.28$46,4751,1400.74310.54$5,389.79417303Arendstville$611,9640.29$45,1016400.47180.49$2,546.00417786Jonestown$614,9710.23$27,4942,4550.42150.47$8,463.47517979Amherst$705,1740.48$78,5672,1410.49180.54$3,863.92218074Spring Mount$501,1850.23$37,0751,9870.6240.47$2,738.66418101Allentown$552,9420.72$105,7875740.5580.42$8,163.23320210Washington$601,3670.80$115,6798,4500.47180.50$5,201.991420270Washington #2$479,6620.57$78,1256,5400.6830.42$3,967.321222030Fairfax$646,1670.54$145,1891,2350.4790.52$6,250.95722035Fair Oaks$567,0030.62$69,2261,0890.2660.50$7,481.81222039Burke Center$495,8440.37$52,6472,8320.70110.46$3,813.38322186Camp Springs$493,0640.11$15,3631,4160.8930.38$2,982.35322197College Park$567,2880.13$14,3612,2600.50180.40$4,098.05723264Morgantown$495,3770.11$17,4575,1430.4860.44$3,328.27223330Beltsville$426,2840.10$13,8101,5360.4140.32$3,246.20323563Fair Lawn$717,9620.19$23,1493,5830.75350.55$5,037.11525455Richmond$563,1550.38$44,6511,8330.86160.43$5,735.99525542Chesapeake$566,4620.13$20,1811,3380.1540.48$7,537.53226269Huntington$597,4630.46$51,8261,6500.52110.45$5,478.42527169Dumfries$580,3390.25$63,9823,2840.71110.49$5,289.51227296Bucksnort$535,5980.26$38,8155530.6670.38$9,549.00427879Nashville$491,8440.31$51,5602,5060.66110.37$8,989.54528087Grenstown$606,0150.32$66,9838460.55170.51$3,624.45428105Charlotte$575,3640.85$132,72119,4500.45100.53$8,346.111628220Charlotte #2$592,9250.59$90,3013,1990.30170.49$5,962.13228799Williamsport$564,0250.33$46,9783,0660.52130.50$6,196.89329105East Juhunga$548,4180.12$18,4131,0800.1720.41$9,975.27329267West Juhunga$629,1550.31$35,5392,6930.49190.54$5,149.74329418Depot$699,0430.38$59,5072,4870.59360.55$4,082.18430191Carie$525,3590.45$51,6131,8690.64160.49$4,911.81330309Greensboro$602,0730.48$57,5472,2900.58100.45$8,725.24531484Akron$687,7100.14$17,6124,5140.90290.63$5,639.04331612Canton$618,0010.54$62,1287710.61210.53$4,553.44432090Cleveland$600,9060.17$20,3432,5450.91210.56$3,336.15332833Morgantown$639,1020.17$28,0494,1470.64190.51$6,426.62333602West Windsor$512,7620.28$34,4231,0020.2930.48$7,907.89433965Cayahoga Falls$649,9380.88$133,5641,5520.42180.57$7,905.46333989Ashtabula$633,1270.30$36,8544,0850.81160.59$6,441.07334038West Falls$497,8690.28$40,1014,3470.1640.39$3,618.06434493East Falls$462,2950.14$21,5521,5980.4140.38$3,968.87434721Falling Falls$618,9990.42$59,5702,7730.66320.45$4,499.51435658Rising Fals$532,5700.28$35,6732,6540.64110.46$5,548.28535817Setting Falls$550,5160.29$44,4206,0010.4770.42$3,827.56435937North Falls$556,6630.42$48,2005,9020.4170.49$4,045.56337290South falls$541,0540.63$77,6091,2640.2890.43$8,089.05338124Outer Falls$594,4580.32$45,6103,0220.58210.46$6,011.43338542Oxford$658,8500.32$51,2312,9250.90180.50$7,649.03438886Cincinnatti$572,1480.43$48,5041,4510.33130.48$6,230.54639168Dayton$581,4930.20$61,5001,3210.42110.44$7,950.79439998Dripsville$522,1070.21$33,7011,8760.5350.39$3,109.02340220Louisville$579,6350.28$43,5006,9120.82120.53$11,033.93540221Louisville #2$623,6510.48$56,1503,7340.75310.51$4,985.38642492Bourbon Town$553,8350.22$33,06919,2920.5030.40$6,562.03742774Deep Holler$555,0260.24$46,4401,1080.2730.46$10,764.67443365Shallow Holler$534,1350.25$29,8612,1270.3760.50$4,585.37343411Mill Valley$638,9290.17$42,6096,6900.56220.58$8,693.74343824Fresno$618,4430.64$116,7281,4240.30150.57$7,225.92443931Williamstown$626,5790.21$32,7074,1470.71160.47$4,630.20343954Phillipsburg$536,7790.29$38,7931,6680.5150.39$3,479.73344511Oxford #2$514,0030.29$47,7061,9080.52110.44$5,667.96545741Denseville$574,2650.18$51,45017,5750.2850.49$6,362.17646258Greentown$574,7220.25$32,3811,4810.46170.48$7,110.38447136Brownstown$544,2770.97$113,1203,2490.50120.42$5,056.69448030Hazel Park$644,6330.20$46,7804,5430.63280.55$4,662.76348079St Claire, MI$530,2910.73$87,9532,6260.66120.42$3,229.76448101Allen Park$698,2570.26$37,0618730.70300.55$4,819.57349678Kalamazoo$555,2730.21$38,15014,3010.6950.48$6,251.63549747Kazoo City$519,1260.21$27,05617,9830.4440.44$5,310.45850213Decrepit$557,6600.32$42,0264,3270.45130.51$5,890.64550314Affluent Park$590,0140.94$132,7451,0020.30100.53$9,118.23350773Poverty Village$558,1870.11$23,5421,4240.92100.44$6,237.47451196OK City$581,3650.63$74,6811,9190.31150.44$4,272.57551358Middle Earth$514,8720.31$35,5003,2020.7190.47$4,890.08451841Mordor$545,6380.18$20,9222,3990.60230.39$5,998.99352762Gretchum$669,5300.16$40,0413,6520.64230.48$6,188.70354515Ketchum$498,6220.22$30,5692,0130.4680.36$4,864.48955284Metchum$539,4530.57$84,4261,6850.65120.48$9,683.93555845Fletchum$603,3010.20$28,5097,8210.18180.56$7,581.99455989Kvetch$614,8790.42$61,9051,2890.37150.46$7,328.25456080St Claire, MN$622,7310.26$59,5993,2130.98210.58$7,903.78256569Ogema$644,5840.37$54,9348080.65250.49$4,094.31357281Prairie Town$577,3240.27$44,3221,6820.62150.52$6,234.70457578Mohegan$526,2580.41$55,9992,4180.7280.40$6,604.41657667Waukegan$500,9400.40$45,5682,2050.74110.36$5,328.75358681Stone Village$522,6970.25$33,5863,1490.63120.44$7,725.39459031New Finland$604,9280.64$71,1313,5300.4890.43$3,574.38559100New Stokholm$567,2700.15$35,1502,9720.87210.43$7,593.54359663New Oslo$507,7770.27$33,90014,9070.4850.48$5,005.26860092Skokie$618,3760.48$65,0006,6540.24170.58$9,419.12660627Chicago$626,6650.79$95,7532,8640.85180.52$3,408.84360645Chicago #3$509,0460.43$64,4721,5810.6680.45$6,219.69760652Chicago #2$586,1450.39$49,94114,4390.4330.53$6,874.97661681Elgin$523,6530.38$55,0002,2340.4350.43$5,140.37861809Palwakee$548,3690.54$76,3152,8820.74130.39$3,769.39361817Mill Town$472,1820.42$61,6172,6870.57100.44$5,322.01362495Mill Stone$519,3780.29$36,2745480.4170.44$6,680.75362610Alsey$606,1450.46$57,9003,4730.53300.44$4,598.41663621Arcadia$417,3100.18$44,2001,5660.3130.39$3,418.97264242Martinville$548,1750.27$43,1197940.60210.50$5,306.55565092Rich Town$616,3110.95$135,1271,3950.57160.49$6,779.88366121Poor Town$562,1210.24$35,9891,1060.70160.50$4,316.31466239Poorer Town$618,4610.14$20,1207,5040.39130.47$7,859.71766597Middleburg$555,5590.06$37,9005,8240.38150.45$8,253.96666923Milwaukee$595,2080.33$39,9899520.64250.56$4,999.23467164Memphis$495,2840.29$46,9131,2650.50130.35$5,586.81467750East Memphis$682,9600.13$17,1092,3340.79360.57$4,610.42568039Madison$535,0550.16$19,7414,5540.3070.43$3,720.69368130Hillsboro$534,7640.57$65,2152,4930.7370.41$8,729.65668490Gufftown$516,9040.11$35,9871,3390.2040.47$7,030.46268581Dufftown$457,2610.24$30,1662,4470.6090.42$5,014.28368622Mufftown$554,3350.17$43,5007,7670.61180.39$8,733.40768794Lufftown$574,4750.20$37,1506,1440.53120.48$9,457.68768999Snufftown$556,7230.68$92,7401,8330.6690.40$8,258.89669991Bufftown$497,5590.48$54,4751,6390.56110.45$7,412.48470170New Orleans #2$581,6020.24$32,7502,3200.63180.52$3,191.15370190New Orleans$625,2640.30$37,8841,6170.34150.46$5,803.36271038Haynesville$529,1880.34$40,5354,5000.2260.47$3,672.74471065Pleasant Hill$528,0430.59$81,1086110.2750.41$6,158.85771104Auburn$516,5430.67$75,1054560.4240.41$7,845.16771202Monroe$622,2280.57$68,8651,8870.21170.48$4,287.13371409Alexandria$534,1840.28$41,0342,1170.88150.39$3,970.76372170Ulm$532,2800.25$30,0051,2380.5860.46$8,925.17372212Little Rock$619,7780.29$46,5003,1940.72260.50$3,926.10672315Blytheville$455,3220.26$42,9001,6740.5650.38$2,540.14373701Enid$555,9920.41$62,0651,6290.60170.50$4,957.59274014Broken Arrow$470,4930.52$69,0003670.5980.34$9,451.23874134Tulsa North$630,7640.38$51,0001,6280.95180.49$6,901.64475001Addison$559,2180.41$56,0003,6200.94180.46$7,951.32375002Allen$600,4100.66$101,0001,7830.33130.53$9,265.50475010Carrollton$486,8390.71$85,0002,8590.64100.35$4,861.53475010Castle Hills$558,1450.77$96,0002,3270.58170.41$3,926.60575033Frisco$583,1420.96$108,0001,6890.90140.49$6,247.95275050Grand Prairie$529,9590.33$44,0001,7200.7040.49$3,581.65275069McKinney East$520,7680.43$50,0001,0980.6030.46$10,858.72375071McKinney West$574,6790.63$90,0005170.9660.53$7,757.80575234Farmers Branch$654,8890.34$53,0002,7870.50200.53$8,405.92375431Como$545,0790.33$52,9741,2760.71100.39$8,314.08575490Trenton$570,0030.24$37,8992,7180.50110.42$6,645.34375956Kirbyville$594,8890.17$22,5073,3420.84220.45$7,248.92476010Arlington$614,9670.19$31,0006,5410.69170.52$10,269.14676108Wh Settlement$644,4280.34$56,0008980.96260.55$4,758.53376118Richland Hills$546,4710.41$57,0001,4290.74140.47$8,160.75776119S. Ft. Worth$614,9830.18$28,0002,7730.69300.47$4,745.83476120Ft Worth$519,7110.30$43,0002,1090.8390.49$4,587.16676201Denton$517,2200.20$24,0005,0390.4860.40$2,927.66476210Lewisville$553,0860.59$92,0002,4330.47120.47$7,449.77477305Conroe$512,9520.28$45,8907,2170.7530.46$5,925.071177830Anderson$477,3140.42$61,8726090.3450.45$8,865.18377901Victoria$515,4850.27$31,0931,4250.5130.44$10,143.40678210San Antonio$676,1360.58$77,7281,5920.50170.50$8,287.78278257San Antonio #2$545,3800.91$133,3261,0510.34160.41$7,356.06578501McCallen$584,8070.47$70,1212,6600.5990.51$8,146.74378620Dripping Spring$467,5550.31$51,7792,5140.73110.40$3,801.87578664Round Rock$612,7270.42$66,0003,5090.76260.53$5,294.94478703Austin$565,5240.34$54,9731,8090.6380.44$9,652.55378705Univ of Texas$547,6280.11$18,50015,0910.4940.43$4,639.78578732Steiner Ranch$605,0110.89$150,0001,2620.69140.46$8,126.32578746West Lake Hills$575,7970.84$136,0001,2430.8080.51$8,269.30378755Austin #2$545,7760.35$42,4132,3710.3980.52$6,436.691078767Austin #3$550,5030.37$43,5482,4250.46100.39$7,192.11278801Uvalde$489,1280.19$26,6273,4510.45140.35$9,041.35479521Haskell$506,0600.36$40,0491,4980.4870.46$8,015.15480110Denver$558,9280.48$56,7628,8150.51140.50$7,736.701380234Westminster$590,4660.56$83,3101,0800.42100.52$6,785.13380250Denver #2$605,8650.83$92,5222,1220.27150.52$8,914.00780510Allen’s Park$567,2030.92$120,9271,0220.37100.43$7,108.10581238Copper Town$609,0660.15$24,3481,1630.56180.45$8,304.68881486Boulder$477,0300.40$59,9902,3450.5380.41$5,040.491181642Norrie$581,7720.33$46,0583,4300.42120.50$3,922.19482242Van Tassell$505,0060.08$32,1925,9350.5170.38$4,462.13288199Fort Sumner$520,9130.20$28,7633,2450.56140.37$6,685.15289046Las Vegas$432,9410.35$38,8069750.8720.37$10,106.36290210Beverly Hills$545,1550.61$135,9361,1530.82100.47$6,770.69990230Culver City$640,0440.62$97,23512,4140.68130.50$4,580.75890290Topanga$579,5000.08$51,0988,0180.87130.45$8,958.19690291Los Angeles$525,9130.42$62,9331,9960.44110.37$7,969.35290540Manhattan Beach$559,2990.65$99,6631,4270.40150.47$6,688.86590701Artesia$542,7040.72$87,5386610.7770.45$9,105.83590702Artesia #2$654,9060.42$53,3723,0680.53250.48$7,585.79490717Lomita$718,7260.30$41,2223,2860.54210.55$9,603.71394570Moraga$508,7530.43$56,1114490.6360.45$7,615.78795081Van Nuys$621,9640.49$60,1714,4210.73240.48$5,239.11595217Anaheim$498,2850.62$76,8004,7780.2140.38$3,818.01777047Houston NEW#NULL!0.60$50,5001,780#NULL!120.65$5,000.00677581Pearland NEW#NULL!0.24$82,0001,727#NULL!180.60$5,000.00478401Corpus Ch NEW#NULL!0.23$44,0001,966#NULL!180.30$5,000.00377373Spring NEW#NULL!0.66$70,0002,389#NULL!110.58$5,000.00875025Plano NEW#NULL!0.76$109,0005,579#NULL!150.38$5,000.005