If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trend line
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Condensing Text fields into a Memo field - Need to retain line spa | Doc Don Sturgiss | General Discussion | 3 | December 28th, 2004 02:43 AM |
Problem: A border line that I can't get rid of... | Gary Warner | New Users | 2 | December 1st, 2004 11:20 PM |
Column break adds a line | Dano O'D | General Discussion | 2 | November 11th, 2004 10:15 PM |
Columns 'line between' problem | Jim | Page Layout | 4 | June 10th, 2004 04:15 AM |
Plotting a datapoint on an existing Line chart | Tushar Mehta | Charts and Charting | 0 | November 23rd, 2003 01:08 AM |