Newark College (see Problem 16.40) would like to include seasonality in its GPA forecasting model. The average

Question:

Newark College (see Problem 16.40) would like to include seasonality in its GPA forecasting model. The average GPA of the study body for each year was broken down into the average GPA by semester (Fall, Spring, Summer) and can be found in the Excel file grade inflation by semester.xlsx.

Year GPA Year GPA 2010 2.94 2014 2.85 2011 2.82 2015 3.08 2012 2.90 2016 3.15 2013 2.96 2017 3.10


a. Using multiplicative decomposition, forecast the average GPA for the student body for each semester during 2018.

b. Interpret the meaning of the seasonal components.

c. Calculate the MAD for this forecast.

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

Step by Step Answer:

Related Book For  answer-question

Business Statistics

ISBN: 9780134685267

3rd Edition

Authors: Robert A. Donnelly

Question Posted: