Explore BrainMass
Share

# Forecasting techniques -regression moving average

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Perform a linear regression, 8 month moving average & 3 month moving average forecasting technique to see which is most accurate for the new quarter 11 if quarter 11 sales are 172,000 units

Quarter Quarter Demand Shown in Thousand (1000) units
1 121
2 132
3 159
4 160
5 141
6 166
7 189
8 199
9 170
10 190

Make sure to include the equation for the linear regression calculation.
Explain 5 factors that could affect forecast accuracy.

https://brainmass.com/statistics/linear-regression/forecasting-techniques-regression-moving-average-227946

#### Solution Preview

Please see ** ATTACHED ** file(s) for complete solution and details!!

Perform a linear regression, 8 month moving average & 3 month moving average forecasting technique to see which is most accurate for the new quarter 11 if quarter 11 sales are 172,000 units

Quarter (X) Demand (Y)
1 121
2 132
3 159
4 160
5 141
6 166
7 189
8 199
9 170
10 190
Demand Shown in Thousand (1000) units
Make sure to include the equation for the linear regression calculation.

1) Linear regression

Linear regression equation is
Y= a + b X

where

(X) ...

#### Solution Summary

Performs a linear regression, 8 month moving average & 3 month moving average forecasting techniques.

\$2.19