summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSteve Fanning <stevemfanning@yahoo.co.uk>2020-05-27 17:18:23 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2020-06-08 18:14:08 +0200
commitc4a6449f8edfbdcb6b19c7b4deea31467423e072 (patch)
tree99d6aed8aabbb054792c669dbee123f220241ae5
parent(IF func) Minor correction to syntax statement (diff)
downloadhelp-c4a6449f8edfbdcb6b19c7b4deea31467423e072.zip
help-c4a6449f8edfbdcb6b19c7b4deea31467423e072.tar.gz
(04060107.xhp) Update syntax section for four functions to include square brackets, indicating optional parameters.
Change-Id: Ie1b2a487be11c9e6b2ed17eae8e0b067510c8b61 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94953 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 1a010a1c18a0d992afd907efc201f04f799f9c4a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95713 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060107.xhp8
1 files changed, 4 insertions, 4 deletions
diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp
index ec0f868..185868b 100644
--- a/source/text/scalc/01/04060107.xhp
+++ b/source/text/scalc/01/04060107.xhp
@@ -693,7 +693,7 @@
<h2 id="hd_id3109846">LINEST</h2>
<paragraph id="par_id3144733" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RGP">Returns a table of statistics for a straight line that best fits a data set.</ahelp><comment>changed based on https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_LINEST_function (issue 76142)</comment></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3152839" role="code" xml-lang="en-US">LINEST(data_Y; data_X; linearType; stats)</paragraph>
+ <paragraph id="par_id3152839" role="code" xml-lang="en-US">LINEST(data_Y [; data_X [; linearType [; stats]]])</paragraph>
<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>
@@ -965,7 +965,7 @@
<h2 id="hd_id3146009">LOGEST</h2>
<paragraph id="par_id3146037" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RKP">This function calculates the adjustment of the entered data as an exponential regression curve (y=b*m^x).</ahelp><comment>UFI: see http://support.microsoft.com/default.aspx?kbid=828528&amp;product=xl2003 for bug #i31051#</comment></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3163123" role="code" xml-lang="en-US">LOGEST(DataY; DataX; FunctionType; Stats)</paragraph>
+ <paragraph id="par_id3163123" role="code" xml-lang="en-US">LOGEST(DataY [; DataX [; FunctionType [; Stats]]])</paragraph>
<paragraph id="par_id3163137" role="paragraph" xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph>
<paragraph id="par_id3163155" role="paragraph" xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data array.</paragraph>
<paragraph id="par_id3163174" role="paragraph" xml-lang="en-US"><emph>FunctionType</emph> (optional). If Function_Type = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated.</paragraph>
@@ -1112,7 +1112,7 @@
<h2 id="hd_id3166062">TREND</h2>
<paragraph id="par_id3166091" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TREND">Returns values along a linear trend.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3166122" role="code" xml-lang="en-US">TREND(DataY; DataX; NewDataX; LinearType)</paragraph>
+ <paragraph id="par_id3166122" role="code" xml-lang="en-US">TREND(DataY [; DataX [; NewDataX [; LinearType]]])</paragraph>
<paragraph id="par_id3166137" role="paragraph" xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph>
<paragraph id="par_id3166156" role="paragraph" xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data array.</paragraph>
<paragraph id="par_id3166176" role="paragraph" xml-lang="en-US"><emph>NewDataX</emph> (optional) represents the array of the X data, which are used for recalculating values.</paragraph>
@@ -1131,7 +1131,7 @@
<h2 id="hd_id3166317">GROWTH</h2>
<paragraph id="par_id3166346" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_VARIATION">Calculates the points of an exponential trend in an array.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3166377" role="code" xml-lang="en-US">GROWTH(DataY; DataX; NewDataX; FunctionType)</paragraph>
+ <paragraph id="par_id3166377" role="code" xml-lang="en-US">GROWTH(DataY [; DataX [; NewDataX [; FunctionType]]])</paragraph>
<paragraph id="par_id3166392" role="paragraph" xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph>
<paragraph id="par_id3166411" role="paragraph" xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data array.</paragraph>
<paragraph id="par_id3173797" role="paragraph" xml-lang="en-US"><emph>NewDataX</emph> (optional) represents the X data array, in which the values are recalculated.</paragraph>