Questions from Business Analytics

Q: Modify the Excel file Holt-Winters Additive Model for Seasonality to

Modify the Excel file Holt-Winters Additive Model for Seasonality to implement the Holt-Winters multiplicative seasonality model with no trend.

Q: Experiment with the Holt-Winters Additive Model for Seasonality and Trend

Experiment with the Holt-Winters Additive Model for Seasonality and Trend spread sheet model to find the best combination of , , and  to minimize MSE.

Q: Modify the Excel file Holt-Winters Additive Model for Seasonality and

Modify the Excel file Holt-Winters Additive Model for Seasonality and Trend for the New Car Sales data to implement the Holt-Winters multiplicative seasonality model with trend. Try to find the best c...

Q: The Excel file CD Interest Rates provides annual average interest rates on

The Excel file CD Interest Rates provides annual average interest rates on six-month certificate of deposits. Compare the Holt-Winters additive and multiplicative models using  = 0.7,  = 0.3,  = 0....

Q: Using Table 9.1, Determine the most appropriate forecasting technique

Using Table 9.1, Determine the most appropriate forecasting technique for the data in the Excel file DJIA December Close and implement the model. Data from Table 9.1:

Q: Using table 9.1, Determine the most appropriate forecasting technique

Using table 9.1, Determine the most appropriate forecasting technique for the data in the Excel file Mortgage Rates and implement the model. Data from Table 9.1:

Q: Using table 9.1, Determine the most appropriate forecasting technique

Using table 9.1, Determine the most appropriate forecasting technique for the data in the Excel file Prime Rate and implement the model. Data from Table 9.1:

Q: Using Table 9.1, determine the most appropriate forecasting technique

Using Table 9.1, determine the most appropriate forecasting technique for the data in the Excel file Treasury Yield Rates and implement the model. Data from Table 9.1:

Q: Using Excel’s Moving Average tool for the data in the Excel file

Using Excel’s Moving Average tool for the data in the Excel file Occupancy, identify the moving trend for each of the hotels, motels, backpacker hostels, and holiday parks.

Q: For each of the time series in the following Excel files,

For each of the time series in the following Excel files, construct a line chart of the data and identify the characteristics of the time series (that is, random, stationary, trend, seasonal, or cycli...