problem with REGLINP func.

  • Thread starter Thread starter Marcin Kowalewski
  • Start date Start date
M

Marcin Kowalewski

Hi
REGLINP func (linear regresion function) should return two values:
m and b
in my case REGLINP return (display )only one value:m
how to get second value: b

please help me
 
REGLINP func (linear regresion function) should return two values:
m and b
in my case REGLINP return (display )only one value:m
how to get second value: b
Click to expand...

There is no built-in REGLINP function in English versions of Excel, so I guess
this is the Polish equivalent of the English LINEST function. If so, then you
must select a multiple area range and enter an *array* formula calling REGLINP
into that multiple cell range. Alternatively, INDEX(REGLINP(..),1,1) should give
the slope, and INDEX(REGLINP(..),1,2) should give the intercept.
 
Back
Top