Use the data given below to answer the following questions).
The worldwide sales of cars from 1981-1990 are shown in the table below. Given: α = 0.2 and
β = 0.15 Hint: Use XLMiner) $$\begin{array} { | c | c| }
\hline \text { Year } & \begin{array} { c }
\text { Units sold in } \
\text { thousands }
\end{array} \
\hline 1981 & 888 \
\hline 1982 & 900 \
\hline 1983 & 1000 \
\hline 1984 & 1200 \
\hline 1985 & 1100 \
\hline 1986 & 1300 \
\hline 1987 & 1250 \
\hline 1988 & 1150 \
\hline 1989 & 1100 \
\hline 1990 & 1200 \
\hline
\end{array}$$
-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

Question

Use the data given below to answer the following questions).
The worldwide sales of cars from 1981-1990 are shown in the table below. Given: α = 0.2 and
β = 0.15 Hint: Use XLMiner) $$\begin{array} { | c | c| } 
\hline \text { Year } & \begin{array} { c } 
\text { Units sold in } \
\text { thousands }
\end{array} \
\hline 1981 & 888 \
\hline 1982 & 900 \
\hline 1983 & 1000 \
\hline 1984 & 1200 \
\hline 1985 & 1100 \
\hline 1986 & 1300 \
\hline 1987 & 1250 \
\hline 1988 & 1150 \
\hline 1989 & 1100 \
\hline 1990 & 1200 \
\hline
\end{array}$$
-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

Quizplus · Accepted Answer

Double exponential smoothing is used for data with a trend. The mean square error (MSE) is calculated by applying the smoothing formulae with given α and β values. The correct MSE value from the options provided is 11976.17.

Use the Data Given Below to Answer the Following Questions)