Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. (Moving Average Forecast) In the file PS3Sale.txt, there is a time series of sales data from 83.IV to 93.III. Let's hold-out the last four

image text in transcribed

3. (Moving Average Forecast) In the file "PS3Sale.txt", there is a time series of sales data from 83.IV to 93.III. Let's hold-out the last four observations, that is not using them in estimation. (a) In the exponential moving average, determine the optimal (one decimal points) (use the first 36 observation to estimate). Forecast the last four periods and compare them to the actual last four observations to compute your average forecasting error (the square root of the average squared prediction error). (b) Set to what you find in (a), we now introduce a time trend, t. What is the optimal 1 ? (one decimal point) What is your average forecasting error for the last four observations (the square root of the average squared prediction error)? (c) Set and 1 to what you find in (a) and (b), we include an additional seasonality Ft. What is the optimal 2 ? (one decimal point) What is your average forecasting error for the last four observations (the square root of the average squared prediction error)? (d) Comparing your forecasting errors in the previous cases, what can you say? 3. (Moving Average Forecast) In the file "PS3Sale.txt", there is a time series of sales data from 83.IV to 93.III. Let's hold-out the last four observations, that is not using them in estimation. (a) In the exponential moving average, determine the optimal (one decimal points) (use the first 36 observation to estimate). Forecast the last four periods and compare them to the actual last four observations to compute your average forecasting error (the square root of the average squared prediction error). (b) Set to what you find in (a), we now introduce a time trend, t. What is the optimal 1 ? (one decimal point) What is your average forecasting error for the last four observations (the square root of the average squared prediction error)? (c) Set and 1 to what you find in (a) and (b), we include an additional seasonality Ft. What is the optimal 2 ? (one decimal point) What is your average forecasting error for the last four observations (the square root of the average squared prediction error)? (d) Comparing your forecasting errors in the previous cases, what can you say

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Everything Improve Your Credit Book

Authors: Justin Pritchard

1st Edition

1598691554, 978-1598691559

More Books

Students also viewed these Finance questions