Exam 11: Time Series Forecasting

The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs your help in analyzing this data using moving averages. -Refer to Exhibit 11.13. What formulas should go in cells C3:C16 of the spreadsheet if Bill uses a 4 month moving average forecasting model?

The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average method. -Refer to Exhibit 11.19. What are the forecasts for time periods 13-16?

The following questions use the data below. Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using weighted moving averages. -Refer to Exhibit 11.2. Which cell in the spreadsheet is the objective cell in the Risk Solver Platform (RSP) task pane area?

The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using Winter's method. The store has collected 12 quarters of data and needs your help to analyze the data. -Refer to Exhibit 11.8. What formula should be entered in cell H7 to compute the Predicted Sales value for year 2 Quarter 1?

The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using Holt's method. The store has collected 12 quarters of data and needs your help to analyze the data. -Refer to Exhibit 11.7. What are predicted sales for time period 2 using the data in the spreadsheet?

The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs help analyzing the data using a 2-month moving average. -Refer to Exhibit 11.14. What is the forecast for time periods 13-15?

The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using a quadratic trend model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. -Refer to Exhibit 11.10. How is a quadratic term added to the problem if we want to develop a quadratic trend model?

The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use a seasonal regression model to forecast sales. -Refer to Exhibit 11.25. What is the forecast for time period 13?

The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use a quadratic trend model to forecast sales. -Refer to Exhibit 11.23. What is the forecast for time period 13?

How is mean absolute deviation calculated?

The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using a linear trend model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. -Refer to Exhibit 11.9. What formula should be entered in cell E3 to compute the linear trend for year 1 Quarter 1?

As alpha increases the exponential smoothing model

Which of the following is not a quantitative technique for evaluating the accuracy of a time-series modeling technique?

The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using Holt's method. The store has collected 12 quarters of data and needs your help to analyze the data. -Refer to Exhibit 11.7. What are predicted sales for time period 13 using the data in the spreadsheet?

The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using a quadratic trend model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. -Refer to Exhibit 11.10. What formula should be entered in cell F3 to compute the quadratic trend for year 1 Quarter 1?

The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use Winter's method to forecast sales. -Refer to Exhibit 11.21. What is the forecast for time period 13?

The following questions use the data below. Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using weighted moving averages. -Refer to Exhibit 11.2. What is the 2-month weighted moving average forecast for month 3 using the weight in the spreadsheet? Associate weight w₁ with sales in time period 2 and w₂ with sales in time period 1.

The following questions use the data below. A store wants to predict quarterly sales. The owners have has collected 3 years of sales data and wants your help in analyzing the data. They want to use a quadratic trend model with seasonality to forecast sales. -Refer to Exhibit 11.24. Based on the regression output, what formulas should go in cells D3:H21?

A time series which has a significant upward or downward trend is referred to as

The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs help analyzing the data using a 2-month moving average. -Refer to Exhibit 11.14. What formulas should go into cells B15:B18 and cells C15:C18 of the spreadsheet if a 2-month moving average forecasting model is used?