The GNP for each quarter of the past four years is shown in the following table: (a)

Question:

The GNP for each quarter of the past four years is shown in the following table:
The GNP for each quarter of the past four years

(a) Find the optimal value of a that would minimize MAPE for the exponential smoothing model.
(b) What is the linear trend equation that best fits the data? Forecast the GNP for the first quarter of year 5 by using this equation.
(c) Forecast the GNP for the first quarter of year 5 by using a four-period moving average.
(d) Which of these methods is most appropriate to use? Justify your answer.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 9780136115830

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: