Re: [office-formula] OFFICE-1185 LINEST

[Eike Rathke <erack@sun.com>]

Hi Andreas,

On Monday, 2010-04-26 12:29:12 -0600, Andreas J. Guelzow wrote:

> What does "number of variables of the regression
> analysis including the intercept" mean? 
> 
> The intercept is not a variable. It doesn't seem likely that the degrees
> of freedom are independent from whether the intercept is forced to be
> zero or not but the same formulation is used in both cases.

If the intercept is forced to 0 it isn't a variable.

I propose to remove "including the intercept" from both formulas and:

For Const=TRUE() change to df=n-k-1

For Const=FALSE() change to df=n-k

In both cases n is the number of data points and k is the number of
columns of knownX.

Does that sound more likely?

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature