Re: [office-formula] OFFICE-1185 LINEST

["Andreas J. Guelzow" <andreas.guelzow@concordia.ab.ca>]

On Tue, 2010-04-27 at 06:56 -0600, Eike Rathke wrote:
> 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?

That is what I would expect.

Thanks

Andreas