Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #6423

Math for Trendlines

From binabik <pderop@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Math for Trendlines
Date 2011-11-13 12:18 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j9oci6$17l$1@smc.vnet.net> (permalink)

Show all headers | View raw


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

Back to comp.soft-sys.math.mathematica | Previous | Next — Next in thread | Find similar | Unroll thread


Thread

Math for Trendlines binabik <pderop@gmail.com> - 2011-11-13 12:18 +0000
  Re: Math for Trendlines binabik <pderop@gmail.com> - 2011-11-14 12:10 +0000

csiph-web