quick excel question: Is there a way to get the trend line equation froma set of data without actually plotting it?

[LordSnailz]

I have fairly large data set and I want to find the slope and intercept of over 100 different series.

I know you can add a trend line to a chart but then I would have do it for each series. Is there a way to have excel return the equation(slope and intercept and R value) through a formula and copy that formula for all 100 series?


---------------------------------------------------------
tTe interception location is in a different forums

Senior Anandtech Moderator
Common Courtesy

 

[jamesave]

you may need to run VBA to capture it.

Here is one thread that can be helpful:
http://www.mrexcel.com/forum/showthread.php?t=769

 

[jamesave]

Another quick search show that you can actually run it without the chart. There are some functions that you can use to find the gradient and intercept

http://support.microsoft.com/d...?scid=kb;EN-US;q103839

 

[mayest]

Wow, you guys are missing the obvious. Use the Slope(), Intercept(), and RSQ() functions.