Teaching decomposition forecasting models using an Excel-based spreadsheet application with Solver and randomisation
by Kurt Hozak
International Journal of Innovation and Learning (IJIL), Vol. 26, No. 4, 2019

Abstract: This article describes an Excel-based application to help teach forecasting with additive and multiplicative decomposition models using the standard Solver add-in to identify intercept, linear trend, and seasonality parameters. By using the application, students can see how easy it is to apply Solver's GRG nonlinear solving method in a relatively familiar forecasting context. To give additional opportunities to practice and encourage academic integrity, the software randomly generates data and layouts and disables copying and pasting between windows. Homework results suggest it provides a challenge despite offering extensive feedback and help. Students reported that it helped them learn forecasting and Excel. Those who correctly completed the assignment have had mixed results on a variety of forecasting exam questions. Even when using innovative technologies such as this application, additional resources, motivation, and opportunities may be necessary to facilitate breadth and depth of learning beyond the essentials required to complete assignments.

Online publication date: Thu, 10-Oct-2019

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Innovation and Learning (IJIL):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your password?


Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com