Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2011

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

Search the Archive

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



  • Prev by Date: Re: how to plot new data points to pre-existing figure
  • Next by Date: Re: Problem:a texture on only one face of a Polyhedron
  • Previous by thread: Math for Trendlines
  • Next by thread: Strange Probability function behavior (Bug?)