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

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