A Solution of GM(1,1) based on EXCEL

Cheng Li and Jixiang Li

Business and Management Research, 2016, vol. 5, issue 3, 86-91

Abstract: The air cargo throughput forecasting can be used by five methods, which are the expert-determined method, analogy method, the trend extrapolation, the econometric methods, and the market analysis.In this paper, a new forecasting method, grey system model is put forward in the case of less information to get high precision of prediction results, and a GM(1,1) model is created about air cargo throughput based on Microsoft Office Excel and VBA Programming for the technology platform. Examples are given to show the model is effective and reasonablewith higher forecasting accuracy and only 0.3% errors, which proves that the solution of GM(1,1) based on EXCEL can reduce the technical requirements for the staff, as EXCEL can be used to solve the problem without much programming background, and staff can also easily ?master and utilize GM (1, 1) model.?

Date: 2016
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.sciedupress.com/journal/index.php/bmr/article/download/10123/6230 (application/pdf)
http://www.sciedupress.com/journal/index.php/bmr/article/view/10123 (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:jfr:bmr111:v:5:y:2016:i:3:p:86-91

Access Statistics for this article

Business and Management Research is currently edited by Simon Lee

More articles in Business and Management Research from Business and Management Research, Sciedu Press
Bibliographic data for series maintained by Simon Lee ().