The demand for toys produced by the Miki Manufacturing Company has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop simple linear regression forecast and answer the following questions.
Simple Linear Regression Forecast
Period Actual Demand Forecast Formulas
1 1,600 #N/A
2 2,000 #N/A
3 1,800 #N/A
4 1,200 #N/A
5 2,300 #N/A
6 3,600 #N/A
7 3,300 #N/A
8 3,200 #N/A
9 4,000 #N/A
10 4,900 #N/A
11 4,500 #N/A
12 4,400 #N/A
13 #N/A
Intercept #N/A
Slope #N/A
1. What is the trend line? Round your answers to two decimal places. Do not round intermediate calculations.
2. Calculate the linear trend forecast for the periods from 1 to 13. Round your answers to the nearest whole number. Use unrounded intercept and slope values.
Period Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13