1.Question 1Download the spreadsheet "Chicagocrimedata (Week 4 quiz).xlsx" below. The file contains statistics on daily crime data in Chicago from 2011 till 2022. It contains the date, average temperatures (in Fahrenheit) and various kinds of offences.Use the data in the "Week 4 quiz - get data" worksheet for the remainder of the assignment.Chicagocrimedata (Week 4 quiz)XLSX FileFill in the columns "assault", and "temp_average" in the worksheet "Week 4 quiz - get data" using the VLOOKUP formula. What is the value in cell C150?

Question 2Scenario 1 continuedYou’ve downloaded the data from your company database and imported it into a spreadsheet. IMPORTANT: To answer questions using this dataset for the scenario, click the link below and select the “Use Template” button before answering the questions.Link to template: Course Challenge - Scenario 1OR If you don’t have a Google account, you can download the template directly from the attachment below.Course Challenge Dataset - Scenario 1 - Scenario 1_ Pharmacy Data - Part 1CSV FileNow, it’s time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice that information about Splashtastic is missing for Store Number 15 in Row 16. Which of the following would be an appropriate response?1 pointSort the spreadsheet so the row with missing data is at the bottom.Ask a colleague on your team how they've handled similar issues in the past.Delete the row with the missing data point.Replace the row with the average values of the other data points.

Question 3Which of the following statements accurately describe spreadsheet attributes and observations? Select all that apply.

Question 1 In the dataset “crimerate.sas7bdat”, the monthly number of registered crime cases in country A from January 1994 to December 2014 are recorded. The dataset contains merely two variables: “Month”, the time period in which the data were observed, and “CrimeRate”, the number of crime cases observed during the corresponding period. (a) Construct the following plots in SAS for the “CrimeRate” time series: i) Series line plot ii) Autocorrelation plot iii) Trend-cycle component plot iv) Seasonal-irregular component plot v) Seasonally adjusted plot Provide ONE SAS program for the creation of ALL the 5 plots. Copy and paste your code as text (NOT screenshot) into your report. No comments and explanations are required here. The plots should be pasted as screenshot images into your report. They should be placed as answers for part (a) and not in the appendix. The height of the images must not be more than 7cm. You can use the “Size and Position” properties in Word to adjust the size of your images. (10 marks)

What type of data is contained in the following spreadsheet?EmployeeMonthSalesT. Marks1/22$30,928T. Marks2/22$26,989T. Marks3/22$28,760W. Bungee1/22$45,002W. Bungee2/22$39,726W. Bungee3/22$36,0111 分UnstructuredLongTallWide

write 2-3 sentences (40-60 words) in response to each of the following questions:What are some other kinds of data you could combine using CONCAT or CONCATENATE?What happens if a data analyst tries to work with dates or names that haven’t been combined with CONCAT or CONCATENATE?