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
Posted: Sat Feb 26, 2022 11:18 am
- 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 37 times
not use quarters, time =
1,2,3,…. 16). 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