diff options
| author | Olivier Hallot <ohallot@collabora.co.uk> | 2016-03-08 11:28:49 -0300 |
|---|---|---|
| committer | Caolán McNamara <caolanm@redhat.com> | 2016-03-09 17:10:00 +0000 |
| commit | 9dc3878117e8d2c4e6e6cf09b41fb2e06867a477 (patch) | |
| tree | 4bd9a6f34b85dae4743037658708bae0508ffa3f /source/text/scalc/01/04060185.xhp | |
| parent | 35c3a7c5774b09f974ebd34919c13b3aaa51bd4a (diff) | |
tdf#97021 Help pages for FORECAST.ETS functions
Write help page for FORECAST.ETS.* Calc functions
Change-Id: I4fc3a0f18bb09e033b011206c41bec841e0d01f5
Reviewed-on: https://gerrit.libreoffice.org/23093
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
Diffstat (limited to 'source/text/scalc/01/04060185.xhp')
| -rw-r--r-- | source/text/scalc/01/04060185.xhp | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 7926cbf2a6..bb83598d14 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -133,6 +133,28 @@ <paragraph xml-lang="en-US" id="par_id3157874" role="paragraph" l10n="U" oldref="28"> <item type="input">=FORECAST(50;A1:A50;B1;B50)</item> returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.</paragraph> </section> + <section id="forecastlinear"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3149052"><bookmark_value>regression lines;FORECAST.LINEAR function</bookmark_value> + <bookmark_value>extrapolations</bookmark_value> + <bookmark_value>FORECAST.LINEAR function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_LIN" id="bm_id3146102" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3149052" role="heading" level="2">FORECAST.LINEAR</paragraph> + <paragraph xml-lang="en-US" id="par_id3153291" role="paragraph" l10n="U" oldref="21"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values based on existing x and y values.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3151344" role="heading" level="3" l10n="U" + oldref="22">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3147405" role="code" l10n="U" oldref="23">FORECAST(Value; DataY; DataX)</paragraph> + <paragraph xml-lang="en-US" id="par_id3148744" role="paragraph" l10n="U" oldref="24"> + <emph>Value</emph> is the x value, for which the y value on the linear regression is to be returned.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146326" role="paragraph" l10n="U" oldref="25"> + <emph>DataY</emph> is the array or range of known y's.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150537" role="paragraph" l10n="U" oldref="26"> + <emph>DataX</emph> is the array or range of known x's.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3147417" role="heading" level="3" l10n="U" + oldref="27">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3157875" role="paragraph" l10n="U" oldref="28"> + <item type="input">=FORECAST.LINEAR(50;A1:A50;B1;B50)</item> returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.</paragraph> + </section> <section id="stdev"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149143"><bookmark_value>STDEV function</bookmark_value> <bookmark_value>standard deviations in statistics;based on a sample</bookmark_value> |