Try the fastest way to create flashcards
Question

Consider the following time series data

 Week 123456 Value 181316111714\begin{array}{l|rrrrrr} \text { Week } & 1 & 2 & 3 & 4 & 5 & 6 \\ \hline \text { Value } & 18 & 13 & 16 & 11 & 17 & 14 \end{array}

Use α=0.2\alpha=0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7.

Solution

Verified
Answered 1 year ago
Answered 1 year ago
Step 1
1 of 3

c) In order to compute the exponential smoothing values for the time series, we will need to click "Data" \to"Data Analysis" \to "Exponential Smoothing" \to"Ok".

In the new window, at "Input Range" we should select "Value" data from the data field.

Damping factor = 1α1- \alpha We should make the "Damping factor" equal to 0.8.

At "Output Range" we should select next empty column in the data field.

Click "Ok".

Create a free account to view solutions

Create a free account to view solutions

Recommended textbook solutions

Statistics for Business and Economics 13th Edition by James T. McClave, P. George Benson, Terry T Sincich

Statistics for Business and Economics

13th EditionISBN: 9780134446332 (1 more)James T. McClave, P. George Benson, Terry T Sincich
5,424 solutions
Statistics for Business and Economics 12th Edition by David R. Anderson, Dennis J. Sweeney, James J Cochran, Jeffrey D. Camm, Thomas A. Williams

Statistics for Business and Economics

12th EditionISBN: 9781133274537 (12 more)David R. Anderson, Dennis J. Sweeney, James J Cochran, Jeffrey D. Camm, Thomas A. Williams
2,021 solutions
Essentials of Business Analytics 1st Edition by David R. Anderson, James J Cochran, Jeffrey D. Camm, Jeffrey W Ohlmann, Michael J Fry

Essentials of Business Analytics

1st EditionISBN: 9781285187273 (2 more)David R. Anderson, James J Cochran, Jeffrey D. Camm, Jeffrey W Ohlmann, Michael J Fry
466 solutions
Statistics for Business and Economics 14th Edition by David R. Anderson, Dennis J. Sweeney, James J Cochran, Jeffrey D. Camm, Thomas A. Williams

Statistics for Business and Economics

14th EditionISBN: 9781337901062 (1 more)David R. Anderson, Dennis J. Sweeney, James J Cochran, Jeffrey D. Camm, Thomas A. Williams
1,772 solutions

More related questions

1/4

1/7