**THIS ASSIGNMENT IS DUE BEFORE 12Midnight TONIGHT**The manager of a catering company is using the number of people in the party to predict the cost of the drinks that are required for the event. The following are the data for 12 recently catered events:EventNumber of PeopleCost of Drinks112242143031536418385206561644714368133091839101976112080122285Complete the calculations below using this data. Show all of your work and clearly label each of your calculations. a.Provide a scatterplotb.Calculate a linear regressionc.Calculate the residualsd.Calculate the correlation between the two variablese.Calculate the mean median and standard deviation of the number of people and cost of drinks For additional assistance with these calculations reference the Recommended Materials for Week Four.2.Problem Two You are a real estate agent and you are trying to predict home prices for your clients that want to list their house for sale. You have a very small city without much data. You will need to use the data that you have available for the past year on homes that have been sold.BedroomsSquare FootageBathroomsPrice115002125000318004148000540005250000321003160000423005240000538004245000219001155000 Complete the calculations below using this data. Show all of your work and clearly label each of your calculations. Conduct a multiple regression analysis to predict home prices. In your analysis complete the following:a.Calculate the multiple regression analysis and report your data.b.Determine the list price for your client s home if it has three bedrooms three bathrooms and 1900 square footage. Provide your analysis and show all of your calculations.