Ch04Ex12 - Payroll Forecast Error Absolute Squared 1 2 1 2...

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

View Full Document Right Arrow Icon
TEST Forecasting Multiple regression Data Forecasts and Error Analysis Y x 1 Forecast Error Absolute Squared Period 1 Err:502 Err:502 Err:502 Err:502 Period 2 Err:502 Err:502 Err:502 Err:502 Period 3 Err:502 Err:502 Err:502 Err:502 Period 4 Err:502 Err:502 Err:502 Err:502 Period 5 Err:502 Err:502 Err:502 Err:502 Period 6 Err:502 Err:502 Err:502 Err:502 Total Err:502 Err:502 Err:502 Coefficients Err:502 Err:502 Average Err:502 Err:502 Err:502 Bias MAD MSE SE Err:502 Forecast Err:502 7 Correlation #VALUE! Enter the data in the shaded area. To get a forecast use the shaded data area at the bottom left of the sheet.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Abs Pct Err Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 MAPE
Background image of page 2
CHAPTER 4: Example 12 Forecasting Regression/Trend analysis Data Forecasts and Error Analysis Period Sales
Background image of page 3

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

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

Unformatted text preview: Payroll Forecast Error Absolute Squared 1 2 1 2 2 3 3 2.5 0.5 0.5 0.25 3 2.5 4 2.75-0.25 0.25 0.06 4 2 2 2.25-0.25 0.25 0.06 5 2 1 2 6 3.5 7 3.5 Total 1 0.38 Intercept 1.75 Average 0.17 0.06 Slope 0.25 Bias MAD MSE SE 0.31 Next period 3.5 7 Correlation 0.9 If this is trend analysis then simply enter the past demands in the demand column. If this is causal regression then enter the y,x pairs with y first and enter a new value of x at the bottom in order to forecast y. Abs Pct Err 00.00% 16.67% 10.00% 12.50% 00.00% 00.00% 39.17% 06.53% MAPE 1 2 3 4 5 6 7 8 0.5 1 1.5 2 2.5 3 3.5 4 Regression Column B Linear Re-gression for Column B...
View Full Document

Page1 / 3

Ch04Ex12 - Payroll Forecast Error Absolute Squared 1 2 1 2...

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

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