Chart trendline question

[lloydjs]

How can you get the parameters for the equation of a trendline? I need to calculate a specific value using the trendline equation and don't want to ask the operator what the equation is.

 

[67peshawar294]

lloyd,
try the following link and see if it gives you the info you need.

http://www.cba.nau.edu/facstaff/ozmun-j/BA 301 PPTs/Sales Forecasting F02.ppt

Click on the presentation to advance it.
jp

 

[lloydjs]

Thanks but the description I saw there was for calculating linear regresssion. My trendlines are polynomic (predicts where proper focus is). I was hoping for a way of reading the parameters for the polynomial that Access/Chart calculated so I could let Access/Chart do their job and use those results so I could calculate the values I need without having to do the regression myself. It may just be easier to do that though.

Thanks