[Date Index] [Thread Index] [Author Index]

Math for Trendlines

• To: mathgroup at smc.vnet.net
• Subject: [mg122869] Math for Trendlines
• From: binabik <pderop at gmail.com>
• Date: Sun, 13 Nov 2011 07:17:48 -0500 (EST)
• Delivered-to: l-mathgroup@mail-archive0.wolfram.com

Hi,

At the moment, I'm working on a series of articles about trend lines
in Business Objects.
The first installment was easy enough :
http://pderop.blogspot.com/2011/11/trendlines-in-business-objects.html

The linear trendline didn't prove to be much of a problem.

For the next item however, I'm going to try get a Logarithmic
trendline into Business Objects. To be able to do that, I need to
perform Linear Regression, which I don't know anything about.

Now I need to calculate something which you can do easily in Excel

=index(linest(A1:A12;B1;B12);1)

But I need to find the math to calculate this stuff by hand.

Can anyone give me a hand with figuring out that particular function ?

it would be most useful.

Kind regards,

PDeRop