Re: Access coefficients in trendline
- From: Andreas Guelzow <aguelzow pyrshep ca>
- To: gnumeric-list gnome org
- Cc: Mike Simms <mesimms gmail com>
- Subject: Re: Access coefficients in trendline
- Date: Wed, 07 Nov 2012 21:23:57 -0700
On Wed, 2012-11-07 at 02:18 -0800, Mike Simms wrote:
Hi Jean,
OK, we're getting somewhere now, I have a created the columns C and D as you
say, and I've typed in
=linest(a1:a100;b1:d100,TRUE)
and pressed Ctrl+Shift+Enter and the indices {1,1}[0,0] appear. Lo and
behold the value is the coefficent of the x^3 term which I confirm by making
a chart of the data and adding a trendline and equation.
But when I add the same linest expression into the next cells in the row,
the same indices appear and the same value appears, when they should be
changing, no?. I am pressing Ctrl+Shift+Enter each time. What have I missed?
You have to enter a single array formaula:
select a range that has several rows: so you have a probably blue region
with the top left cell white and typing appears there.
Then enter your formula and type ctrl-shift-enter.
The formula should appear in all cells of the range with the apropriate
indices.
Andreas
--
Andreas Guelzow <aguelzow pyrshep ca>
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]