Do My Homework / Homework Help Answers / SAS Homework Help / Project using SAS for analytics course

Project using SAS for analytics course

Need help with this question or any other SAS assignment help task?

Data is provided. Need to complete project using SAS, with a written explanation to questions and with graphs, bars etc. Provided graphic representation and reasoning.
Additional Instructions:
Franklin University MATH 601 Introduction to Analytics PROJECT FOR MODULE 4 (DATA MINING AND DATA ETHICS) [75 Points in Total] TERRITORY OPTIMIZATION You are a regional sales director for Argentis, a growing financial services firm that specializes in providing investment services (annuities, managing stock portfolios, trust services) for higher net worth clients. Until recently, Argentis has only offered its services online, and you have been asked to help plan its office locations in central Ohio. Your regional president has asked you to put together a plan that (1) places eight agent offices throughout central Ohio and (2) minimizes the amount of time your Top 100 highest net worth clients in the area will have to travel to get to their local agent’s office. You have been given a file that contains the latitude and longitude of these clients’ addresses.[footnoteRef:1] [1: This data file has been randomly generated, so any specific locations contained in the data are purely coincidental.] 1. (12 Points) What analytical process will you use to identify the new agent’s locations? Assuming that your regional president and the agents you will be hiring are unfamiliar with this process, how would you describe it to them? 2. (14 Points) Read your geographic data into SAS Studio and run the appropriate algorithm on your data. Paste in the output of your results below. Be sure to include the latitude and longitude locations of the eight new office locations and how many of the Top 100 clients will be served by each location. 3. (14 Points) Create a map of central Ohio that shows the location of the eight new agency offices. (You can use whatever software you like. Many free, professional tools are available online: Google Maps, Tableau, Mapline.com, etc.) Write a short paragraph that you might include in a presentation to your colleagues explaining how these locations meet your regional president’s requirements. 4. (14 Points) Create appropriate data visualizations to show the distribution of clients’ marital status and investment potential scores for the clients assigned to each agency location.[footnoteRef:2] [2: Marital status codes: S = single, never married; M = married; D = divorced; W = widowed. Investment potential: a model for Top100 clients (based on demographics) that assigns a 1-5 score based on their potential for having a large amount of investment capital. 1= lowest potential and 5 = highest potential.] Do any agency locations seem to have an unfair advantage or disadvantage? 5. (21 Points) Several months after your regional president has approved your plan, she pulls you aside and tells you that unfortunately the company has decided to only open seven new central Ohio locations instead of eight. a. Run your analysis again but now with only seven locations. b. Provide a map of the revised agency locations. c. Write a brief paragraph summarizing how the locations have changed. (You do not need to repeat the data visualizations from question 4.) By reducing the number of agency locations by one, how much has the average client-to-agency distance increased? 1 070919
Sheet1 n Latitude Longitude Marital Status Investment Potential 1 39.87618 -82.89595 M 4 2 40.08591 -82.84189 S 4 3 39.91746 -83.12095 M 1 4 40.08159 -82.96413 M 2 5 39.95497 -83.04009 D 5 6 39.98965 -82.96658 M 3 7 39.87517 -83.11875 S 4 8 40.00581 -82.84216 D 5 9 39.95633 -82.8722 M 1 10 39.96968 -82.9247 M 2 11 39.90172 -82.93375 D 1 12 40.09524 -83.06839 M 4 13 40.08479 -83.07914 W 4 14 39.86494 -83.13328 D 1 15 40.00434 -83.0208 M 4 16 40.04489 -82.99182 M 4 17 39.99946 -83.0986 M 4 18 39.93985 -83.109 D 3 19 39.97369 -82.8935 D 4 20 39.87024 -83.08347 D 1 21 39.88846 -82.87281 M 3 22 39.86531 -82.97152 M 4 23 39.99381 -82.89697 M 4 24 40.10505 -82.91514 W 2 25 39.98953 -82.96227 M 2 26 40.13075 -83.15259 S 4 27 39.87635 -83.04615 D 4 28 39.92907 -82.92144 S 2 29 39.93304 -83.0742 M 4 30 39.92268 -82.89903 S 3 31 40.11016 -83.04096 M 4 32 40.08769 -82.8705 D 3 33 39.91438 -82.95523 M 3 34 39.92153 -82.98962 D 3 35 40.03038 -82.98688 M 1 36 39.87144 -83.17532 S 1 37 39.86564 -82.95318 M 4 38 39.86643 -82.84585 M 3 39 40.12602 -83.16729 M 1 40 39.88649 -83.04227 S 3 41 40.12306 -83.1498 D 2 42 39.96306 -83.05204 M 1 43 39.88549 -83.07516 M 3 44 40.11175 -82.92053 W 2 45 40.11841 -83.03067 M 1 46 40.10855 -82.85197 M 5 47 40.00289 -83.10674 D 3 48 39.96465 -82.96027 W 1 49 40.04965 -83.10016 M 4 50 39.87551 -82.87212 M 2 51 40.08035 -82.8484 M 2 52 40.06019 -83.051 S 4 53 40.07398 -82.97807 D 3 54 39.86618 -83.04106 M 4 55 40.08837 -82.90549 M 4 56 40.10237 -83.00495 M 5 57 40.039 -82.95285 M 4 58 39.9873 -83.04525 M 4 59 39.90202 -83.00776 M 4 60 40.06626 -83.13414 M 3 61 39.94382 -83.01705 M 4 62 39.98778 -83.01866 D 2 63 39.97338 -82.87979 S 5 64 40.08725 -83.14706 S 4 65 40.05964 -82.87456 M 2 66 40.0419 -83.09042 W 3 67 40.04746 -82.88121 M 3 68 40.08564 -82.89115 M 2 69 40.07644 -83.13381 M 3 70 40.08051 -82.96976 M 4 71 39.86862 -82.94011 D 2 72 39.87582 -83.13321 M 2 73 40.04857 -82.86154 M 5 74 40.01068 -82.97298 M 2 75 39.86433 -82.99267 M 4 76 39.96142 -83.09677 M 4 77 40.00453 -83.1353 D 2 78 39.86832 -83.01403 M 3 79 40.11194 -83.06266 M 4 80 40.1012 -83.02753 M 2 81 40.0686 -83.00893 D 2 82 40.10301 -83.10518 M 3 83 40.12629 -82.9439 M 2 84 40.03578 -83.1369 M 2 85 39.88941 -83.13939 M 1 86 40.07601 -82.9629 M 2 87 40.0045 -82.8628 S 2 88 40.02071 -82.8546 M 2 89 39.88821 -83.15133 M 2 90 40.10962 -83.16488 D 1 91 40.0835 -83.14138 M 2 92 39.97064 -82.90881 M 2 93 39.86888 -82.8406 M 3 94 40.134 -83.16805 D 2 95 40.08509 -83.03387 D 4 96 40.09857 -82.98574 D 1 97 39.92072 -82.92119 M 5 98 40.02979 -83.11567 M 3 99 40.00811 -82.9611 D 3 100 40.02 -83.12815 D 2
There are no answers to this question.
Login to buy an answer or post yours. You can also vote on other others

Get Help With a similar task to - Project using SAS for analytics course

Related Questions

Similar orders to Project using SAS for analytics course
Popular Services
Tutlance Experts offer help in a wide range of topics. Here are some of our top services: