11-6 - Intercept 51.267 MAD MSE MAPE Slope 6.552 Next...

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

View Full Document Right Arrow Icon
Midwestern Electric Company Forecasting Linear trend analysis Input Data Forecast Error Analysis Period Forecast Error Year 1995 64 1 57.818 6.182 6.182 38.215 9.66% Year 1996 68 2 64.370 3.630 3.630 13.179 5.34% Year 1997 72 3 70.921 1.079 1.079 1.164 1.50% Year 1998 74 4 77.473 -3.473 3.473 12.060 4.69% Year 1999 79 5 84.024 -5.024 5.024 25.243 6.36% Year 2000 82 6 90.576 -8.576 8.576 73.544 10.46% Year 2001 90 7 97.127 -7.127 7.127 50.798 7.92% Year 2002 105 8 103.679 1.321 1.321 1.746 1.26% Year 2003 117 9 110.230 6.770 6.770 45.829 5.79% Year 2004 122 10 116.782 5.218 5.218 27.229 4.28% Average 4.840 28.901 5.72%
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: Intercept 51.267 MAD MSE MAPE Slope 6.552 Next period 123.333 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 10 20 40 60 80 100 120 140 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-6 - Intercept 51.267 MAD MSE MAPE Slope 6.552 Next...

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