HOMEWORK 1There are four (4) problems in this homework.

HOMEWORK 1There are four (4) problems in this homework. In order for you to receive full credit, you must answer the questions thoroughly. For problems2, 3and 4, perform the appropriate analyses and answer each question thoroughly as specified in the problem.This homework assignment contributes to 3% of the course grade.SUBMISSION REQUIREMENTS•Create a new MS Word file called HW1LastnameFirstname(e.g. HW1NewbyThuyuyen). Do not use the actual word “LastnameFirstname” as the name of your file. •Answer questions in each problem in the order in which they are given.•For an example on how to structure youranswers, see “Solutions to Practice data file: AmusementPark Writeup” file posted on the course website in Week 3.•Save and submit the file to Homework 1 submission link on Titanium. •You are also required to submit three(3) output files for problems 2, 3and 4which will contain the analyses that you performed to answer the questions in the problems. If you are using SPSS, submit the output file *.spv only. Problem 1:Read the Application Case 1.4: Analyzing Athletic Injuries, in your textbook, page 26. Answer the following questions?1.What types of analytics are applied in the injury analysis?2.How do visualizations aid in understanding the data and delivering insights into the data?3.What is a classification problem?4.What can be derived by performing sequence analysis?Problem 2:Johnson’s Corporation is in the process of reviewing its sales between January 2012 and March 2013. The sales data isprovided in a text file called HW1 Pacific Region.txt. You are to convert the data to Excel and construct PivotTable(s) to answer the following questions. 1.What are the total number of orders from each state? Provide both values and an appropriate chart for this question.2.What are the average total sales(January 2012 throughMarch 2013)from each state?Provide both values and an appropriate chart for this question.3.Show the average number of orders from each city, by thestateof Alaska(Hint:use the filter option for the State/Prov).Note: You will need to cleanup your data before you can use them in the PivotTable.