Question: Calculate 4 - quarter moving average values for this time series ( column E ) . Calculate centered moving average values and seasonal values (
Calculate quarter moving average values for this time series column E
Calculate centered moving average values and seasonal values column and
Calculate seasonal indexes column J for the four quarters.
Copy seasonal indexes column to column and calculate deseasonalized number sold column P
Construct a time series plot and develop linear trend equation using the deseasonalized data without seasonal components
Calculate trend forecast in year based on the linear trend equation.
Copy seasonal index and compute quarterly forecast values reseasonalize
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
