trend analysis - 4/18/11 trend of forcast Forecasting Trend...

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

View Full Document Right Arrow Icon
4/18/11 trend of forcast Forecasting Trend adjusted exponential smoothing Alpha Beta Data Forecasts and Error Analysis Period Demand Error Absolute Squared Abs Pct Err Quarter 1 264.7938 264.7938 264.7938 0 0 0 00.00% Quarter 2 298.1578 264.7938 0 264.7938 33.364 33.364 1113.1565 11.19% Quarter 3 298.5335 264.7938 0 264.7938 33.7397 33.7397 1138.36736 11.30% Quarter 4 359.8719 264.7938 0 264.7938 95.0781 95.0781 9039.8451 0.26419984 Next period 264.7938 0 264.7938 Total 162.1818 162.1818 11291.369 48.91% Average 40.54545 40.54545 2822.8422 12.23% Bias MAD MSE MAPE SE 75.13777 Smoothed Forecast, F t Smoothed Trend, T t Forecast Including Trend, FIT t 1 2 3 240 250 260 270 280 290 300 310 Forecasting Column B Forecasts and Error Analysis Time Value Enter alpha and beta (between 0 and 1), enter the past demands in the shaded column then enter a starting forecast. If the starting forecast is not in the first period then delete the error analysis for all rows above the starting forecast.
Background image of page 1

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

View Full DocumentRight Arrow Icon
4/18/11 Trend Analysis
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/19/2012 for the course ECON 332 taught by Professor Rodgers during the Three '12 term at University of Wollongong, Australia.

Page1 / 2

trend analysis - 4/18/11 trend of forcast Forecasting Trend...

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