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.15 (Hint: Use XLMiner) 23. Calculate the value of the mean absolute percentage error using double exponential smoothing for the given data. A) 1.80 B) 8.10 C) 91.27 D) 11976.17 Answer: B 24. Identify the value of the mean square error using double exponential smoothing for the given set of data. A) 8.10 B) 1.80 C) 91.27 D) 11976.17 Answer: D 25. Using the double exponential smoothing, calculate the value of the mean absolute deviation for the given data. A) 8.10 B) 1.80 C) 91.27 D) 11976.17 Answer: C 26. Using the double exponential smoothing, find the value of the root mean square error for the given data. A) 8.10 B) 91.27 C) 11976.17 D) 109.44 Answer: D 27. Which of the following equations is the trend line equation for the given data? (Note: the fitted model assumes that the years are numbered 1 through 10 , not the actual dates.) A) 60.123x+481.56 B) 48.16x+481.86 C) 32.17x+931.87 D) 57.15x+503.81 Answer: C 28. For the given data, what is the sales foreeast for the year 1992 (in thousands)? A) 1256.87 B) 1317.91 C) 1285.74 D) 1350.08 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.15 (Hint: Use XLMiner) 23. Calculate the value of the mean absolute percentage error using double exponential smoothing for the given data. A) 1.80 B) 8.10 C) 91.27 D) 11976.17 Answer: B 24. Identify the value of the mean square error using double exponential smoothing for the given set of data. A) 8.10 B) 1.80 C) 91.27 D) 11976.17 Answer: D 25. Using the double exponential smoothing, calculate the value of the mean absolute deviation for the given data. A) 8.10 B) 1.80 C) 91.27 D) 11976.17 Answer: C 26. Using the double exponential smoothing, find the value of the root mean square error for the given data. A) 8.10 B) 91.27 C) 11976.17 D) 109.44 Answer: D 27. Which of the following equations is the trend line equation for the given data? (Note: the fitted model assumes that the years are numbered 1 through 10 , not the actual dates.) A) 60.123x+481.56 B) 48.16x+481.86 C) 32.17x+931.87 D) 57.15x+503.81 Answer: C 28. For the given data, what is the sales foreeast for the year 1992 (in thousands)? A) 1256.87 B) 1317.91 C) 1285.74 D) 1350.08