Question

Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...

Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.8. Compute the MAD and MSE.

Time period Value
1 27
2 31
3 58
4 63
5 59
6 66
7 71
8 86
9 101
10 97

Group of answer choices

a) MAD=9.7, MSE=1585.6

b) MAD=9.7, MSE=176.2

c) MAD=10.2, MSE=1585.6

d) MAD=10.2, MSE=176.2

Homework Answers

Answer #1
Time period Value Forecast Error Error^2 |Error|
1 27
2 31 27 4 16 4
3 58 30.2 27.8 772.84 27.8
4 63 52.44 10.56 111.5136 10.56
5 59 60.888 -1.888 3.564544 1.888
6 66 59.3776 6.6224 43.85618 6.6224
7 71 64.67552 6.32448 39.99905 6.32448
8 86 69.7351 16.2649 264.5468 16.2649
9 101 82.74702 18.25298 333.1712 18.25298
10 97 97.3494 -0.3494 0.122083 0.3494
α = 0.8
MSE= 1585.6
MAD= 10.2

Forecast is calculated using;

MSE=sum of suqare of error

MAD=Average of absolute sum of error.

We get:

MSE=1585.6

MAD=10.2

Hence,option (C) MAD=10.2, MSE=1585.6 is correct .

please rate my answer and comment for doubts.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.8. Compute the MAD and MSE. Time period Value 1 27 2 31 3 58 4 63 5 59 6 66 7 71 8 86 9 101 10 97
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.1. Compute the MAD and MSE. Time period Value 1 27 2 31 3 58 4 63 5 59 6 66 7 71 8 86 9 101 10 97 Group of answer choices A) MAD=296.6, MSE=1266.5 B) MAD=296.6 , MSE=11398.5 C)...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. A. The...
Using ? = 0.5 and the following data, compute exponential smoothing forecasts for periods 2 through...
Using ? = 0.5 and the following data, compute exponential smoothing forecasts for periods 2 through 8. (Round your intermediate calculations and final answers to 2 decimal places.) Period: 1 2 3 4 5 6 7 Forecast: 10 Actual demand: 12 15 11 13 11 11 10
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel,...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 16 11 18 13 (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 19 2 12 3 16 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE =   What is the forecast for week 7? (c) Use α = 0.2 to compute...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. The actual values for 12 periods (shown in order) are: (1) 45  (2)...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel,...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 16 2 11 3 13 4 10 5 14 6 12 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 16 2 11 3 13 4...