# 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

1. Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount