On modeling time series data using spreadsheets

被引：9

作者：

Ragsdale, CT ^{[1
]}

Plane, DR

机构：

[1] Georgia So Univ, Dept Management, Statesboro, GA 30460 USA

[2] Rollins Coll, Crummer Grad Sch Business, Winter Pk, FL 32789 USA

来源：

OMEGA-INTERNATIONAL JOURNAL OF MANAGEMENT SCIENCE | 2000年 / 28卷 / 02期

关键词：

time series; regression; spreadsheets; education;

D O I：

10.1016/S0305-0483(99)00038-9

中图分类号：

C93 [管理学];

学科分类号：

12 ; 1201 ; 1202 ; 120202 ;

摘要：

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. (C) 2000 Elsevier Science Ltd. AII rights reserved.

引用

页码：215 / 221

页数：7

共 50 条

[1] On time series data and optimal parameters
Rasmussen, R
OMEGA-INTERNATIONAL JOURNAL OF MANAGEMENT SCIENCE, 2004, 32 (02): : 111 - 120
[2] Time Series Data Modeling and Application
Gao, He
Cai, Xiao-li
Fei, Yu
19th International Conference on Industrial Engineering and Engineering Management: Management System Innovation, 2013, : 1095 - 1101
[3] Using and Exploring Hierarchical Data in Spreadsheets
Chang, Kerry Shih-Ping
Myers, Brad A.
34TH ANNUAL CHI CONFERENCE ON HUMAN FACTORS IN COMPUTING SYSTEMS, CHI 2016, 2016, : 2497 - 2507
[4] Modeling the Autoscaling Operations in Cloud with Time Series Data
Khan, Mehran N. A. H.
Liu, Yan
Alipour, Hanieh
Singh, Samneet
2015 IEEE 34TH SYMPOSIUM ON RELIABLE DISTRIBUTED SYSTEMS WORKSHOP (SRDSW), 2015, : 7 - 12
[5] Bivariate time series modeling of financial count data
Quoreshi, A. M. M. Shahiduzzaman
COMMUNICATIONS IN STATISTICS-THEORY AND METHODS, 2006, 35 (07) : 1343 - 1358
[6] From spreadsheets to sugar content modeling: A data mining approach
Gravina de Oliveira, Monique Pires
Bocca, Felipe Ferreira
Antunes Rodrigues, Luiz Henrique
COMPUTERS AND ELECTRONICS IN AGRICULTURE, 2017, 132 : 14 - 20
[7] Data acquisition and real-time control using spreadsheets: Interfacing Excel with external hardware
Aliane, Nourdine
ISA TRANSACTIONS, 2010, 49 (03) : 264 - 269
[8] Extended statistical downscaling model using data mining methods for modeling hydrologic time series
Shi, Yuqing
Zhu, Yuelong
Journal of Computational and Theoretical Nanoscience, 2015, 12 (12) : 5081 - 5088
[9] Sunspots data analysis using time series
Shaikh, Yusuf H.
Khan, A. R.
Iqbal, M. I.
Behere, S. H.
Bagare, S. P.
FRACTALS-COMPLEX GEOMETRY PATTERNS AND SCALING IN NATURE AND SOCIETY, 2008, 16 (03) : 259 - 265
[10] Modeling time series data with deep Fourier neural networks
Gashler, Michael S.
Ashmore, Stephen C.
NEUROCOMPUTING, 2016, 188 : 3 - 11

← 1 2 3 4 5 →