Question: A company wants to develop a simple linear regression model for one of its products. Use the following 12 periods of historical data to develop
A company wants to develop a simple linear regression model for one of its products. Use the following 12 periods of historical data to develop the regression equation and use it to forecast the next three periods.
Period (X) At (Y) 1 204 2 187 3 198 4 166 5 173 6 151 7 171 8 160 9 137 10 141 11 116 12 110
Click the icon to view the historical data for the previous 12 periods.
The simple linear regression line is Ft=[ ]+[ ] xi.
(Enter your responses rounded to two decimal places and include a minus sign if necessary.)Find the forecasts for periods 13-15 based on the simple linear regression and fill in the table below (enter your responses rounded to two decimal places).
| Period (x) | Forecast (Ft) |
| 13 |
| 14 |
| 15 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
