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

MathGroup Archive 2011

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

Search the Archive

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




  • Prev by Date: Replace in an elegant way
  • Next by Date: Re: 2D Plot for a face of a 3D plot box?
  • Previous by thread: Re: Replace in an elegant way
  • Next by thread: Re: Math for Trendlines