Please show the steps used to find the answer using Excel st

Please show the steps used to find the answer using Excel step by Step. and provide the answers requested in the table

4. (12pts) The number of properties newly listed with a real estate agency in each quarter over the last four years is given. Develop a multiple regression model to predict the number of listings both trend and seasonal components), using dummy variables to incorporate the seasonal factors into the model Year Quarter 2 4 73 81 7677 89 87 8592 123 115 108 131 92 93 87 101 3 4 Write down the estimated regression equation. a. b. Comment on the accuracy of this model . In which quarter the number of newly listed properties seems to be the highest? Explain d. Use this model to predict the number of listings each quarter of the next year. uarters 4 Forecasts

Solution

Since the minium time is 3 days for problem 3rd by jennifer, so problem 3 goes to jennifer,

The next minimium time is 4days for problem 4th by Jennifer so this problem is assigned to her as well.

Problem 1 goes to Harry has he takes 6 days only and probelm 2 goes to Carl who also takes 6 days to solve .

hence the total days to solve 3+4+6+6=19 days