diff options
author | Steve Fanning <stevemfanning.wh@gmail.com> | 2020-03-26 10:47:29 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-26 14:58:27 +0100 |
commit | e22ee2eda6415961d879f58407bf59604e46dbd3 (patch) | |
tree | 9456407e74c9148969fae92acb158880be3884b5 /source/text/scalc/01/04060185.xhp | |
parent | tdf#126923 Add guide for subtotals tool (diff) | |
download | help-e22ee2eda6415961d879f58407bf59604e46dbd3.tar.gz help-e22ee2eda6415961d879f58407bf59604e46dbd3.zip |
tdf#131361 Adjust number of function parameters (3)
Fix for STDEV, STDEV.P, STDEV.S, STDEVA, STDEVP, STDEVPA,
VAR, VAR.P, VAR.S, VARA, VARP, VARPA,
AND, OR, XOR, SUMPRODUCT, CONCATENATE
Change-Id: I869f6d7fc687e645b9ee8c0ca36ff690c4108db3
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91103
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060185.xhp')
-rw-r--r-- | source/text/scalc/01/04060185.xhp | 71 |
1 files changed, 37 insertions, 34 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 056953c3f7..38a0157d2d 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -158,12 +158,11 @@ <h2 id="hd_id3149143">STDEV</h2> <paragraph xml-lang="en-US" id="par_id3146888" role="paragraph"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation based on a sample.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3149946" role="code">STDEV(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3157904" role="paragraph"> - <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="par_id3149946" role="code">STDEV(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id211585163957345" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3149434" role="paragraph"> - <item type="input">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149434" role="paragraph"><input>=STDEV(A1:A50)</input> returns the estimated standard deviation based on the data referenced.</paragraph> </section> <section id="stdeva"> <bookmark xml-lang="en-US" branch="index" id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value> @@ -172,9 +171,10 @@ <h2 id="hd_id3144745">STDEVA</h2> <paragraph xml-lang="en-US" id="par_id3151234" role="paragraph"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation of an estimation based on a sample.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3147422" role="code">STDEVA(Value1; Value2; ...; Value30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3154547" role="paragraph"> - <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> + + <paragraph xml-lang="en-US" id="par_id3147422" role="code">STDEVA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id981585163977014" role="paragraph" xml-lang="en-US">The parameters should specify at least two values. Text has the value 0.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3148581" role="paragraph"> <item type="input">=STDEVA(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph> @@ -187,9 +187,9 @@ <h2 id="hd_id3149734">STDEVP</h2> <paragraph xml-lang="en-US" id="par_id3149187" role="paragraph"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire population.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3154392" role="code">STDEVP(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3155261" role="paragraph"> - <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph> + + <paragraph xml-lang="en-US" id="par_id3154392" role="code">STDEVP(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153933" role="paragraph"> <item type="input">=STDEVP(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> @@ -204,8 +204,9 @@ <paragraph xml-lang="en-US" id="par_id2949187" role="paragraph"><ahelp hid="HID_FUNC_ST_DEV_P_MS">Calculates the standard deviation based on the entire population.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id2954392" role="code">STDEV.P(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id2955261" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph> + + <paragraph xml-lang="en-US" id="par_id2954392" role="code">STDEV.P(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953933" role="paragraph"><item type="input">=STDEV.P(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> </section> @@ -219,8 +220,10 @@ <paragraph xml-lang="en-US" id="par_id2849187" role="paragraph"><ahelp hid="HID_FUNC_ST_DEV_S">Calculates the standard deviation based on sample of the population.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id2854392" role="code">STDEV.S(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id2855261" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample of the population.</paragraph> + + <paragraph xml-lang="en-US" id="par_id2854392" role="code">STDEV.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id671585163972431" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2853933" role="paragraph"><item type="input">=STDEV.S(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> </section> @@ -231,9 +234,9 @@ <h2 id="hd_id3154522">STDEVPA</h2> <paragraph xml-lang="en-US" id="par_id3149549" role="paragraph"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard deviation based on the entire population.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3146851" role="code">STDEVPA(Value1; Value2; ...; Value30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3153109" role="paragraph"> - <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population. Text has the value 0.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146851" role="code">STDEVPA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id961585163990543" role="paragraph" xml-lang="en-US">Text has the value 0.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3145163" role="paragraph"> <item type="input">=STDEVPA(A1:A50)</item> returns the standard deviation of the data referenced.</paragraph> @@ -538,9 +541,10 @@ <h2 id="hd_id3153828">VAR</h2> <paragraph xml-lang="en-US" id="par_id3159165" role="paragraph"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3153054" role="code">VAR(Number1 ; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3148938" role="paragraph"> - <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="par_id3153054" role="code">VAR(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id721585215582420" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153575" role="paragraph"> <item type="input">=VAR(A1:A50)</item> @@ -556,8 +560,9 @@ <paragraph xml-lang="en-US" id="par_id2959165" role="paragraph"><ahelp hid="HID_FUNC_VAR_S">Estimates the variance based on a sample.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id2953054" role="code">VAR.S(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id2948938" role="paragraph"><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="par_id2953054" role="code">VAR.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id891585215590756" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953575" role="paragraph"><item type="input">=VAR.S(A1:A50)</item></paragraph> </section> @@ -568,9 +573,9 @@ <h2 id="hd_id3151045">VARA</h2> <paragraph xml-lang="en-US" id="par_id3155122" role="paragraph"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a sample. The value of text is 0.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3149999" role="code">VARA(Value1; Value2; ...; Value30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3158421" role="paragraph"> - <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149999" role="code">VARA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> + <paragraph id="par_id451585215586628" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3154279" role="paragraph"> <item type="input">=VARA(A1:A50)</item> @@ -583,9 +588,8 @@ <h2 id="hd_id3166441">VARP</h2> <paragraph xml-lang="en-US" id="par_id3159199" role="paragraph"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire population.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3147282" role="code">VARP(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3149793" role="paragraph"> - <emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147282" role="code">VARP(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3153385" role="paragraph"> <item type="input">=VARP(A1:A50)</item> @@ -600,8 +604,8 @@ <paragraph xml-lang="en-US" id="par_id2959199" role="paragraph"><ahelp hid="HID_FUNC_VAR_P_MS">Calculates a variance based on the entire population.</ahelp></paragraph> <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(Number1; Number2; ...; Number30)</paragraph> - <paragraph xml-lang="en-US" id="par_id2949793" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph> + <paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953385" role="paragraph"><item type="input">=VAR.P(A1:A50)</item></paragraph> </section> @@ -612,9 +616,8 @@ <h2 id="hd_id3153688">VARPA</h2> <paragraph xml-lang="en-US" id="par_id3149109" role="paragraph"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based on the entire population. The value of text is 0.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3149967" role="code">VARPA(Value1; Value2; ...; Value30)</paragraph> - <paragraph xml-lang="en-US" id="par_id3149920" role="paragraph"> - <emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149967" role="code">VARPA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3156203" role="paragraph"> <item type="input">=VARPA(A1:A50)</item> |