summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-07-26 17:33:33 -0300
committerDavid Tardon <dtardon@redhat.com>2014-07-27 08:15:52 +0000
commit119c3b054da571974cb9d37acc908b9bd216fc4a (patch)
treea7ff8eab9ebb6a686326754da93dc954856d544f
parent54d171d06783a9ec286e82aa6150c3fc1b230d5f (diff)
Fix fdo#80445, help pages for VAR functions
VAR.P and VAR.S Change-Id: I6c7204c425678810b6383c59f3c6d2e791c26977 Reviewed-on: https://gerrit.libreoffice.org/10560 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
-rw-r--r--source/text/scalc/01/04060185.xhp27
1 files changed, 27 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 1c0db0c61d..e7f19b6279 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -492,6 +492,20 @@
<item type="input">=VAR(A1:A50)</item>
</paragraph>
</section>
+<section id="vardots">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2953828">
+ <bookmark_value>VAR.S function</bookmark_value>
+ <bookmark_value>variances</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_S" id="bm_id2954898" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2953828" role="heading" level="2" l10n="U" oldref="128">VAR.S</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2959165" role="paragraph" l10n="U" oldref="129"><ahelp hid="HID_FUNC_VAR_S">Estimates the variance based on a sample.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2954286" role="heading" level="3" l10n="U" oldref="130">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953054" role="code" l10n="U" oldref="131">VAR.S(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948938" role="paragraph" l10n="CHG" oldref="132"><emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2947233" role="heading" level="3" l10n="U" oldref="133">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953575" role="paragraph" l10n="U" oldref="134"><item type="input">=VAR.S(A1:A50)</item></paragraph>
+</section>
<section id="vara">
<bookmark xml-lang="en-US" branch="index" id="bm_id3151045"><bookmark_value>VARA function</bookmark_value>
</bookmark>
@@ -528,6 +542,19 @@
<item type="input">=VARP(A1:A50)</item>
</paragraph>
</section>
+<section id="vardotp">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2966441">
+ <bookmark_value>VAR.P function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_P_MS" id="bm_id2952359" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2966441" role="heading" level="2" l10n="U" oldref="136">VAR.P</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2959199" role="paragraph" l10n="U" oldref="137"><ahelp hid="HID_FUNC_VAR_P_MS">Calculates a variance based on the entire population.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2950706" role="heading" level="3" l10n="U" oldref="138">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2947282" role="code" l10n="U" oldref="139">VAR.P(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949793" role="paragraph" l10n="CHG" oldref="140"><emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2952939" role="heading" level="3" l10n="U" oldref="141">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953385" role="paragraph" l10n="U" oldref="142"><item type="input">=VAR.P(A1:A50)</item></paragraph>
+</section>
<section id="varpa">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value>
</bookmark>