Thread: Trend line
View Single Post
  #2   Report Post  
Michael R Middleton
 
Posts: n/a
Default

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