one of the options on the graph is to display the equation of the trendline.
You need to format the equation to show many decimal places of precision.
Once you have the constants/coefficients associated with the terms of the
equation, you can calculate the predicted points.



--
Regards,
Tom Ogilvy

"David" wrote in message
...
Hi Group,
This is a little difficult to explain, but the underlying data is simple,
so
please bear with me. I have Dates and Closings for the Dow Jones
Industrial.
Similar to below:
Date Adj. Close*
01/03/05 10729.43
12/27/04 10776.13
12/20/04 10661.6
12/13/04 10638.32
The above is easy to graph and I have automated the process, which
includes
a 6th Order Polynomial Trend line added to the graph. What I am trying to
do
is find the data points associated with the 6th Order Polynomial Trend
line.
It has simply been just too long since I have done this type of
statistics. I
believe it may be necessary to create a new table to find these data
points,
which I am willing to do. I can calculate the sample mean, number of
sample
variables, sample variance, sample standard deviation, etc., but it has
just
been too many years to bring the necessary statistical expertise to arrive
at
the data points. I am trying to get a table that looks something like
this:
Date Adj. Close* Trend
01/03/05 10729.43 10730.25
12/27/04 10776.13 10750.31
12/20/04 10661.6 10765.03
12/13/04 10638.32 10750.00
I have tried using some of the built in functions, but they do not yield
the
same data points that have been graphed by the 6th Order Polynomial Trend
line. I have tried Trend and Forecast. I created a table many years ago,
which I think calculated the data points, but it has simply been to many
years and I have lost the statistical expertise. Any help would be greatly
appreciated.
--
David