diff options
| -rw-r--r-- | source/text/scalc/01/04060107.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp index 98a9a95724..3a8e01487d 100644 --- a/source/text/scalc/01/04060107.xhp +++ b/source/text/scalc/01/04060107.xhp @@ -654,8 +654,8 @@ <paragraph id="par_id3152853" role="paragraph" xml-lang="en-US"><emph>data_Y</emph> is a single row or column range specifying the y coordinates in a set of data points.</paragraph> <paragraph id="par_id3154428" role="paragraph" xml-lang="en-US"><emph>data_X</emph> is a corresponding single row or column range specifying the x coordinates. If <emph>data_X</emph> is omitted it defaults to <item type="literal">1, 2, 3, ..., n</item>. If there is more than one set of variables <emph>data_X</emph> may be a range with corresponding multiple rows or columns.</paragraph> <paragraph id="par_id0811200804502119" role="paragraph" xml-lang="en-US">LINEST finds a straight line <item type="literal">y = a + bx</item> that best fits the data, using linear regression (the "least squares" method). With more than one set of variables the straight line is of the form <item type="literal">y = a + b1x1 + b2x2 ... + bnxn</item>.</paragraph> -<paragraph id="par_id3154448" role="paragraph" xml-lang="en-US">if<emph>linearType</emph> is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, <emph>linearType</emph> defaults to TRUE (the line is not forced through the origin).</paragraph> -<paragraph id="par_id3154142" role="paragraph" xml-lang="en-US">if<emph>stats</emph> is omitted or FALSE only the top line of the statistics table is returned. If TRUE the entire table is returned.</paragraph> +<paragraph id="par_id3154448" role="paragraph" xml-lang="en-US">If <emph>linearType</emph> is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, <emph>linearType</emph> defaults to TRUE (the line is not forced through the origin).</paragraph> +<paragraph id="par_id3154142" role="paragraph" xml-lang="en-US">If <emph>stats</emph> is omitted or FALSE only the top line of the statistics table is returned. If TRUE the entire table is returned.</paragraph> <paragraph id="par_id0811200804502261" role="paragraph" xml-lang="en-US">LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return rather than just Return).</paragraph> <paragraph id="par_idN11416" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> |