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>

1 files changed, 47 insertions, 0 deletions

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>