The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Click on the datafile logo to reference the data. DATA file Quarter Year 2 1800 Year 1 1690 940 2625 2500 Year 3 1850 1100 2930 2615 900 2900 2360 3 4 b. Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary). Year Quarter Time Series Value Four-Quarter Moving Average Centered Moving Average 1 1 1690 2 940 3 2625 2500 2 1 1800 2 900 3 2900 4 2360 3 1 1850 2 1100 3 2930 4 2615 C. Compute the seasonal and adjusted seasonal indexes for the four quarters (to 3 decimals). Quarter Seasonal Index Adjusted Seasonal Index 1 2 3 LIII IIIII 4 Total d. When does the publisher have the largest seasonal index? - Select your answer - Does this result appear reasonable? - Select your answer - e. Deseasonalize the time series (to 3 decimals). Year Quarter Deseasonalized Value 1 1 2 3 II. 4 2 1 2 3 4 31 2 IIIII 3 4 f. Compute the linear trend equation for the deseasonalized data (to 1 decimal if necessary). Deseasonalized Value = Period Compute the forecast sales using the linear trend equation (to 1 decimal). + Forecast for quarter 1 Forecast for quarter 2 Forecast for quarter 3 Forecast for quarter 4 g. Adjust the linear trend forecasts using the adjusted seasonal indexes computed in part (c) (to the nearest whole number). LIITUIII Forecast for quarter 1 Forecast for quarter 2 Forecast for quarter 3 Forecast for quarter 4 The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Click on the datafile logo to reference the data. DATA file Quarter Year 2 1800 Year 1 1690 940 2625 2500 Year 3 1850 1100 2930 2615 900 2900 2360 3 4 b. Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary). Year Quarter Time Series Value Four-Quarter Moving Average Centered Moving Average 1 1 1690 2 940 3 2625 2500 2 1 1800 2 900 3 2900 4 2360 3 1 1850 2 1100 3 2930 4 2615 C. Compute the seasonal and adjusted seasonal indexes for the four quarters (to 3 decimals). Quarter Seasonal Index Adjusted Seasonal Index 1 2 3 LIII IIIII 4 Total d. When does the publisher have the largest seasonal index? - Select your answer - Does this result appear reasonable? - Select your answer - e. Deseasonalize the time series (to 3 decimals). Year Quarter Deseasonalized Value 1 1 2 3 II. 4 2 1 2 3 4 31 2 IIIII 3 4 f. Compute the linear trend equation for the deseasonalized data (to 1 decimal if necessary). Deseasonalized Value = Period Compute the forecast sales using the linear trend equation (to 1 decimal). + Forecast for quarter 1 Forecast for quarter 2 Forecast for quarter 3 Forecast for quarter 4 g. Adjust the linear trend forecasts using the adjusted seasonal indexes computed in part (c) (to the nearest whole number). LIITUIII Forecast for quarter 1 Forecast for quarter 2 Forecast for quarter 3 Forecast for quarter 4