software

In regression analysis the gradient is used for further analysis. By hiding
values (coloumns) the number of points in the trend analysis varies and the
gradient changes. How can the gradient values be transferred to a cell and as
such be used in further analysis / equations ?

quot;nygaardquot; gt; wrote in message
...
gt; In regression analysis the gradient is used for further analysis. By
gt; hiding
gt; values (coloumns) the number of points in the trend analysis varies and
gt; the
gt; gradient changes. How can the gradient values be transferred to a cell and
gt; as
gt; such be used in further analysis / equations ?

Assuming that you are using a linear trend line, use the LINEST() function.
--
David Biddulph
For linear fits you can use (SLOPE and INTERCEPT) or LINEST ; see Help
For polynomials and others, use LINEST; see
www.stfx.ca/people/bliengme/E...Polynomial.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;nygaardquot; gt; wrote in message
...
gt; In regression analysis the gradient is used for further analysis. By
gt; hiding
gt; values (coloumns) the number of points in the trend analysis varies and
gt; the
gt; gradient changes. How can the gradient values be transferred to a cell and
gt; as
gt; such be used in further analysis / equations ?
Thanks for the answer, however my challenge is to have a 'dynamic'
regression, meaning that if I would like to omit some data points (which I do
by the 'hide' function) I get a new slope on the plot from the trendline
function. How can I get hold of this new slope to be used in further
calculations ? (Or is it possible to have the slope function dynamic, meaning
that the hided values are omitted from the 'x and y's ?

Thanks in advance

Regards
Ole Nygaard

quot;David Biddulphquot; wrote:

gt; quot;nygaardquot; gt; wrote in message
gt; ...
gt; gt; In regression analysis the gradient is used for further analysis. By
gt; gt; hiding
gt; gt; values (coloumns) the number of points in the trend analysis varies and
gt; gt; the
gt; gt; gradient changes. How can the gradient values be transferred to a cell and
gt; gt; as
gt; gt; such be used in further analysis / equations ?
gt;
gt; Assuming that you are using a linear trend line, use the LINEST() function.
gt; --
gt; David Biddulph
gt;
gt;
gt;