Video

Excel Online Structured Activity: Simple Linear Regression Forecast

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 simple linear regression forecast and answer the following questions.

Open spreadsheet

Questions

What is the trend line? Round your answers to two decimal places. Do not round intermediate calculations.

Demand $=$

J$+$

Period

$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.

$\backslash$table$[[$Period$,$Forecast$],[1,1,519],[2,1,820],[3,2,121],[4,2,422],[5,2,723]]$

Autosaved at $10$:$10$ AM