Generate a graphical formula from a column of data
 

If I have a set of data, is there any way I can generate a formula which
roughly matches the plot of the data set? I know I can generate a trend line
on a chart but is there a way of finding out the formula for this trendline,
so that I could reproduce it without the origiinal data perhaps?

Hope I'm making myself clear. Many thanks in advance.

Generate a graphical formula from a column of data
 

Insure that the Analysis ToolPak has been loaded. If your data is linear,
then use LINEST() to derive the formula
--
Gary's Student


"rmellison" wrote:

If I have a set of data, is there any way I can generate a formula which
roughly matches the plot of the data set? I know I can generate a trend line
on a chart but is there a way of finding out the formula for this trendline,
so that I could reproduce it without the origiinal data perhaps?

Hope I'm making myself clear. Many thanks in advance.

Generate a graphical formula from a column of data
 

Hi,

If all you need is an equation for the trendline, you could do the following:

When you use 'trendline' to generate a fit to the plot of the data, go to
"Options" and check "Display Equation of Chart". This would show the
trendline equation on the plot. Note down the equation and you cn use it to
calculate and reproduce the trendline or predict the y-value for any x-value.

Regards,
B. R. Ramachandran

"rmellison" wrote:

If I have a set of data, is there any way I can generate a formula which
roughly matches the plot of the data set? I know I can generate a trend line
on a chart but is there a way of finding out the formula for this trendline,
so that I could reproduce it without the origiinal data perhaps?

Hope I'm making myself clear. Many thanks in advance.