11-12 - Next period 27.022 11 Actual value(or Y Period...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Solved Problem 11-2 Forecasting Linear trend analysis Input Data Forecast Error Analysis Period Forecast Error Year 1 17 1 15.689 1.311 1.311 1.719 7.71% Year 2 16 2 16.822 -0.822 0.822 0.676 5.14% Year 3 16 3 17.956 -1.956 1.956 3.824 12.22% Year 4 21 4 19.089 1.911 1.911 3.652 9.10% Year 5 20 5 20.222 -0.222 0.222 0.049 1.11% Year 6 20 6 21.356 -1.356 1.356 1.838 6.78% Year 7 23 7 22.489 0.511 0.511 0.261 2.22% Year 8 25 8 23.622 1.378 1.378 1.898 5.51% Year 9 24 9 24.756 -0.756 0.756 0.571 3.15% Average 1.136 1.610 5.88% Intercept 14.556 MAD MSE MAPE Slope 1.133
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Next period 27.022 11 Actual value (or) Y Period number (or) X Absolute error Squared error Absolute % error Enter the actual values in cells shaded YELLOW. Enter new time period at the bottom to forecast Y. Enter the actual values in cells shaded YELLOW. Enter new time period at the bottom to forecast Y. 1 2 3 4 5 6 7 8 9 5 10 15 20 25 30 Trend Analysis Column B Column E Time Value...
View Full Document

This note was uploaded on 12/10/2011 for the course INSY 4508 taught by Professor Graham during the Spring '10 term at Bentley.

Page1 / 2

11-12 - Next period 27.022 11 Actual value(or Y Period...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online