Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Good evening,
In Excel 2000: Which is the best trend/ regression type to use in case the x axis represents dates and the y currencies? Thanks in advance. |
#2
![]() |
|||
|
|||
![]()
AndreasN -
In Excel 2000: Which is the best trend/ regression type to use in case the x axis represents dates and the y currencies? < My opinion: There's no single answer to your question. Among other things, the answer depends on the pattern of your data, your knowledge of any underlying phenomena that influence the data, the purpose of the analysis (e.g., explanation of historical data vs. prediction of future values), etc. The best model may even be one that isn't available as a Trendline option, e.g., a lag 1 autoregressive model, or a multivariate model using other related time series data as explanatory variables. - Mike www.mikemiddleton.com |
#3
![]() |
|||
|
|||
![]()
Mike, thank you very much for accurate and responsible reply. Well, the
purpose is prediction but, indeed, what I didn't consider from the first place is that there is not some kind of functional relationship bettween curency values and time. Ï "Michael R Middleton" wrote in message ... AndreasN - In Excel 2000: Which is the best trend/ regression type to use in case the x axis represents dates and the y currencies? < My opinion: There's no single answer to your question. Among other things, the answer depends on the pattern of your data, your knowledge of any underlying phenomena that influence the data, the purpose of the analysis (e.g., explanation of historical data vs. prediction of future values), etc. The best model may even be one that isn't available as a Trendline option, e.g., a lag 1 autoregressive model, or a multivariate model using other related time series data as explanatory variables. - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line and Column Graph | Charts and Charting in Excel | |||
trend line does not appear | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions | |||
Trend Lines (or Linest?) | Excel Worksheet Functions |