# Forecasting techniques -regression moving average

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.