Question: please show every step in excel 41 Linear Trend with Seasonality homework problem data set Year Summer Fall Winter Spring 1 66 29 65 2
41 Linear Trend with Seasonality homework problem data set Year Summer Fall Winter Spring 1 66 29 65 2 56 45 23 57 3 48 32 14 55 4 52 25 19 47 Steps for procedure using Seasonal Indices: 1) Develp Seasonal Indicies 2) Deseasonalize the data using the Seasonal Indices to (what is left is just "Trend") 3) Use regression analysis to develop the Trend equation Now Forecast: 4a) Use the Trend equation to forecast Trend for the next four quarters 4b) Use the Seasonal Indices to add the seasonality back into the Trend Forecast for the next four quarters
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
