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