Re: Math for Trendlines
- To: mathgroup at smc.vnet.net
- Subject: [mg122884] Re: Math for Trendlines
- From: binabik <pderop at gmail.com>
- Date: Mon, 14 Nov 2011 07:07:28 -0500 (EST)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
- References: <j9oci6$17l$1@smc.vnet.net>
On 13 nov, 13:18, binabik <pde... at gmail.com> wrote: > 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 Figured it out myself. The result will be on my site. PDeRop