Question: Using simple moving averages and the following time series data, respond to each of the Items. Period Demand 130 122 121 112 141 105 116

 Using simple moving averages and the following time series data, respond

Using simple moving averages and the following time series data, respond to each of the Items. Period Demand 130 122 121 112 141 105 116 118 146 125 Click here for the Excel Data File b. Compute all possible forecasts using a six-perlod simple moving average model. (Round your answers to 1 decimal place.) * Answer is complete but not entirely correct. Period Demand 6-Period SMA Absolute Error 1 130 0.0 0.0 2 122 0.0 0.0 3 121 0.0 0.0 112 0.0 0.0 5 141 0.0 0.0 6 105 0.0 0.0 7 116 121.8 5.80 8 118 119.5 1.50 9 146 118.8 0 23.2 X 10 125 122.3 x 6.7 x 11 125.2 0.0 c. Compute the MAD. (Round your answer to 1 decimal place.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!