diff options
| -rw-r--r-- | source/text/scalc/01/04060185.xhp | 27 |
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> |