MathGroup Archive 2011

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

Search the Archive

Re: Math for Trendlines

  • To: mathgroup at
  • Subject: [mg122884] Re: Math for Trendlines
  • From: binabik <pderop at>
  • Date: Mon, 14 Nov 2011 07:07:28 -0500 (EST)
  • Delivered-to:
  • References: <j9oci6$17l$>

On 13 nov, 13:18, binabik <pde... at> 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 :
> 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.


  • 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?)