Fix fdo#80436 Help pages for MODE functions

MODE.SNGL, MODE.MULT, Z.TEST, NEGBINOM.DIST

Change-Id: I0e6ad33f76a09c9d4af7b8146d07eb4f1df86313
Reviewed-on: https://gerrit.libreoffice.org/10411
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>

2 files changed, 61 insertions, 0 deletions

diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp
index 3d595d033b..c3b2767b07 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -333,6 +333,20 @@
             <emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph>
 	 <paragraph xml-lang="en-US" id="par_id0305200911372999" role="paragraph" l10n="NEW">See also the <link href="http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function">Wiki page</link>.</paragraph>
       </section>
+<section id="zdottest">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2953216"><bookmark_value>Z.TEST function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_Z_TEST_MS" id="bm_id2947569" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2953216" role="heading" level="2" l10n="U" oldref="103">Z.TEST</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950758" role="paragraph" l10n="CHG" oldref="104"><ahelp hid="HID_FUNC_Z_TEST_MS">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2950872" role="heading" level="3" l10n="U" oldref="105">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953274" role="code" l10n="CHG" oldref="106">Z.TEST(Data; mu; Sigma)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2956109" role="paragraph" l10n="CHG" oldref="107"><emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2949977" role="paragraph" l10n="CHG" oldref="108"><emph>mu</emph> is the known mean of the population.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954740" role="paragraph" l10n="CHG" oldref="109"><emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2949539" role="heading" level="3" l10n="U" oldref="58">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948770" role="paragraph" l10n="U" oldref="59"><item type="input">=Z.TEST(A2:A20; 9; 2)</item> returns the result of a z-test on a sample A2:A20 drawn from a population with known mean 9 and known standard deviation 2.</paragraph>
+</section>
       <section id="harmean">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value>
          <bookmark_value>means;harmonic</bookmark_value>
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp
index 12d3201f74..1cd71a220c 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -184,6 +184,35 @@ oldref="48">Example</paragraph>
 <item type="input">=MODE(A1:A50)</item>
 </paragraph>
 </section>
+
+<section id="modedotsngl">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2953933"><bookmark_value>MODE.SNGL function</bookmark_value>
+<bookmark_value>most common value</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MS" id="bm_id2949253" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2953933" role="heading" level="2" l10n="U" oldref="43">MODE.SNGL</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953085" role="paragraph" l10n="U" oldref="44"><ahelp hid="HID_FUNC_MODAL_VALUE_MS">Returns the most frequently occurring, or repetitive, value in an array or range of data.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2953003" role="heading" level="3" l10n="U" oldref="45">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2955950" role="code" l10n="U" oldref="46">MODE.SNGL(Number1; Number2; ...Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950337" role="paragraph" l10n="CHG" oldref="47"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2963792" role="warning" l10n="CHG" oldref="629">If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2953571" role="heading" level="3" l10n="U" oldref="48">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953733" role="paragraph" l10n="U" oldref="49"><item type="input">=MODE.SNGL(A1:A50)</item></paragraph>
+</section>
+<section id="modedotmult">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2853933"><bookmark_value>MODE.MULT function</bookmark_value>
+<bookmark_value>most common value</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MULTI" id="bm_id2849253" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2853933" role="heading" level="2" l10n="U" oldref="43">MODE.MULT</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853085" role="paragraph" l10n="U" oldref="44"><ahelp hid="HID_FUNC_MODAL_VALUE_MULTI">Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2853003" role="heading" level="3" l10n="U" oldref="45">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2855950" role="code" l10n="U" oldref="46">MODE.MULT(Number1; Number2; ...Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2850337" role="paragraph" l10n="CHG" oldref="47"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2863792" role="warning" l10n="CHG" oldref="629">As the MODE.MULT function returns an array of values, it must be entered as an array formula. If the function is not entered as an array formula, only the first mode is returned, which is the same as using the MODE.SNGL function.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2853571" role="heading" level="3" l10n="U" oldref="48">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853733" role="paragraph" l10n="U" oldref="49"><item type="input">=MODE.MULT(A1:A50)</item></paragraph>
+</section>
 <section id="negbinomdist">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149879"><bookmark_value>NEGBINOMDIST function</bookmark_value>
 <bookmark_value>negative binomial distribution</bookmark_value>
@@ -203,6 +232,24 @@ oldref="58">Example</paragraph>
 <paragraph xml-lang="en-US" id="par_id3148770" role="paragraph" l10n="U" oldref="59">
 <item type="input">=NEGBINOMDIST(1;1;0.5)</item> returns 0.25.</paragraph>
 </section>
+<section id="negbinomdotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2949879"><bookmark_value>NEGBINOM.DIST function</bookmark_value>
+<bookmark_value>negative binomial distribution</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMDIST_MS" id="bm_id2959135" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2949879" role="heading" level="2" l10n="U" oldref="51">NEGBINOM.DIST</paragraph>
+<paragraph xml-lang="en-US" id="par_id2955437" role="paragraph" l10n="U" oldref="52"><ahelp hid="HID_FUNC_NEGBINOMDIST_MS">Returns the negative binomial density or distribution function.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2945351" role="heading" level="3" l10n="U"
+oldref="53">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950935" role="code" l10n="U" oldref="54">NEGBINOM.DIST(X; R; SP; Cumulative)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953044" role="paragraph" l10n="U" oldref="55"><emph>X</emph> represents the value returned for unsuccessful tests.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2951018" role="paragraph" l10n="U" oldref="56"><emph>R</emph> represents the value returned for successful tests.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948878" role="paragraph" l10n="U" oldref="57"><emph>SP</emph> is the probability of the success of an attempt.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948879" role="paragraph" l10n="U" oldref="57"><emph>Cumulative</emph> = 0 calculates the density function, <emph>Cumulative</emph> = 1 calculates the distribution.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2949539" role="heading" level="3" l10n="U" oldref="58">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948770" role="paragraph" l10n="U" oldref="59"><item type="input">=NEGBINOM.DIST(1;1;0.5;0)</item> returns 0.25.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948771" role="paragraph" l10n="U" oldref="59"><item type="input">=NEGBINOM.DIST(1;1;0.5;1)</item> returns 0.75.</paragraph>
+</section>
 <section id="norminv">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3155516"><bookmark_value>NORMINV function</bookmark_value>
 <bookmark_value>normal distribution;inverse of</bookmark_value>