logo
CanyamAI summaries for academic research
language
MobileMobile
  • Phone FeatureWeChat Mini Program
EnglishEnglish
noticeNotice
BlogBlog
delete
arrow
Return

On modeling time series data using spreadsheets

delete2000-04-01
delete11
PRE
AI
C
Cliff T. Ragsdale *
P
Plane, DR
DOI：10.1016/S0305-0483(99)00038-9delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
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.
Keywords:
time series
regression
spreadsheets
education
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

O
Omega-International Journal of Management Science
IF:
7.2
Papers:
3.7K
Citations:
1.4W

Organization

No organization information available