#1   Report Post  
AndreasN
 
Posts: n/a
Default 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   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


  #3   Report Post  
AndreasN
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 04:42 AM
trend line does not appear JB Charts and Charting in Excel 1 January 26th 05 08:24 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM
Macro - Skipping a line PaulPoll Excel Worksheet Functions 4 December 21st 04 12:43 AM
Trend Lines (or Linest?) Martinaire Excel Worksheet Functions 2 November 26th 04 06:08 PM


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"