[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-comment] ODFF: list of suggestions: LINEST
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]