The number of properties newly listed with a real estate age

The number of properties newly listed with a real estate agency in each quarter over the last four years s given below. Assume the time series has seasonality without trend. a. Develop the optimization model that finds the estimated regression equation that minimize the sum of squared error. b. Solve for the estimated regression equation. c. Forecast the four quarters of Year 5. *please solve n excel

Solution

optumise solution