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). \(\begin{array}{|c|c|} \hline \text { Year } & \begin{array}{c} \text { Units sold in } \\ \text { thousands } \end{array} \\ \hline 1 & 750 \\ \hline 2 & 823 \\ \hline 3 & 1034 \\ \hline 4 & 1945 \\ \hline 5 & 1556 \\ \hline 6 & 1300 \\ \hline 7 & 1346 \\ \hline 8 & 1150 \\ \hline 9 & 967 \\ \hline 10 & 1200 \\ \hline \end{array}\) -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 A) 367.35 B) 18.39 C) 21.70 D) 252.55

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) \(\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 A) 8.10 B) 1.80 C) 91.27 D) 11976.17

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) \(\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}\) -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 A) 1.80 B) 8.10 C) 91.27 D) 11976.17

Use the data shown below to answer the following question(s). The table below is the data set of the Shiller Real Home Price Index for the years 1946-1956. \(\begin{array}{c|c} \text { Year } & \begin{array}{c} \text { Real Home Price } \\ \text { Index } \end{array} \\ \hline 1946 & 106.5058955 \\ \hline 1947 & 109.3296707 \\ \hline 1948 & 101.2225795 \\ \hline 1949 & 100.0466076 \\ \hline 1950 & 105.8948393 \\ \hline 1951 & 103.8986687 \\ \hline 1952 & 103.9743275 \\ \hline 1953 & 114.7133093 \\ \hline 1954 & 114.199126 \\ \hline 1955 & 115.4621261 \\ \hline 1956 & 115.3166155 \end{array}\) -Setting k = 3, determine the value of mean absolute percentage of error.

@#IMG-DLM& \[ \mathrm{MAPE}=\frac{\sum

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). \(\begin{array}{|c|c|} \hline \text { Year } & \begin{array}{c} \text { Units sold in } \\ \text { thousands } \end{array} \\ \hline 1 & 750 \\ \hline 2 & 823 \\ \hline 3 & 1034 \\ \hline 4 & 1945 \\ \hline 5 & 1556 \\ \hline 6 & 1300 \\ \hline 7 & 1346 \\ \hline 8 & 1150 \\ \hline 9 & 967 \\ \hline 10 & 1200 \\ \hline \end{array}\) -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 A) single exponential smoothing B) Holt-Winters no trend smoothing C) double exponential smoothing D) Holt-Winters additive

Exam 10: Forecasting Techniques

Use the data given below to answer the following question(s). The table provided below gives the sales details of the number of android smart phones at an electronic retail store for the past 6 weeks.The time series appears to be relatively stable, without trend, seasonal, or cyclical effects.The value of k is set at 3.(Hint: Optimize α value.) Week Units sold 1 88 2 44 3 54 4 65 5 72 6 85 -Calculate the value of the mean absolute percentage error for the given data.

(Multiple Choice)

4.9/5

(40)

Question 41

Explain the significance of using double moving average and double exponential smoothing models.

(Essay)

4.8/5

(27)

Question 42

Identify the formula used to calculate the root mean square error over a range of forecasted values, if the actual value of the time series at time t and the forecast value for time t are denoted by At and Ft respectively.

(Multiple Choice)

4.8/5

(36)

Question 43

Write a short note on indicators and indexes used in forecasting.

(Essay)

4.8/5

(31)

Question 44

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 -Determine the value of the mean absolute deviation using the Holt-Winters no-trend model for the given data.

(Multiple Choice)

4.8/5

(44)

Question 45

In forecasting, what is an index?

(Multiple Choice)

4.9/5

(30)

Question 46

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) Year Units sold in thousands 1981 888 1982 900 1983 1000 1984 1200 1985 1100 1986 1300 1987 1250 1988 1150 1989 1100 1990 1200 -Identify the value of the mean square error using double exponential smoothing for the given set of data.

(Multiple Choice)

4.7/5

(27)

Question 47

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) Year Units sold in thousands 1981 888 1982 900 1983 1000 1984 1200 1985 1100 1986 1300 1987 1250 1988 1150 1989 1100 1990 1200 -Calculate the value of the mean absolute percentage error using double exponential smoothing for the given data.

(Multiple Choice)

4.8/5

(42)

Question 48

Use the data given below to answer the following question(s). The table provided below gives the sales details of the number of android smart phones at an electronic retail store for the past 6 weeks.The time series appears to be relatively stable, without trend, seasonal, or cyclical effects.The value of k is set at 3.(Hint: Optimize α value.) Week Units sold 1 88 2 44 3 54 4 65 5 72 6 85 -What is the forecasted value for the 7th week?

(Multiple Choice)

4.7/5

(31)

Question 49

Indicators are measures that are believed to influence the behavior of a variable an individual wishes to forecast.

(True/False)

4.9/5

(33)

Question 50

Use the data given below to answer the following question(s). The details of the clock sales at a supermarket for the past 6 weeks are shown in the table below.The time series appears to be relatively stable, without trend, seasonal, or cyclical effects.The simple moving average value of k is set at 2. Week Units sold 1 88 2 44 3 54 4 65 5 72 6 85 -For the given data, what is the value of the simple moving average mean square error?

(Multiple Choice)

4.8/5

(37)

Question 51

Use the data shown below to answer the following question(s). The table below is the data set of the Shiller Real Home Price Index for the years 1946-1956. Year Real Home Price Index 1946 106.5058955 1947 109.3296707 1948 101.2225795 1949 100.0466076 1950 105.8948393 1951 103.8986687 1952 103.9743275 1953 114.7133093 1954 114.199126 1955 115.4621261 1956 115.3166155 -Setting k = 3, determine the value of mean absolute percentage of error.

(Essay)

4.8/5

(40)

Question 52

What is simple exponential smoothing?

(Essay)

4.9/5

(38)

Question 53

The indexes in the forecasting indicators provide a complete forecast.

(True/False)

4.8/5

(36)

Question 54

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 -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.

(Multiple Choice)

4.9/5

(40)

Question 55

Explain the significance of using double moving average and double exponential smoothing models.

Identify the formula used to calculate the root mean square error over a range of forecasted values, if the actual value of the time series at time t and the forecast value for time t are denoted by At and Ft respectively.

Write a short note on indicators and indexes used in forecasting.

In forecasting, what is an index?

Indicators are measures that are believed to influence the behavior of a variable an individual wishes to forecast.

What is simple exponential smoothing?

The indexes in the forecasting indicators provide a complete forecast.

Introduction to Business Analytics

Analytics on Spreadsheets

Visualizing and Exploring Data

Descriptive Statistical Measures

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Predictive Modeling and Analysis

Regression Analysis

Simulation and Risk Analysis

Introduction to Data Mining

Linear Optimization

Applications of Linear Optimization

Integer Optimization

Nonlinear and Non-Smooth Optimization

Optimization Models with Uncertainty

Decision Analysis

Filters