search query: @indexterm time series / total: 413
reference: 65 / 413
| Author: | Ragsdale, C.T. Plane, D.R. |
| Title: | On modeling time series data using spreadsheets |
| Journal: | Omega
2000 : APR, VOL. 28:2, p. 215-221 |
| Index terms: | Time series Software Education Models |
| Freeterms: | Regression |
| Language: | eng |
| 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 non-linear optimization tool, known as Solver, built into today's electronic spreadsheets can alleviate estimation problems as well as simplify the modeling process for many types of TS problems. This paper presents 2 examples of TS problems where Solver performs better than regression-based TS techniques. It also encourages educators to re-evaluate these and other traditional TS techniques in light of Solver's capabilities. |
SCIMA