Answer To: 1. IntroductionStructure idea: 1 paragraph, with clear focus – e.g., approx. 150 words...
Robert answered on Oct 17 2022
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
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 Total Sales
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 $156,607
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 $42,428
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 $264,107
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 $100,466
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 $72,839
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 $46,147
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 $209,054
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 $96,418
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 $45,363
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 $202,451
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 $218,213
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 $221,755
SouthEast 1013 62,684 7/13/12 20 8,202 4 Yes WorkOut PC 1% 44,506 Ship Mall 22 Marketing Yes 100% 24 $207,511
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 $142,388
SouthEast 1015 62,484 1/26/09 18 3,100 3 No Biking PC 18% 47,248 Ship Mall 28 Marketing Yes 84% 12 $78,430
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 $94,344
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 $106,893
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 $228,105
SouthEast 1019 18,647 11/16/12 6 4,343 5 No Football Mobile 37% 36,756 Ship Mall 20 Operations No 89% 32 $109,878
SouthEast 1020 58,424 5/1/11 5 4,987 3 Yes Biking Mobile 52% 17,701 Ship Mall 25 Operations Yes 82% 17 $126,171
SouthEast 1021 10,108 10/4/12 6 8,855 6 No Football PC 40% 36,597 Ship Mall 24 Operations Yes 85% 15 $224,032
SouthEast 1022 46,229 2/17/14 9 2,260 4 No Football PC 35% 48,790 Ship Mall 40 Operations Yes 79% 9 $57,178
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 $128,372
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 $134,444
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 $134,318
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 $78,784
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 $260,970
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 $182,059
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 $106,513
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 $253,228
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 $178,441
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 $149,624
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 $33,598
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 $227,852
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 $104,514
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 $239,490
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 $214,013
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 $99,480
NorthEast 1039 95,713 6/27/10 2 2,137 3 No Running PC 13% 35,919 Ship Mall 25 Marketing No 90% 32 $54,066
NorthEast 1040 101,785 7/12/08 17 7,072 4 No Running PC 24% 36,329 Ship Mall 25 Marketing No 92% 26 $178,922
NorthEast 1041 50,007 6/3/14 15 10,463 4 Yes Tennis PC 9% 34,653 Ship Mall 28 Marketing Yes 78% 10 $264,714
NorthEast 1042 22,054 2/5/13 6 9,203 5 No Soccer PC 16% 32,177 Ship Mall 25 Marketing No 85% 22 $232,836
NorthEast 1043 49,528 5/29/10 14 5,399 1 No Soccer Mobile 21% 26,334 Ship Mall 24 Marketing No 103% 14 $136,595
NorthEast 1044 41,458 8/31/11 20 1,424 2 No Soccer Mobile 65% 24,831 Ship Mall 29 Marketing No 80% 33 $36,027
NorthEast 1045 52,953 5/17/09 8 9,501 4 No Running Mobile 13% 37,331 Ship Mall 23 Operations No 83% 13 $240,375
NorthEast 1046 87,410 7/5/13 14 4,795 1 No Running Mobile 40% 49,373 Ship Mall 23 Operations No 83% 35 $121,314
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 $156,025
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 $84,603
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 $200,503
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 $108,183
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 $251,533
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 $224,942
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 $229,142
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 $87,083
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 $146,006
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 $63,301
SouthEast 1057 70,636 4/19/08 9 6,190 2 No Football Mobile 60% 18,160 No Ship Stand Alone 27 Operations No 75% 9 $156,607
SouthEast 1058 4,777 11/23/14 11 1,677 4 No Football PC 1% 46,171 No Ship Mall 22 Operations No 90% 5 $42,428
SouthEast 1059 101,537 11/8/13 13 10,439 3 No Football PC 8% 15,199 No Ship Mall 25 Operations No 97% 16 $264,107
SouthEast 1060 87,932 11/13/08 2 3,971 3 No Soccer PC 22% 35,540 No Ship Stand Alone 29 Operations Yes 92% 8 $100,466
SouthEast 1061 27,742 6/24/13 4 2,879 3 No Tennis PC 53% 29,051 No Ship Stand Alone 27 Operations Yes 89% 9 $72,839
SouthEast 1062 45,133 10/18/12 14 1,824 2 No Tennis PC 46% 9,102 No Ship Stand Alone 22 Operations No 95% 7 $46,147
SouthEast 1063 65,292 12/25/08 18 8,263 3 j Tennis PC 37% 33,097 No Ship Mall 28 Operations Yes 78% 23 $209,054
SouthEast 1064 76,267 6/6/11 4 9,839 1 No Tennis Mobile 42% 27,848 Ship Mall 18 Marketing No 82% 18 $248,927
SouthEast 1065 86,726 12/7/09 8 7,862 3 No WorkOut Mobile 52% 46,206 Ship Mall 28 Marketing No 87% 20 $198,909
SouthEast 1066 27,906 10/7/14 12 6,741 4 No WorkOut Mobile 33% 21,795 No Ship Mall 26 Operations Yes 82% 29 $170,547
SouthEast 1067 58,056 11/6/14 5 3,038 4 No WorkOut Mobile 10% 28,062 No Ship Stand Alone 21 Operations Yes 96% 22 $76,861
SouthEast 1068 25,952 8/17/14 15 4,756 1 No WorkOut Mobile 34% 11,824 No Ship Stand Alone 29 Operations Yes 79% 8 $120,327
WestCoast 1069 27,731 12/20/09 7 6,533 1 No WorkOut Mobile 22% 41,066 No Ship Mall 23 Operations Yes 104% 26 $165,285
WestCoast 1070 59,171 9/15/11 9 5,086 2 No WorkOut Mobile 6% 49,897 No Ship Stand Alone 26 Operations Yes 85% 26 $128,676
WestCoast 1071 40,315 1/12/14 5 6,701 1 No WorkOut Mobile 15% 38,195 No Ship Mall 26 Marketing No 86% 7 $169,535
WestCoast 1072 26,324 3/7/08 18 7,804 3 No Running Mobile 52% 38,943 No Ship Mall 24 Customer Service No 88% 21 $197,441
WestCoast 1073 78,065 3/25/14 12 3,185 2 No Running Mobile 60% 31,618 No Ship Stand Alone 30 Customer Service No 84% 7 $80,581
WestCoast 1074 74,754 4/7/12 12 6,710 3 No Running PC 31% 26,998 Ship Stand Alone 29 Customer Service No 99% 5 $169,763
WestCoast 1075 24,654 7/29/11 4 8,989 1 No Running PC 6% 22,476 Ship Stand Alone 23 Customer Service Yes 91% 8 $227,422
WestCoast 1076 25,582 11/14/11 4 1,667 5 No Soccer PC 8% 26,528 Ship Mall 25 Customer Service No 95% 16 $42,175
WestCoast 1077 15,289 11/3/12 17 9,486 1 No Soccer PC 25% 30,319 No Ship Mall 25 Customer Service No 82% 28 $239,996
WestCoast 1078 19,150 4/6/09 10 9,129 1 No Soccer PC 14% 30,404 No Ship Mall 44 Customer Service Yes 93% 14 $230,964
WestCoast 1079 39,403 10/3/14 6 6,152 1 Yes Soccer PC 9% 11,349 ShpNoShip Mall 25 Customer Service Yes 79% 30 $155,646
WestCoast 1080 29,351 6/28/10 15 4,439 3 Yes Soccer Mobile 0% 37,483 No...