SOLVED

Use the data given below to answer the following question(s). The worldwide sales of cars from 1981-1990 are shown in the table below. Given: α = 0.2 and γ = 0.05. (Hint: Use XLMiner). Year Units sold in thousands 1 750 2 823 3 1034 4 1945 5 1556 6 1300 7 1346 8 1150 9 967 10 1200 30) Calculate the value of the mean absolute percentage error using the Holt-Winters no-trend model for the given data. A) 8.10 B) 18.39 C) 21.70 D) 10.97 31) Determine the value of the mean absolute deviation using the Holt-Winters no-trend model for the given data. A) 367.35 B) 18.39 C) 21.70 D) 252.55 32) Which of the following is the value of the root mean square error for the given data? A) 252.55 B) 367.35 C) 21.70 D) 109.76 33) Which of the following is the forecast value for the 6th year? A) 1256.06 B) 1328.04 C) 1321.31 D) 1327.24 34) If the given time series has no trend and no seasonality, the most appropriate forecasting model to determine the forecast of the time series is the ________ model. A) single moving average B) Holt-Winters no-trend smoothing C) double exponential smoothing D) Holt-Winters additive 35) If the given time series has a trend and no seasonality, the most appropriate forecasting model to determine the forecast of the time series is the ________ model. A) single exponential smoothing B) Holt-Winters no trend smoothing C) double exponential smoothing D) Holt-Winters additive 36) If the given time series has a trend and seasonality, the most appropriate forecasting model to determine the forecast of the time series is the ________ model. A) multiple regression B) Holt-Winters no trend smoothing C) double exponential smoothing D) Holt-Winters multiplicative Use the data given below to answer the following question(s). The table below provides the sales data for JD Inc. for the year 1998. Given: α = 0.2, β = 0.15, and γ = 0.05 (Hint: Classify the data into quarters for the following question(s).) Umbrella Sales of JD Inc. Year Month Units 1 Jan 3980 1 Feb 4000 1 Mar 4740 1 April 4720 1 May 4920 1 Jun 5140