” MKAN1-UC 5103程序 辅导、 写作Analytics程序Marketing Analytics Spring 2020 Final ExamMKAN1-UC 5103 Marketing Analytics Spring 2020 Final ExamInstructions (total 3 points): Develop the SAS syntax for each question in both Part I and Part II below andsave all syntax in ONE SAS file called YourLastName_MA_Final_ExamYou will need to save your Final Exam as a PDF File and submit that file. To saveas PDF, you can use the menu for Print and instead of a printer you will selectSave as PDF (cmd and P, on a Mac then select from bottom left, or Ctrl and Pon Windows then Destination Save as PDF).Please inspect your PDF file before you submit it to ensure that no detail is cutoff (this will reduce your points). If any detail does not display on the PDF, youmay need to resize and add extra lines accordingly. Submit that file under this Final Exam Assignment as your answer to Final Exam Start your SAS file with this header by using SAS comments syntax:o Course Name – Semester Yearo Your nameo Final Exam – date you complete the assignment Start your answer to each question below with the Question # by using SAScomments syntax Keep your syntax in a clear format Please copy and paste the syntax generated into your SAS file even if you usepoint-and-click methods/tasksQuestions (total 107 points):Part I sales csv dataset1. (3 points) (1) Import sales.csv file into a SAS data set named sales in one ofyour libraries. (2) Use proper syntax statements to rename the name of theQUANTITYORDERED column in the sales data set into quantity and thePRICEEACH column into price. (3) Use proper syntax statements to create anew column in the data set called revenue where revenue = quantity * price.2. (6 points) Based on Question 1, (1) create a Bar Chart showing the total numberof revenue the store earned by year id. (2) Use SAS comments syntax to describethe information that you see from RESULTS (explain the chart).3. (6 points) Based on Question 1, (1) create a Line Chart showing the averagequantity the store sold by month of the year. (2) Use SAS comments syntax todescribe the information that you see from RESULTS (explain the chart).4. (6 points) Based on Question 1, (1) create a Pie Chart showing the total quantityby deal size. (2) Use SAS comments syntax to describe the information that yousee from RESULTS (explain the chart).MKAN1-UC 5103程序 辅导、 写作Analytics程序、Java，Python，c/c++程序语言作业 写作Marketing Analytics Spring 2020 Final Exam5. (6 points) Based on Question 1, (1) create a Mosaic Plot where y-axis is year idand x-axis is product line. (2) Use SAS comments syntax to describe theinformation that you see from RESULTS (explain the chart).6. (6 points) Based on Question 1, (1) Create a Box Plot showing the revenue thestore earned by product line. Also, in Settings APPEARANCE, add a proper titlefor the chart. (2) Use SAS comments syntax to describe the information that yousee from RESULTS (explain the plot).7. (9 points) Based on Question 1, (1) use point and click Distribution Analysis Taskunder Statistics to analyze the distribution of the revenue variable (make surein OPTIONS, check Histogram and goodness-of-fit tests, and Normal quantilequantileplot). (2) Use SAS comments syntax to answer the questions below:a. From the histogram, what you can conclude?b. From goodness-of-fit tests, what is the null hypothesis? Based on the pvalue,do we reject the null hypothesis? Then, what can we concludefrom the test?c. What does Q-Q plot tell us?8. (9 points) Based on Question 1, (1) use point and click One-sample T Test Taskunder Statistics to test if the mean of the revenue variable is equal to 3,000. (2)Use SAS comments syntax to answer the questions below:a. What is the assumption of one-sample t-test? Does the target variablerevenue meet the assumption? How do you know?b. What is the null hypothesis for this t-test? Do we reject the nullhypothesis? Why or why not? What will you conclude?9. (10 points) Based on Question 1, (1) use point and click One-Way ANOVA Taskunder Linear Models to test if the means of the revenue in different product linegroups are the same or not. (2) Use SAS comments syntax to answer thequestions below:a. What are the two assumptions of One-Way ANOVA? Choose oneassumption to answer: Does the target variable revenue meet theassumption you choose? How do you know?b. What is the null hypothesis for this One-Way ANOVA test? Do we rejectthe null hypothesis? Why or why not? What will you conclude?c. List three specific pairs of product line groups where the mean revenuesare significantly different (significance level = 0.05)? How do you knowthey have significant different means in revenue?3Marketing Analytics Spring 2020 Final ExamPart II skincancer csv datasetDataset DescriptionState State Name in USLat LatitudeMort Skincancer mortality casesOcean If it is near Ocean or not — Yes 1; No 0Long Longitude1. (2 points) Import skincancer.csv file into a SAS data set named skincancer inone of your libraries.2. (6 points) Based On Question 1, (1) create a Scatter Plot showing the relationshipbetween latitude and skincancer mortality cases. (2) Use SAS comments syntaxto describe the information that you see from RESULTS (explain the plot).3. (9 points) Based on Question 1, (1) use point and click Correlation Analysis Taskunder Statistics to explore the linear relationship between mortality, latitude andlongitude (Make sure to display p-values under OPTIONS-Statistics). (2) Use SAScomments syntax to answer the questions below:a. What are the relationships between each pair of the three variables?How do you know?b. Which correlation amongst the three variables is/are significant? How doyou know?4. (10 points) Based on Question 1, (1) use point and click Two-sample T Test Taskunder Statistics to test if the means of the mortality cases near ocean and faraway from ocean are the same or not. (2) Use SAS comments syntax to answerthe questions below:a. What are the two assumptions of Two-sample t-test? Does the targetvariable meet both assumptions OR not? How do you know?b. What is the null hypothesis for this Two-sample t-test? Do we reject thenull hypothesis? Why or why not? What will you conclude?c. Is there any limitation in this two-sample t-test? If yes, please explain. Ifno, why not?5. (10 points) Based on Question 1, (1) create a Linear Regression Model to predictthe mortality cases by using latitude and longitude variables. (2) Use SAScomments syntax to answer The questions below:a. Explain the meanings of different p-values in the results. What shall weconclude about the different variables and the model?b. What is the value of R Square? What does it mean?4Marketing Analytics Spring 2020 Final Exam6. (9 points) Based on Question 1, (1) create a Linear Regression Model to predictthe mortality cases by using latitude and the interaction effect between oceanand latitude. (2) Use SAS comments syntax to answer the questions below:a. Explain the meanings of different p-values in the results. What shall weconclude about the different variables and the model?b. Is this model better than the model in Question 5 above? How do youknow?Note: This is a 110-point Final Exam. You need to submit your answers by the due time,answer satisfactorily all points in each question and follow these instructionsfully. Late submissions will receive automatic 0 points. This is an individual take-home Final Exam. Any teamwork found will receiveautomatic 0 points.如有需要，请加QQ：99515681 或邮箱：99515681@qq.com
“
添加老师微信回复‘’官网 辅导‘’获取专业老师帮助，或点击联系老师1对1在线指导。
