View Single Post
  #4   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

buragotch wrote:
Thanks for the info. However, I would like to find a way to make the LINEST
function return all its values into a single column, rather than an array, so
i can have multiple columns with all the LINEST values (eg intercept,
coefficients, r-sqaure, etc). if it use the TRANSPOSE(LINEST(...)) function,
it only returns the intercept and coefficient values. but none of the others.
there must be a way to do this.

[...]

Did you try to fill in...

LINEST(known_y's,known_x's,const,stats)

as, for example:

=LINEST(F2:F20,G2:G20,,TRUE)

which you enter say in cell A2, select the rectangular area of A2:B6,
then confirm the formula with control+shift+enter?

In article ,
says...

i need to run repeated regressions on a large set of data, and put the
resulting values in a table for each column of data in my set. however, i
don't want to repeat the regression function in the data analysis toolpack
and cut/paste the relevant data into my table, 50 times.
anyone know how to do this