Question

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

Answer 1

attached below is the required solution

Step-by-step explanation:

1) Determine the trend line

The trendline ( Y ) = 319.58x + 989.39 ( attached below is a graph showing the trendline )

2) attached below is the table showing the calculation of Linear trend forecast