11-13 - Sawyer Piano House (Additive Model) Forecasting 4...

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

View Full Document Right Arrow Icon
Sawyer Piano House (Additive Model) Forecasting Additive decomposition 4 seasons Input Data Seasonal Index Computation Forecast Error analysis Period Error Quarter 1 4 1 2.000 2.000 1.108 3.108 0.892 0.892 0.796 22.30% Quarter 2 2 2 -4.313 6.313 2.067 -2.245 4.245 4.245 18.024 212.27% Quarter 3 1 3 3.250 -2.250 -3.938 4.938 3.026 -0.911 1.911 1.911 3.654 191.14% Quarter 4 5 4 3.750 1.250 5.375 -0.375 3.985 9.360 -4.360 4.360 19.011 87.20% Quarter 5 6 5 4.375 1.625 2.000 4.000 4.944 6.944 -0.944 0.944 0.891 15.74% Quarter 6 4 6 5.875 -1.875 -4.313 8.313 5.903 1.591 2.409 2.409 5.805 60.23% Quarter 7 4 7 7.500 -3.500 -3.938 7.938 6.862 2.925 1.075 1.075 1.156 26.88% Quarter 8 14 8 7.875 6.125 5.375 8.625 7.821 13.196 0.804 0.804 0.646 5.74% Quarter 9 10 9 7.875 2.125 2.000 8.000 8.780 10.780 -0.780 0.780 0.609 7.80% Quarter 10 3 10 8.250 -5.250 -4.313 7.313 9.739 5.427 -2.427 2.427 5.889 80.89% Quarter 11 5 11 8.750 -3.750 -3.938 8.938 10.698 6.761 -1.761 1.761 3.100 35.22% Quarter 12 16 12 9.750 6.250 5.375
Background image of page 1

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

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

Page1 / 2

11-13 - Sawyer Piano House (Additive Model) Forecasting 4...

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