OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

# office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-comment] ODFF: list of suggestions: LINEST

• From: "David King" <openoffice@drking.plus.com>
• To: office-comment@lists.oasis-open.org
• Date: Mon, 22 Dec 2008 08:26:35 -0000

```Hi Eike

> > LINEST
> > needs a rewrite into clear English - it's actually wrong about
> > multiple x values as well
>
> Could you provide some text?

Wanted to avoid this one ;)

LINEST
Summary: Returns a table of statistics for a straight line that
best fits a data set. It must be entered as an array formula, in
order to return an array.

Returns: Array

Syntax: LINEST( Reference|Array knownY [ ; [ Reference|Array
knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ]
] ] )

[NB Reference|Array not Array for knownY,X  I think - is that
right?]

Semantics:
LINEST finds a straight line y = a + bx that best fits the points
in the data set, using linear regression (the "least squares"
method). With more than one set of variables the straight line is
of the form y = a + b1x1 + b2x2 ... + bnxn.

knownY: a single row or column range/array specifying the y
coordinates of the points in the data set.

knownX: the x coordinates corresponding to knownY, either a
single row or column range/array, or (when there is more than one
set of variables) a range/array with corresponding multiple rows
or columns. If knownX is omitted or given as an empty parameter
(two consecutive ;; semicolons), the x coordinates are taken as
1, 2, 3, ... n (n=COUNT(knownY)). If knownX is given as a single
value, it applies to all data points.

Const: If set to FALSE(), the constant a is set to zero, forcing
the line through the origin; otherwise a value for a is
calculated.

Stats: If set to FALSE(), only the top row of the table of
statistics is returned; otherwise the entire table is returned as
follows:

etc [good stuff about the calculations]

=========
I prefer this to the other (minor) edit I offered for LINEST

David

```

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]