On modeling time series data using spreadsheets

Cliff T. Ragsdale and Donald R. Plane

Omega, 2000, vol. 28, issue 2, 215-221

Abstract: Linear regression analysis has long been used to estimate the parameters of various types of times series (TS) models. In some cases, the application of traditional regression-based techniques to TS data does not produce the optimal values of the parameters being estimated. The nonlinear optimization tool (known as Solver) built into today's electronic spreadsheets can alleviate these estimation problems as well as simplify the process of modeling many types of TS problems. This paper presents two examples of TS problems where Solver performs better than regression-based TS techniques. It also encourages educators to reevaluate these and other traditional TS techniques in light of Solver's capabilities.

Keywords: Time; series; Regression; Spreadsheets; Education (search for similar items in EconPapers)
Date: 2000
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0305-0483(99)00038-9
Full text for ScienceDirect subscribers only

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:eee:jomega:v:28:y:2000:i:2:p:215-221

Ordering information: This journal article can be ordered from
http://www.elsevier.com/wps/find/supportfaq.cws_home/regional
https://shop.elsevie ... _01_ooc_1&version=01

Access Statistics for this article

Omega is currently edited by B. Lev

More articles in Omega from Elsevier
Bibliographic data for series maintained by Catherine Liu ().