Data ManipulationThe purpose of this assignment is to use spreadsheet capabilities to perform data manipulation and to explain the process used in the handling of the data.For this assignment, you will use the "Claims" dataset. In the dataset, the claims data for n = 608 people are recorded. The data derive from a random sample of females diagnosed with ischemic heart disease over 24 months (see Exercise 7.27 in the textbook).Instead of using urgent care centers, some people rely on the Emergency Room (ER) to address most, if not all, of their medical needs. In fact, someone who has three or more ER visits within 24 months is considered a high ER user. Complete the steps below to execute this assignment. Using the dataset and Excel, create a new column titled "High_ER_User" with "Yes" if three or more ER visits; otherwise "No." Duration is measured in days, but 30-day intervals are more appropriate for most reporting purposes. Using Excel, create a new column titled "Duration_Months" by converting the duration into 30-day intervals. Many times complications and comorbidities are rare; therefore, these two negative events are summed together. Using Excel, create a new column titled "Comps_Comorbs" by adding complications with comorbidities. Many times age is grouped in 10-year intervals. Using Excel's VLOOKUP function, create a new column titled "Age_Group" with grouped ages of "21-30 yrs," "31-40 yrs," and so on for 10-year intervals. The last age group would be "61-70 yrs." Use a tab titled "Age_Groups" for this task.Next you will create a pivot table with the data and execute the following (refer to the examples in the resource "Data Manipulation Screenshots"). Use "High_ER_User" as a filter to obtain two filtered views of the pivot table. Summarize the data to get counts of claims, sum of claims and months, and average of procedures, prescribed drugs, ER visits, and complications/comorbidities. Add a calculated field titled "Claims PM" to the pivot table. This calculated field is the sum of claims divided by the sum of duration months and measures the average claim amount per month (PM).APA format is not required, but solid academic writing is expected.This assignment uses a grading rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.You are not required to submit this assignment to LopesWrite.

*** Shouldn't take too long as it can be solved with some excel formulas and brief explanation of answers + definition of concepts would be required Questions: For each investment class in Table 3, assume that future returns are normally distributed with the population mean and standard deviation as given. Answer the next 5 questions Tutorial video for excel formula: https://www.viddler.com/embed/ebd96754 Based on this assumption: 1)For each investment class, find the probability of a return that is less than zero (that is, find the probability of a loss). Is your answer reasonable for all investment classes? Explain.  2)For each investment class, find the probability of a return that is:  Greater than 5%. Greater than 10%.  Greater than 20%.  Greater than 50%.  Fixed Annuities Cash Equivalents US Treasury Bonds US Investment-grade Corporate Bonds Non US Corporate Bonds Domestic Large Cap Stocks International Equities Domestic Mid Cap Stocks Domestic Small Cap Stocks P(x>5%) P(x>10%) P(x>20%) P(x>50%) 3)For which investment classes is the probability of the return greater than 50% is essentially zero? For which investment classes is the probability of such a return greater than 1 percent? Greater than 5%?  4)For which investment classes is the probability of loss essentially zero?  5)For which investment classes is the probability of loss greater than 1%? Greater than 10%? Greater than 20%? Table 3 Data on Rate of Return of Investment in Securities Edit