Exam 16: Time-Series Forecasting

TABLE 16-5 The number of passengers arriving at San Francisco on the Amtrak cross-country express on 6 successive Mondays were: 60,72,96,84,36,and 48. -Referring to Table 16-5,the number of arrivals will be smoothed with a 5-term moving average.The last smoothed value will be ________.

TABLE 16-13 Given below is the monthly time-series data for U.S.retail sales of building materials over a specific year. The results of the linear trend,quadratic trend,exponential trend,first-order autoregressive,second-order autoregressive and third-order autoregressive model are presented below in which the coded month for the 1^st month is 0: Linear trend model: Quadratic trend model: Exponential trend model: First-order autoregressive: Second-order autoregressive: Third-order autoregressive: Below is the residual plot of the various models: -True or False: Referring to Table 16-13,the best model based on the residual plots is the exponential-trend regression model.

TABLE 16-13 Given below is the monthly time-series data for U.S.retail sales of building materials over a specific year. The results of the linear trend,quadratic trend,exponential trend,first-order autoregressive,second-order autoregressive and third-order autoregressive model are presented below in which the coded month for the 1^st month is 0: Linear trend model: Quadratic trend model: Exponential trend model: First-order autoregressive: Second-order autoregressive: Third-order autoregressive: Below is the residual plot of the various models: -Referring to Table 16-13,what is the exponentially smoothed value for the first month using a smoothing coefficient of W = 0.25?

TABLE 16-4 The number of cases of merlot wine sold by a Paso Robles winery in an 8-year period follows. -Referring to Table 16-4,exponential smoothing with a weight or smoothing constant of 0.4 will be used to forecast wine sales.The forecast for 2013 is ________.

TABLE 16-3 The following table contains the number of complaints received in a department store for the first 6 months of last year. -Referring to Table 16-3,if this series is smoothed using exponential smoothing with a smoothing constant of ,what would be the third value?

TABLE 16-4 The number of cases of merlot wine sold by a Paso Robles winery in an 8-year period follows. -Referring to Table 16-4,exponentially smooth the wine sales with a weight or smoothing constant of 0.4.

TABLE 16-13 Given below is the monthly time-series data for U.S.retail sales of building materials over a specific year. The results of the linear trend,quadratic trend,exponential trend,first-order autoregressive,second-order autoregressive and third-order autoregressive model are presented below in which the coded month for the 1^st month is 0: Linear trend model: Quadratic trend model: Exponential trend model: First-order autoregressive: Second-order autoregressive: Third-order autoregressive: Below is the residual plot of the various models: -Referring to Table 16-13,what is the p-value of the t test statistic for testing the appropriateness of the third-order autoregressive model?

TABLE 16-3 The following table contains the number of complaints received in a department store for the first 6 months of last year. -Referring to Table 16-3,if a three-month moving average is used to smooth this series,what would be the second calculated value?

TABLE 16-13 Given below is the monthly time-series data for U.S.retail sales of building materials over a specific year. The results of the linear trend,quadratic trend,exponential trend,first-order autoregressive,second-order autoregressive and third-order autoregressive model are presented below in which the coded month for the 1^st month is 0: Linear trend model: Quadratic trend model: Exponential trend model: First-order autoregressive: Second-order autoregressive: Third-order autoregressive: Below is the residual plot of the various models: -Referring to Table 16-13,what is the exponentially smoothed forecast for the 13^th month using a smoothing coefficient of W = 0.25 if the exponentially smooth value for the 10^th and 11^th month are 9,477.7776 and 9,411.8332,respectively?

TABLE 16-9 Given below are EXCEL outputs for various estimated autoregressive models for a company's real operating revenues (in billions of dollars)from 1989 to 2012.From the data,you also know that the real operating revenues for 2010,2011,and 2012 are 11.7909,11.7757 and 11.5537,respectively. First-Order Autoregressive Model: Second-Order Autoregressive Model: Third-Order Autoregressive Model: -Referring to Table 16-9,if one decides to use the Third-Order Autoregressive model,what will the predicted real operating revenue for the company be in 2014?

The annual multiplicative time-series model does not possess ________ component.

The cyclical component of a time series

TABLE 16-5 The number of passengers arriving at San Francisco on the Amtrak cross-country express on 6 successive Mondays were: 60,72,96,84,36,and 48. -Referring to Table 16-5,the number of arrivals will be exponentially smoothed with a smoothing constant of 0.25.The forecast of the number of arrivals on the seventh Monday will be ________.

TABLE 16-10 Business closures in Laramie,Wyoming from 2007 to 2012 were: Microsoft Excel was used to fit both first-order and second-order autoregressive models,resulting in the following partial outputs: SUMMARY OUTPUT - 2nd Order Model Coefficients Intercept -5.77 X Variable 1 0.80 X Variable 2 1.14 SUMMARY OUTPUT - 1st Order Model Coefficients Intercept -4.16 X Variable 1 1.59 -Referring to Table 16-10,the value of the MAD for the second-order autoregressive model is ________.

TABLE 16-9 Given below are EXCEL outputs for various estimated autoregressive models for a company's real operating revenues (in billions of dollars)from 1989 to 2012.From the data,you also know that the real operating revenues for 2010,2011,and 2012 are 11.7909,11.7757 and 11.5537,respectively. First-Order Autoregressive Model: Second-Order Autoregressive Model: Third-Order Autoregressive Model: -Referring to Table 16-9 and using a 5% level of significance,what is the appropriate autoregressive model for the company's real operating revenue?

True or False: Given a data set with 15 yearly observations,there are only thirteen 3-year moving averages.

TABLE 16-14 A contractor developed a multiplicative time-series model to forecast the number of contracts in future quarters,using quarterly data on number of contracts during the 3-year period from 2010 to 2012.The following is the resulting regression equation: ln = 3.37 + 0.117 X - 0.083 Q₁ + 1.28 Q₂ + 0.617 Q₃ where is the estimated number of contracts in a quarter X is the coded quarterly value with X = 0 in the first quarter of 2010 Q₁ is a dummy variable equal to 1 in the first quarter of a year and 0 otherwise Q₂ is a dummy variable equal to 1 in the second quarter of a year and 0 otherwise Q₃ is a dummy variable equal to 1 in the third quarter of a year and 0 otherwise -Referring to Table 16-14,to obtain a forecast for the first quarter of 2013 using the model,which of the following sets of values should be used in the regression equation?

TABLE 16-8 The manager of a marketing consulting firm has been examining his company's yearly profits.He believes that these profits have been showing a quadratic trend since 1994.He uses Microsoft Excel to obtain the partial output below.The dependent variable is profit (in thousands of dollars),while the independent variables are coded years and squared of coded years,where 1994 is coded as 0,1995 is coded as 1,etc. SUMMARY OUTPUT Regression Statistics Multiple R 0.998 R Square 0.996 Adjusted R Square 0.996 Standard Error 4.996 Observations 17 Coefficients Intercept 35.5 Coded Year 0.45 Year Squared 1.00 -Referring to Table 16-8,the fitted value for 1994 is ________.

The effect of an unpredictable,rare event will be contained in the ________ component.

TABLE 16-13 Given below is the monthly time-series data for U.S.retail sales of building materials over a specific year. The results of the linear trend,quadratic trend,exponential trend,first-order autoregressive,second-order autoregressive and third-order autoregressive model are presented below in which the coded month for the 1^st month is 0: Linear trend model: Quadratic trend model: Exponential trend model: First-order autoregressive: Second-order autoregressive: Third-order autoregressive: Below is the residual plot of the various models: -Referring to Table 16-13,if a five-month moving average is used to smooth this series,how many moving averages can you compute?