Quarter Year 1 Year 2 Year 3 Year 4 1 49 60 75 90 2 120 140 180 260 3 310 380 430 510 4 620 710 900 1020

[answerhappygod]

Quarter Year 1 Year 2 Year 3 Year 4 1 49 60 75 90 2 120 140 180 260 3 310 380 430 510 4 620 710 900 1020 1 (25 KiB) Viewed 49 times

5. Develop a regression model with quarters. Use 3 dummy
variables for quarters 1, 2
and 3 respectively. Calculate MAE, MSE, MAPE
Notes: MUST INCLUDE
Show in excel how you will arrange the data to do the Regression
analysis from the data set: Time & Sales.
Then using the linear equation from the regression analysis,
calculate values for Forecast, Forecast Error, Absolute value of
Forecast error, Squared forecast error, % Error, Absolute value of
percentage error. Show the formula used in excel to calculate the
forecast values.
And describe each step in how to get the forecast in excel
(hint: using Data, Data Analysis)
Quarter Year 1 Year 2 Year 3 Year 4 1 49 60 75 90 2 120 140 180 260 3 310 380 430 510 4 620 710 900 1020