The number of properties newly listed with real estate agency in each quarter over the last four years is given below. Assume the time series has seasonality without trend.
|
Year
|
|
Quarter
|
1
|
2
|
3
|
4
|
|
1
|
73
|
81
|
76
|
77
|
|
2
|
89
|
87
|
91
|
88
|
|
3
|
123
|
115
|
108
|
120
|
|
4
|
92
|
95
|
87
|
97
|
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.