Part 1 - Sporting Goods Project for MGMT 635 (Data Mining for Managers)Three Sectional Requirements: (Remember, you are a manager that utilizes data mining to make critical business decisions.  You...

1 answer below »
solve it


Part 1 - Sporting Goods Project for MGMT 635 (Data Mining for Managers) Three Sectional Requirements: (Remember, you are a manager that utilizes data mining to make critical business decisions.  You are operating in the high-paced competitive information economy.  You are required to make sound judgments based on data analytics.  Your competitors are trying to put you out of business…Don’t let them!).   1)  Input-data analysis.  You will upload an excel file with data that includes descriptions of sporting goods retail branches.  You are required to analyze the data and adjust it (e.g. formats, content) to focus your research.  In other words, you will be required to “trouble shoot” the data file and tell your data warehousing person what is wrong with it.    For example: are there errors; what variables are unnecessary, in order to perform a data mining analysis.  You are to return the adjusted file along with any other requirements that are stipulated on that file. Part 2 - Restaurant Project 2 for MGMT 635 (Data Mining for Managers) Three Sectional Requirements: (Remember, you are a manager that utilizes data mining to make critical business decisions.  You are operating in the high-paced competitive information economy.  You are required to make sound judgments based on data analytics.  Your competitors are trying to put you out of business…Don’t let them!). 2)  You will download an Excel file with a number of variables to run a regression analysis. You will use the statistical output of the model to help make decisions on where and the tactics you need to pursue to generate the highest revenue for a restaurant.  You are to analyze your regression results and devise a simple business plan using whatever information is critical to your strategic initiative.  In this case you need to advise your company on the factors/variables that effect the revenue of your proposed restaurant.   You are also required to use the results of your model to estimate the expected revenue of planned restaurants to be opened.  Finally, you need to analyze the data file with a neural net methodology and compare the results to the regression analysis for expected revenue. Part 3 - Restaurant Location Part 3 MGMT 635 (Data Mining for Managers)  Three Sectional Requirements: (Remember, you are a manager that utilizes data mining to make critical business decisions.  You are operating in the high-paced competitive information economy.  You are required to make sound judgments based on data analytics.  Your competitors are trying to put you out of business…Don’t let them!). 3) You are in the market to open a restaurant in a high consumption area, unfortunately the costs of operating a business there are high.  You are to use segmentation (partition in SAS) to analyze data of the restaurant market and answer a few financial questions about your venture.  You are to use the segmentation data file provided. Your output is a decision tree. Submit all the required files which has answers and finally make proper project Project Paper Upload your overall summary of project Sporting Goods Data Part 1.xls Sporting Goods Data RegionStore IDPopulationStore OpeningSales Staff/1000 Sq ftMonthly TrafficReviewAI SystemProduct PurchasedCoupon ReceiveAppAvg Monthy FacebookShip to StoreStore LocationStaff AgeSales BackGroundLoyalty Card% Sales Staff CollegeParking PlacesTotal Sales NorthEast100070,6364/19/08166,1901YesFootballMobile8%18,160No ShipStand Alone30OperationsNo75%9$156,607 NorthEast10014,77711/23/14191,6773YesFootballPC9%46,171No ShipMall22OperationsNo90%5$42,428 NorthEast1002101,53711/8/13910,4392NoFootballPC48%15,199No ShipMall25OperationsNo97%16$264,107 NorthEast100387,93211/13/08123,9715NoSoccerPC60%35,540No ShipStand Alone32OperationsYes92%8$100,466 NorthEast100427,7426/24/1322,8791NoTennisPC25%29,051No ShipStand Alone27OperationsYes89%9$72,839 NorthEast100545,13310/18/1241,8244YesTennisPC27%9,102No ShipStand Alone22OperationsNo95%7$46,147 NorthEast100665,29212/25/08118,2634YesTennisPC19%33,097No ShipMall28OperationsYes78%23$209,054 NorthEast100836,7971/6/13183,8112NoWorkOutMobile54%22,417ShipMall26Customer ServiceYes76%21$96,418 NorthEast100917,6229/4/1471,7932NoWorkOutMobile50%18,839ShipMall22Customer ServiceNo99%22$45,363 NorthEast101030,2527/31/14198,0023NoWorkOutMobile63%13,368No ShipMall30MarketingNo88%7$202,451 NorthEast101134,65912/26/10208,6254NoWorkOutPC40%16,425No ShipMall25MarketingNo94%23$218,213 NorthEast101222,3898/28/1488,7653YesWorkOutPC62%36,748No ShipMall24MarketingNo100%20$221,755 SouthEast101362,6847/13/12208,2024YesWorkOutPC1%44,506ShipMall22MarketingYes100%24$207,511 SouthEast101496,6317/10/10145,6281jWorkOutPC50%47,927ShipStand Alone27MarketingNo105%'NA$142,388 SouthEast101562,4841/26/09183,1003NoBikingPC18%47,248ShipMall28MarketingYes84%12$78,430 SouthEast101640,10812/27/12143,7291YesBikingPC16%'12,xxxShipStand Alone25OperationsYes95%23$94,344 SouthEast101745,5896/23/0844,2254NoBikingMobile22%28,169ShipStand Alone27OperationsNo80%22$106,893 SouthEast101869,4613/19/08149,0165NoBikingMobile39%9,619ShipStand Alone29OperationsNo78%11$228,105 SouthEast101918,64711/16/1264,3435NoFootballMobile37%36,756ShipMall20OperationsNo89%32$109,878 SouthEast102058,4245/1/1154,9873YesBikingMobile52%17,701ShipMall25OperationsYes82%17$126,171 SouthEast102110,10810/4/1268,8556NoFootballPC40%36,597ShipMall24OperationsYes85%15$224,032 SouthEast102246,2292/17/1492,2604NoFootballPC35%48,790ShipMall40OperationsYes79%9$57,178 SouthEast102320,7869/27/1485,0741NoSoccerPC10%41,381No ShipMall22OperationsYes88%22$128,372 SouthEast102412,0792/8/12145,3144NoSoccerPC26%1.xxxxNo ShipMall25MarketingNo70%15$134,444 SouthEast102561,5987/4/12145,3095NoSoccerPC64%49,976No ShipMall26MarketingNo65%16$134,318 SouthEast102634,9701/12/09163,1145NoSoccerPC31%31,897No ShipStand Alone24OperationsNo79%26$78,784 SouthEast102729,4681/22/11410,3154NoSoccerMobile47%24,234No ShipStand Alone55OperationsNo100%18$260,970 SouthEast102842,7456/21/0927,1962NoSoccerMobile39%44,774No ShipStand Alone27OperationsYes99%6$182,059 SouthEast102929,7764/30/11184,2104NoSoccerMobile17%41,382No ShipStand Alone28OperationsYes83%10$106,513 SouthEast103068,3046/16/091210,0092NoSoccerMobile63%17,904No ShipStand Alone19OperationsYes87%33$253,228 SouthEast103172,9021/18/1147,0534NoSoccerMobile63%34,176No ShipMall22MarketingYes94%23$178,441 SouthEast103270,95411/29/0895,9143NoSoccerMobile45%40,330No ShipMall24Customer ServiceYes98%28$149,624 SouthEast103352,63710/5/14101,3281YesSoccerMobile9%16,420No ShipMall19Customer ServiceYes84%33$33,598 SouthEast103443,1994/27/1149,0062YesSoccerMobile15%15,031No ShipMall22Customer ServiceYes87%33$227,852 SouthEast103548,7161/28/1344,1312YesTennisMobile56%14,533No ShipMall27Customer ServiceYes97%26$104,514 SouthEast103663,83010/24/1059,4662NoTennisMobile52%37,353No ShipMall34Customer ServiceYes81%14$239,490 SouthEast103795,6575/8/10188,4593NoTennisPC7%43,471ShipStand Alone23Customer ServiceNo81%35$214,013 NorthEast103862,8396/20/11153,9321NoRunningPC43%28,204ShipMall22Customer ServiceYes92%13$99,480 NorthEast103995,7136/27/1022,1373NoRunningPC13%35,919ShipMall25MarketingNo90%32$54,066 NorthEast1040101,7857/12/08177,0724NoRunningPC24%36,329ShipMall25MarketingNo92%26$178,922 NorthEast104150,0076/3/141510,4634YesTennisPC9%34,653ShipMall28MarketingYes78%10$264,714 NorthEast104222,0542/5/1369,2035NoSoccerPC16%32,177ShipMall25MarketingNo85%22$232,836 NorthEast104349,5285/29/10145,3991NoSoccerMobile21%26,334ShipMall24MarketingNo103%14$136,595 NorthEast104441,4588/31/11201,4242NoSoccerMobile65%24,831ShipMall29MarketingNo80%33$36,027 NorthEast104552,9535/17/0989,5014NoRunningMobile13%37,331ShipMall23OperationsNo83%13$240,375 NorthEast104687,4107/5/13144,7951NoRunningMobile40%49,373ShipMall23OperationsNo83%35$121,314 NorthEast104774,8305/10/1336,1675NoRunningPC36%48,839ShipStand Alone43OperationsNo97%17$156,025 NorthEast104893,22310/6/11183,3441NoRunningPC13%26,896No ShipMall21OperationsNo85%18$84,603 NorthEast104963,4044/10/12157,9251NoRunningPC27%45,815No ShipMall22OperationsNo94%21$200,503 NorthEast105091,0576/15/1454,2765NoRunningPC63%25,020No ShipStand Alone23OperationsNo104%13$108,183 NorthEast105151,0199/19/0929,9422YesWorkOutPC47%13,885No ShipMall23OperationsNo91%17$251,533 NorthEast105245,5513/13/13118,8913NoRunningPC6%11,314No ShipMall25OperationsNo100%34$224,942 SouthEast10535,44110/22/14179,0574YesRunningPC37%23,209No ShipMall22MarketingNo80%35$229,142 SouthEast10545,0196/1/1333,4424NoWorkOutMobile42%41,537No ShipMall28MarketingNo89%11$87,083 SouthEast105593,73012/26/09125,7714NoWorkOutMobile27%49,872No ShipMall30OperationsNo88%26$146,006 SouthEast105658,4262/25/1492,5021YesWorkOutMobile22%29,010No ShipMall20OperationsNo93%5$63,301 SouthEast105770,6364/19/0896,1902NoFootballMobile60%18,160No ShipStand Alone27OperationsNo75%9$156,607 SouthEast10584,77711/23/14111,6774NoFootballPC1%46,171No ShipMall22OperationsNo90%5$42,428 SouthEast1059101,53711/8/131310,4393NoFootballPC8%15,199No ShipMall25OperationsNo97%16$264,107 SouthEast106087,93211/13/0823,9713NoSoccerPC22%35,540No ShipStand Alone29OperationsYes92%8$100,466 SouthEast106127,7426/24/1342,8793NoTennisPC53%29,051No ShipStand Alone27OperationsYes89%9$72,839 SouthEast106245,13310/18/12141,8242NoTennisPC46%9,102No ShipStand Alone22OperationsNo95%7$46,147 SouthEast106365,29212/25/08188,2633jTennisPC37%33,097No ShipMall28OperationsYes78%23$209,054 SouthEast106476,2676/6/1149,8391NoTennisMobile42%27,848ShipMall18MarketingNo82%18$248,927 SouthEast106586,72612/7/0987,8623NoWorkOutMobile52%46,206ShipMall28MarketingNo87%20$198,909 SouthEast106627,90610/7/14126,7414NoWorkOutMobile33%21,795No ShipMall26OperationsYes82%29$170,547 SouthEast106758,05611/6/1453,0384NoWorkOutMobile10%28,062No ShipStand Alone21OperationsYes96%22$76,861 SouthEast106825,9528/17/14154,7561NoWorkOutMobile34%11,824No ShipStand Alone29OperationsYes79%8$120,327 WestCoast106927,73112/20/0976,5331NoWorkOutMobile22%41,066No ShipMall23OperationsYes104%26$165,285 WestCoast107059,1719/15/1195,0862NoWorkOutMobile6%49,897No ShipStand Alone26OperationsYes85%26$128,676 WestCoast107140,3151/12/1456,7011NoWorkOutMobile15%38,195No ShipMall26MarketingNo86%7$169,535 WestCoast107226,3243/7/08187,8043NoRunningMobile52%38,943No ShipMall24Customer ServiceNo88%21$197,441 WestCoast107378,0653/25/14123,1852NoRunningMobile60%31,618No ShipStand Alone30Customer ServiceNo84%7$80,581 WestCoast107474,7544/7/12126,7103NoRunningPC31%26,998ShipStand Alone29Customer ServiceNo99%5$169,763 WestCoast107524,6547/29/1148,9891NoRunningPC6%22,476ShipStand Alone23Customer ServiceYes91%8$227,422 WestCoast107625,58211/14/1141,6675NoSoccerPC8%26,528ShipMall25Customer ServiceNo95%16$42,175 WestCoast107715,28911/3/12179,4861NoSoccerPC25%30,319No ShipMall25Customer ServiceNo82%28$239,996 WestCoast107819,1504/6/09109,1291NoSoccerPC14%30,404No ShipMall44Customer ServiceYes93%14$230,964 WestCoast107939,40310/3/1466,1521YesSoccerPC9%11,349ShpNoShipMall25Customer ServiceYes79%30$155,646 WestCoast108029,3516/28/10154,4393YesSoccerMobile0%37,483No ShipStand Alone26Customer ServiceYes81%12$112,307 WestCoast108135,8734/20/14152,6014NoTennisMobile18%15,264No ShipStand Alone21Customer ServiceNo76%24$65,805 WestCoast108212,8991/27/1458,4171YesTennisMobile65%11,408No ShipStand Alone24Customer ServiceNo77%17$212,950 NorthEast108326,32811/4/101710,0471NoSoccerMobile18%31,690No ShipMall22Customer ServiceNo81%9$254,189 NorthEast108465,6486/20/0926,3565NoRunningPC18%17,600ShipMall27Customer ServiceNo75%7$160,807 NorthEast10858,8592/2/10102,6842YesRunningPC19%14,439ShipMall29Customer ServiceYes105%22$67,905 NorthEast108687,5857/2/14156,8794YesRunningPC7%26,084ShipMall55Customer ServiceYes90%7$174,039 NorthEast108780,3729/18/0963,0594YesRunningPC42%20,628No ShipStand Alone24Customer ServiceYes86%13$77,393 NorthEast108844,4736/6/1324,3862YesRunningPC5%21,637No ShipMall29Customer ServiceYes89%30$110,966 NorthEast108947,0208/10/10202,9395YesWorkOutPC60%13,263No ShipMall29Customer ServiceYes90%20$74,357 NorthEast109013,60711/17/0945,1594NoWorkOutPC9%20,225No ShipMall20Customer ServiceYes77%8$130,523 NorthEast109127,2133/8/1499,6681NoWorkOutMobile28%18,904No ShipMall25Customer ServiceYes86%7$244,600 NorthEast109267,5093/31/10176,0152NoWorkOutMobile49%14,888ShipMall29Customer ServiceYes96%5$152,180 NorthEast109388,6377/27/1034,8304NoWorkOutMobile23%48,326ShipMall27Customer ServiceYes88%30$122,199 NorthEast109417,9536/17/08132,3231YesWorkOutMobile22%20,342ShipMall22Customer ServiceNo85%17$58,772 NorthEast109583,1795/8/0867,5512NoWorkOutPC39%43,609ShipMall25Customer ServiceNo78%10$191,040 NorthEast109678,8734/19/09122,1302NoWorkOutPC64%10,666ShipMall29MarketingNo92%22$53,889 NorthEast10975,1939/3/1194,8792YesWorkOutPC22%33,845ShipMall28MarketingYes80%26$123,439 NorthEast109892,3758/1/10126,6241YesFootballPC50%21,226ShipMall24MarketingYes95%33$167,587 NorthEast109966,2841/1/121410,5041YesTennisPC45%40,154ShipMall28MarketingYes94%33$265,751 South-West110079,5653/14/0931,3535NoTennisPC20%13,243ShipStand Alone25MarketingYes78%17$34,231 South-West11019,2882/29/12111,6862NoFootballMobile33%12,358ShipStand Alone27MarketingYes82%30$42,656 South-West110271,7581/19/12104,1652NoFootballMobile64%12,980ShipStand Alone25MarketingYes78%16$105,375 South-West11037,14811/3/13149,3765NoFootballMobile17%15,870ShipStand Alone23MarketingNo90%13$237,213 South-West110494,9191/21/12141,7843NoFootballMobile22%26,368ShipMall60MarketingNo96%17$45,135 South-West110553,6402/11/10202,6033YesSoccerMobile61%37,445ShipMall21MarketingNo87%11$65,856 South-West110643,02412/30/09199,1674NoRunningMobile60%16,448ShipMall25MarketingNo78%13$231,925 South-West110786,7346/15/12112,6373YesRunningMobile1%9,701ShipMall28MarketingNo76%29$66,716 South-West11087,3561/22/1087,3523YesWorkOutMobile52%49,632ShipMall29MarketingNo88%25$186,006 South-West110974,6053/28/14118,4633NoWorkOutMobile65%46,077No ShipStand Alone29MarketingYes82%14$214,114 South-West111069,0978/11/1126,6974NoWorkOutMobile8%15,779No ShipStand Alone48MarketingNo80%17$169,434 South-West11118,1615/26/1124,8175NoWorkOutPC13%31,933No ShipStand Alone30MarketingYes90%21$121,870 South-West111235,9023/14/1474,8325YesWorkOutPC15%30,256No ShipMall22OperationsYes86%32$122,250 WestCoast111329,3671/11/101010,2915YesWorkOutPC23%40,165No ShipMall24OperationsYes83%30$260,362 WestCoast111462,14311/28/12187,8511YesWorkOutPC41%34,288No ShipStand Alone27OperationsNo86%14$198,630 WestCoast111557,8734/17/10171,7022YesWorkOutPC54%30,164No ShipStand Alone18OperationsYes100%15$43,061 WestCoast111610,7792/28/1226,9865NoWorkOutPC55%38,816No ShipMall29Customer ServiceNo96%11$176,746 WestCoast111719,6748/10/08142,1144NoSoccerMobile9%30,021No ShipStand Alone30Customer ServiceYes98%21$53,484 WestCoast111871,8168/8/0956,7803NosMobile30%22,184No ShipStand Alone23Customer ServiceNo80%17$171,534 WestCoast111981,8811/28/13113,9965NossMobile55%14,475ShipStand Alone67Customer ServiceYes91%6$101,099 WestCoast1120100,9523/9/08133,1254YesRunningMobile3%36,749ShipStand Alone22Customer ServiceYes100%22$79,063 WestCoast112115,2428/2/08179,2902YesRunningPC21%10,345ShipStand Alone24Customer ServiceYes93%27$235,037 WestCoast112282,9942/29/1285,6352YesRunningPC3%33,063ShipStand Alone44Customer ServiceNo84%27$142,566 WestCoast112384,4784/29/12191,3113YesRunningPC39%30,335ShipStand Alone21Customer ServiceYes81%4$33,168 WestCoast112435,1758/27/1027,6615YesRunningPC24%48,761ShipStand Alone23Customer ServiceYes92%34$193,823 WestCoast112588,85311/23/10199,4005YesRunningPC32%18,522ShipStand Alone20MarketingYes93%13$237,820 WestCoast11264,9983/24/14183,0593YesRunningPC11%9,779ShipMall27MarketingNo82%22$77,393 WestCoast112730,2229/26/1028,3655YesWorkOutPC30%33,358No ShipMall23MarketingYes95%13$211,635 WestCoast112818,1387/4/09184,6831YesRunningPC8%33,183No ShipMall26MarketingYes90%9$118,480 WestCoast112913,0998/19/141010,3901NoFootballPC36%34,362No ShipMall30Customer ServiceYes94%21$262,867 NorthEast113087,5035/8/1278,6683YesFootballPC49%44,378ShipMall29Customer ServiceYes95%25$219,300 NorthEast113190,6729/25/09610,2463NoFootballPC36%12,958ShipMall29Customer ServiceNo103%23$259,224 NorthEast11326,60711/9/08131,8122NoFootballPC49%42,844ShipMall20Customer ServiceNo77%23$45,844 NorthEast113398,0245/24/0869,7471NoFootballMobile52%32,288ShipMall26Customer ServiceNo82%4$246,599 SouthEast113451,2994/20/08154,8944NoBaseballMobile31%15,336ShipMall20OperationsNo96%18$123,818 SouthEast113586,21911/20/14174,4181YesBaseballMobile3%47,007ShipStand Alone27OperationsYes109%26$111,775 SouthEast113674,81312/5/14162,8992NoWorkOutMobile2%38,176ShipMall26OperationsYes99%26$73,345 SouthEast113740,6216/12/09148,4325NoWorkOutPC31%14,956ShipMall26OperationsYes78%12$213,330 SouthEast113893,2105/15/1471,6563YesWorkOutPC18%38,109No ShipMall24OperationsYes87%20$41,897 SouthEast113917,81810/22/1397,3414YesWorkOutPC51%12,524No ShipMall21Customer ServiceYes84%26$185,727 SouthEast114042,5407/27/1444,5841NoBaseballPC-20%32,344No ShipMall29Customer ServiceYes89%5$115,975 SouthEast11419,54512/13/11127,9151NoBaseballPC50%11,306No ShipMall24Customer ServiceYes78%20$200,250 SouthEast114289,7464/29/08183,6532NoBaseballPC48%11,948No ShipMall43Customer ServiceYes93%17$92,421 SouthEast11435,3683/16/12167,5743NoBaseballMobile6%38,899No ShipMall61Customer ServiceYes97%10$191,622 SouthEast114476,1035/11/12510,2152NoRunningMobile11%24,675No ShipMall22Customer ServiceYes99%30$258,440 SouthEast114520,4179/13/1142,2425YesBaseballMobile28%48,649ShipMall26Customer ServiceYes92%12$56,723 SouthEast114653,0313/30/1496,0815YesRunningMobile27%25,226ShipMall24Customer ServiceYes87%27$153,849 SouthEast114783,9856/17/09173,2434YesRunningMobile15%30,893ShipStand Alone26Customer ServiceYes93%29$42,800,900 SouthEast114855,2031/21/1424,0177NoBaseballMobile30%28,936ShipMall29Customer ServiceYes95%32$101,630 SouthEast11493,86111/11/10183,4693NoBaseballMobile3%18,294ShipMall25Customer ServiceYes90%10$87,766 SouthEast115021,2394/16/0983,9615NoBaseballMobile14%12,917ShipMall30Customer ServiceYes83%33$100,213 SouthEast115156,5807/21/14119,5985NoRunningMobile18%34,152ShipMall26Customer ServiceYes77%7$242,829 SouthEast115290,2263/6/1462,0341NyesRunningMobile22%47,556ShipMall38OperationsYes95%28$51,460 SouthEast115339,0709/2/14143,3431YesRunningMobile44%21,252ShipMall27OperationsYes75%31$84,578 SouthEast115449,99911/29/12141,4053NoRunningMobile65%41,046ShipMall29OperationsYes95%24$35,547 SouthEast115581,7857/4/0955,0035NoRunningMobile50%18,317ShipMall105OperationsNo85%20$126,576 SouthEast115660,3109/21/1246,8165NoRunningMobile38%35,711ShipMall29OperationsNo80%11$172,445 NorthEast115731,2037/8/13133,7291NoWorkOutMobile24%16,958ShipMall26OperationsYes103%11$94,344 NorthEast115877,84911/21/121210,0651NoWorkOutMobile60%23,617ShipMall29OperationsNo75%22$254,645 NorthEast100189,3497/28/13189,0201NoSoccerMobile10%19,720ShipMall44OperationsYes79%32$228,206 NorthEast100288,6321/15/1087,7053NoTennisMobile6%46,973ShipMall21MarketingNo79%21$194,937 NorthEast100361,5678/2/09196,6691YesBasketballMobile34%20,612ShipMall32Customer ServiceNo90%31$168,726 NorthEast100429,38411/8/11139,3842NoFootballMobile42%28,036ShipMall23Customer ServiceYes95%16$237,415 NorthEast10054,81112/20/0879,0612NoRunningMobile20%19,860ShipMall26Customer ServiceYes76%26$229,243 &f Page &p Instructions There are obvious ERRORS in the data which you must remove, or replace with proper (interpolated) data before performing an analysis. Some data may be redundant, some features may need to be added. Assignment: The data provides the explanatory and target variables to analyze various retail branches a of sporting goods chain around the US. You are to use this file to attempt to gain greater insights as to what potentially drives sales for stores. You are to transform this file so it can eventually be mined. You want to focus your analysis on retailers in the SouthEast region to better understand what drives their sales. Your job is to view the data and tell your data warehouser to adjust it in order to make it more appropriate for data mining. *Hint, you should end up with less columns and less rows for your final, adjusted file. You should note the adjustments made by the warehouser and submit an adjusted file with the steps on how you got there. In reality, you will be the data warehouser as you are required to make the necessary adjustments. One of the variables needs to be transformed above. It cannot be used in its current format but must be changed to a duration of time in weeks. Background Information: Variable definitions are: RegionRegion of where the store resides Store IDThe ID of a particular store PopulationThe total population within 20 miles of where the store resides Store OpeningThe day the store opened its doors for business. Sales StaffThe amount of store workers per 1000 square feet of the retail store Monthly TrafficThe average amount of shoppers that visit the store on a monthly basis (this is highly correlated with Sales). ReviewA customer's review of their store experience (1 - 5) 5 is good. AI SystemA cloud based AI system used by the store that enables them to organize products based on shoppers' behavior and facial recogntion. Product PurchasedThe product type that was purchased by a customer. Coupon ReceiveHow a particular customer retrieved a coupon that was emailed to them (either on a PC/laptop, or on a mobile device) Store AppThe percentage of customers that purchased using the store app. Avg Monthly FacebookThe average montly traffic that the store's facebook page receives. Ship
Answered 7 days AfterOct 10, 2022

Answer To: Part 1 - Sporting Goods Project for MGMT 635 (Data Mining for Managers)Three Sectional...

Mukesh answered on Oct 12 2022
55 Votes
SportingGoodsData
    Region    Store ID    Population    Store Opening    Sales Staff/1000 Sq ft    Monthly Traffic    Review    AI System    Product Purchased    Coupon Receive    App    Avg Monthy Facebook    Ship to Store    Store Location    Staff Age    Sales BackGround    Loyalty Card    % Sales Staff College    Parking Places    TotalSales
    NorthEast    1000    70,636    4/19/08    16    6,190    1    Yes    Football    Mobile    8%    18,160    No Ship    Stand Alone    30    Operations    No    75%    9    156607
    NorthEast    1001    4,777    11/23/14    19    1,677    3    Yes    Football    PC    9%    46,171    No Ship    Mall    22    Operations    No    90%    5    42428
    NorthEast    1002    101,537    11/8/13    9    10,439    2    No    Football    PC    48%    15,199    No Ship    Mall    25    Operations    No    97%    16    264107
    NorthEast    1003    87,932    11/13/08    12    3,
971    5    No    Soccer    PC    60%    35,540    No Ship    Stand Alone    32    Operations    Yes    92%    8    100466
    NorthEast    1004    27,742    6/24/13    2    2,879    1    No    Tennis    PC    25%    29,051    No Ship    Stand Alone    27    Operations    Yes    89%    9    72839
    NorthEast    1005    45,133    10/18/12    4    1,824    4    Yes    Tennis    PC    27%    9,102    No Ship    Stand Alone    22    Operations    No    95%    7    46147
    NorthEast    1006    65,292    12/25/08    11    8,263    4    Yes    Tennis    PC    19%    33,097    No Ship    Mall    28    Operations    Yes    78%    23    209054
    NorthEast    1008    36,797    1/6/13    18    3,811    2    No    WorkOut    Mobile    54%    22,417    Ship    Mall    26    Customer Service    Yes    76%    21    96418
    NorthEast    1009    17,622    9/4/14    7    1,793    2    No    WorkOut    Mobile    50%    18,839    Ship    Mall    22    Customer Service    No    99%    22    45363
    NorthEast    1010    30,252    7/31/14    19    8,002    3    No    WorkOut    Mobile    63%    13,368    No Ship    Mall    30    Marketing    No    88%    7    202451
    NorthEast    1011    34,659    12/26/10    20    8,625    4    No    WorkOut    PC    40%    16,425    No Ship    Mall    25    Marketing    No    94%    23    218213
    NorthEast    1012    22,389    8/28/14    8    8,765    3    Yes    WorkOut    PC    62%    36,748    No Ship    Mall    24    Marketing    No    100%    20    221755
    SouthEast    1013    62,684    7/13/12    20    8,202    4    Yes    WorkOut    PC    1%    44,506    Ship    Mall    22    Marketing    Yes    100%    24    207511
    SouthEast    1014    96,631    7/10/10    14    5,628    1    j    WorkOut    PC    50%    47,927    Ship    Stand Alone    27    Marketing    No    105%    'NA    142388
    SouthEast    1015    62,484    1/26/09    18    3,100    3    No    Biking    PC    18%    47,248    Ship    Mall    28    Marketing    Yes    84%    12    78430
    SouthEast    1016    40,108    12/27/12    14    3,729    1    Yes    Biking    PC    16%    '12,xxx    Ship    Stand Alone    25    Operations    Yes    95%    23    94344
    SouthEast    1017    45,589    6/23/08    4    4,225    4    No    Biking    Mobile    22%    28,169    Ship    Stand Alone    27    Operations    No    80%    22    106893
    SouthEast    1018    69,461    3/19/08    14    9,016    5    No    Biking    Mobile    39%    9,619    Ship    Stand Alone    29    Operations    No    78%    11    228105
    SouthEast    1019    18,647    11/16/12    6    4,343    5    No    Football    Mobile    37%    36,756    Ship    Mall    20    Operations    No    89%    32    109878
    SouthEast    1020    58,424    5/1/11    5    4,987    3    Yes    Biking    Mobile    52%    17,701    Ship    Mall    25    Operations    Yes    82%    17    126171
    SouthEast    1021    10,108    10/4/12    6    8,855    6    No    Football    PC    40%    36,597    Ship    Mall    24    Operations    Yes    85%    15    224032
    SouthEast    1022    46,229    2/17/14    9    2,260    4    No    Football    PC    35%    48,790    Ship    Mall    40    Operations    Yes    79%    9    57178
    SouthEast    1023    20,786    9/27/14    8    5,074    1    No    Soccer    PC    10%    41,381    No Ship    Mall    22    Operations    Yes    88%    22    128372
    SouthEast    1024    12,079    2/8/12    14    5,314    4    No    Soccer    PC    26%    1.xxxx    No Ship    Mall    25    Marketing    No    70%    15    134444
    SouthEast    1025    61,598    7/4/12    14    5,309    5    No    Soccer    PC    64%    49,976    No Ship    Mall    26    Marketing    No    65%    16    134318
    SouthEast    1026    34,970    1/12/09    16    3,114    5    No    Soccer    PC    31%    31,897    No Ship    Stand Alone    24    Operations    No    79%    26    78784
    SouthEast    1027    29,468    1/22/11    4    10,315    4    No    Soccer    Mobile    47%    24,234    No Ship    Stand Alone    55    Operations    No    100%    18    260970
    SouthEast    1028    42,745    6/21/09    2    7,196    2    No    Soccer    Mobile    39%    44,774    No Ship    Stand Alone    27    Operations    Yes    99%    6    182059
    SouthEast    1029    29,776    4/30/11    18    4,210    4    No    Soccer    Mobile    17%    41,382    No Ship    Stand Alone    28    Operations    Yes    83%    10    106513
    SouthEast    1030    68,304    6/16/09    12    10,009    2    No    Soccer    Mobile    63%    17,904    No Ship    Stand Alone    19    Operations    Yes    87%    33    253228
    SouthEast    1031    72,902    1/18/11    4    7,053    4    No    Soccer    Mobile    63%    34,176    No Ship    Mall    22    Marketing    Yes    94%    23    178441
    SouthEast    1032    70,954    11/29/08    9    5,914    3    No    Soccer    Mobile    45%    40,330    No Ship    Mall    24    Customer Service    Yes    98%    28    149624
    SouthEast    1033    52,637    10/5/14    10    1,328    1    Yes    Soccer    Mobile    9%    16,420    No Ship    Mall    19    Customer Service    Yes    84%    33    33598
    SouthEast    1034    43,199    4/27/11    4    9,006    2    Yes    Soccer    Mobile    15%    15,031    No Ship    Mall    22    Customer Service    Yes    87%    33    227852
    SouthEast    1035    48,716    1/28/13    4    4,131    2    Yes    Tennis    Mobile    56%    14,533    No Ship    Mall    27    Customer Service    Yes    97%    26    104514
    SouthEast    1036    63,830    10/24/10    5    9,466    2    No    Tennis    Mobile    52%    37,353    No Ship    Mall    34    Customer Service    Yes    81%    14    239490
    SouthEast    1037    95,657    5/8/10    18    8,459    3    No    Tennis    PC    7%    43,471    Ship    Stand Alone    23    Customer Service    No    81%    35    214013
    NorthEast    1038    62,839    6/20/11    15    3,932    1    No    Running    PC    43%    28,204    Ship    Mall    22    Customer Service    Yes    92%    13    99480
    NorthEast    1039    95,713    6/27/10    2    2,137    3    No    Running    PC    13%    35,919    Ship    Mall    25    Marketing    No    90%    32    54066
    NorthEast    1040    101,785    7/12/08    17    7,072    4    No    Running    PC    24%    36,329    Ship    Mall    25    Marketing    No    92%    26    178922
    NorthEast    1041    50,007    6/3/14    15    10,463    4    Yes    Tennis    PC    9%    34,653    Ship    Mall    28    Marketing    Yes    78%    10    264714
    NorthEast    1042    22,054    2/5/13    6    9,203    5    No    Soccer    PC    16%    32,177    Ship    Mall    25    Marketing    No    85%    22    232836
    NorthEast    1043    49,528    5/29/10    14    5,399    1    No    Soccer    Mobile    21%    26,334    Ship    Mall    24    Marketing    No    103%    14    136595
    NorthEast    1044    41,458    8/31/11    20    1,424    2    No    Soccer    Mobile    65%    24,831    Ship    Mall    29    Marketing    No    80%    33    36027
    NorthEast    1045    52,953    5/17/09    8    9,501    4    No    Running    Mobile    13%    37,331    Ship    Mall    23    Operations    No    83%    13    240375
    NorthEast    1046    87,410    7/5/13    14    4,795    1    No    Running    Mobile    40%    49,373    Ship    Mall    23    Operations    No    83%    35    121314
    NorthEast    1047    74,830    5/10/13    3    6,167    5    No    Running    PC    36%    48,839    Ship    Stand Alone    43    Operations    No    97%    17    156025
    NorthEast    1048    93,223    10/6/11    18    3,344    1    No    Running    PC    13%    26,896    No Ship    Mall    21    Operations    No    85%    18    84603
    NorthEast    1049    63,404    4/10/12    15    7,925    1    No    Running    PC    27%    45,815    No Ship    Mall    22    Operations    No    94%    21    200503
    NorthEast    1050    91,057    6/15/14    5    4,276    5    No    Running    PC    63%    25,020    No Ship    Stand Alone    23    Operations    No    104%    13    108183
    NorthEast    1051    51,019    9/19/09    2    9,942    2    Yes    WorkOut    PC    47%    13,885    No Ship    Mall    23    Operations    No    91%    17    251533
    NorthEast    1052    45,551    3/13/13    11    8,891    3    No    Running    PC    6%    11,314    No Ship    Mall    25    Operations    No    100%    34    224942
    SouthEast    1053    5,441    10/22/14    17    9,057    4    Yes    Running    PC    37%    23,209    No Ship    Mall    22    Marketing    No    80%    35    229142
    SouthEast    1054    5,019    6/1/13    3    3,442    4    No    WorkOut    Mobile    42%    41,537    No Ship    Mall    28    Marketing    No    89%    11    87083
    SouthEast    1055    93,730    12/26/09    12    5,771    4    No    WorkOut    Mobile    27%    49,872    No Ship    Mall    30    Operations    No    88%    26    146006
    SouthEast    1056    58,426    2/25/14    9    2,502    1    Yes    WorkOut    Mobile    22%    29,010    No Ship    Mall    20    Operations    No    93%    5    63301
    SouthEast    1057    70,636    4/19/08    9    6,190    2    No    Football    Mobile    60%    18,160    No...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here