Fix fdo#80432. Help entries for NORM functions

Write help pages for LOGNORM.DIST, LOGNORM.INV, NORM.DIST, NORM.INV, NORM.S.DIST and NORM.S.INV spreadsheet functions

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

3 files changed, 116 insertions, 2 deletions

diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp
index 3dc2ffdeb5..0e617b9019 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -164,7 +164,27 @@
 <emph>StDev</emph> is the standard deviation of the standard logarithmic distribution.</paragraph>
 <paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph>
 <paragraph role="paragraph" id="par_id3155623" xml-lang="en-US" l10n="U" oldref="74">
-<item type="input">=LOGINV(0.05;0;1)</item> returns 0.19.</paragraph>
+<item type="input">=LOGINV(0.05;0;1)</item> returns 0.1930408167.</paragraph>
+</section>
+<section id="lognormdotinv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2901928"><bookmark_value>LOGNORM.INV function</bookmark_value>
+<bookmark_value>inverse of lognormal distribution</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGINV_MS" id="bm_id2901062" localize="false"/>
+<paragraph role="heading" id="hd_id2901928" xml-lang="en-US" level="2" l10n="U" oldref="66">LOGNORM.INV</paragraph>
+<paragraph role="paragraph" id="par_id2901297" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_FUNC_LOGINV_MS">Returns the inverse of the lognormal distribution.</ahelp></paragraph>
+<paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This function is identical to LOGINV and was introduced for interoperability with other office suites.</paragraph>
+<paragraph role="heading" id="hd_id2901016" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph>
+<paragraph role="code" id="par_id2901049" xml-lang="en-US" l10n="U" oldref="69">LOGNORM.INV(Number; Mean; StDev)</paragraph>
+<paragraph role="paragraph" id="par_id2901390" xml-lang="en-US" l10n="U" oldref="70">
+<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id2901538" xml-lang="en-US" l10n="U" oldref="71">
+<emph>Mean</emph> (required) is the arithmetic mean of the standard logarithmic distribution.</paragraph>
+<paragraph role="paragraph" id="par_id2901355" xml-lang="en-US" l10n="U" oldref="72">
+<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph>
+<paragraph role="heading" id="hd_id2901768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph>
+<paragraph role="paragraph" id="par_id2901623" xml-lang="en-US" l10n="U" oldref="74">
+<item type="input">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167.</paragraph>
 </section>
 <section id="lognormdist">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3158417"><bookmark_value>LOGNORMDIST function</bookmark_value>
@@ -187,6 +207,27 @@
 <paragraph role="paragraph" id="par_id3149778" xml-lang="en-US" l10n="U" oldref="84">
 <item type="input">=LOGNORMDIST(0.1;0;1)</item> returns 0.01.</paragraph>
 </section>
+<section id="lognormdotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2901417"><bookmark_value>LOGNORM.DIST function</bookmark_value>
+<bookmark_value>lognormal distribution</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMDIST_MS" id="bm_id2901366" localize="false"/>
+<paragraph role="heading" id="hd_id2908417" xml-lang="en-US" level="2" l10n="U" oldref="76">LOGNORM.DIST</paragraph>
+<paragraph role="paragraph" id="par_id2904953" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_NORMDIST_MS">Returns the values of a lognormal distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id2900474" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph>
+<paragraph role="code" id="par_id2900686" xml-lang="en-US" l10n="U" oldref="79">LOGNORM.DIST(Number; Mean; StDev; Cumulative)</paragraph>
+<paragraph role="paragraph" id="par_id2904871" xml-lang="en-US" l10n="U" oldref="80">
+<emph>Number</emph> (required) is the probability value for which the standard logarithmic distribution is to be calculated.</paragraph>
+<paragraph role="paragraph" id="par_id2905820" xml-lang="en-US" l10n="U" oldref="81">
+<emph>Mean</emph> (required) is the mean value of the standard logarithmic distribution.</paragraph>
+<paragraph role="paragraph" id="par_id2905991" xml-lang="en-US" l10n="U" oldref="82">
+<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph>
+<paragraph role="paragraph" id="par_id2905992" xml-lang="en-US" l10n="NEW">
+<emph>Cumulative</emph> (required) = 0 calculates the density function, Cumulative = 1 calculates the distribution.</paragraph>
+<paragraph role="heading" id="hd_id2903178" xml-lang="en-US" level="3" l10n="U" oldref="83">Example</paragraph>
+<paragraph role="paragraph" id="par_id2909778" xml-lang="en-US" l10n="U" oldref="84">
+<item type="input">=LOGNORM.DIST(0.1;0;1;1)</item> returns 0.0106510993.</paragraph>
+</section>
 </sort>
 <section id="relatedtopics">
 <embed href="text/scalc/01/04060100.xhp#drking"/>
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp
index 24a717f012..12d3201f74 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -222,6 +222,24 @@ oldref="68">Example</paragraph>
 <paragraph xml-lang="en-US" id="par_id3153921" role="paragraph" l10n="CHG" oldref="69">
 <item type="input">=NORMINV(0.9;63;5)</item> returns 69.41. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41g grams.</paragraph>
 </section>
+<section id="normdotinv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2955516"><bookmark_value>NORM.INV function</bookmark_value>
+<bookmark_value>normal distribution;inverse of</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV_MS" id="bm_id2949396" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2955516" role="heading" level="2" l10n="U" oldref="61">NORM.INV</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954634" role="paragraph" l10n="U" oldref="62"><ahelp hid="HID_FUNC_NORMINV_MS">Returns the inverse of the normal cumulative distribution.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2953227" role="heading" level="3" l10n="U"
+oldref="63">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2947534" role="code" l10n="U" oldref="64">NORM.INV(Number; Mean; StDev)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954950" role="paragraph" l10n="U" oldref="65"><emph>Number</emph> represents the probability value used to determine the inverse normal distribution.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950690" role="paragraph" l10n="U" oldref="66"><emph>Mean</emph> represents the mean value in the normal distribution.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948594" role="paragraph" l10n="U" oldref="67"><emph>StDev</emph> represents the standard deviation of the normal distribution.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2955822" role="heading" level="3" l10n="U"
+oldref="68">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953921" role="paragraph" l10n="CHG" oldref="69">
+<item type="input">=NORM.INV(0.9;63;5)</item> returns 69.4077578277. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41g grams.</paragraph>
+</section>
 <section id="normdist">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153722"><bookmark_value>NORMDIST function</bookmark_value>
 <bookmark_value>density function</bookmark_value>
@@ -244,6 +262,27 @@ oldref="79">Example</paragraph>
 <paragraph xml-lang="en-US" id="par_id3149448" role="paragraph" l10n="CHG" oldref="81">
 <item type="input">=NORMDIST(70;63;5;1)</item> returns 0.92.</paragraph>
 </section>
+<section id="normdotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2913722"><bookmark_value>NORM.DIST function</bookmark_value>
+<bookmark_value>density function</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMDIST_MS" id="bm_id2917484" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2913722" role="heading" level="2" l10n="U" oldref="71">NORM.DIST</paragraph>
+<paragraph xml-lang="en-US" id="par_id2910386" role="paragraph" l10n="CHG" oldref="72"><ahelp hid="HID_FUNC_NORMDIST_MS">Returns the density function or the normal cumulative distribution.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2913282" role="heading" level="3" l10n="U"
+oldref="73">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2910613" role="code" l10n="U" oldref="74">NORM.DIST(Number; Mean; StDev; C)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2919820" role="paragraph" l10n="U" oldref="75"><emph>Number</emph> is the value of the distribution based on which the normal distribution is to be calculated.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2916063" role="paragraph" l10n="U" oldref="76"><emph>Mean</emph> is the mean value of the distribution.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2916295" role="paragraph" l10n="U" oldref="77"><emph>StDev</emph> is the standard deviation of the distribution.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2915080" role="paragraph" l10n="U" oldref="78"><emph>C</emph> = 0 calculates the density function, <emph>C</emph> = 1 calculates the distribution.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2912972" role="heading" level="3" l10n="U"
+oldref="79">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2919283" role="paragraph" l10n="CHG" oldref="80">
+<item type="input">=NORM.DIST(70;63;5;0)</item> returns 0.029945493.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2919448" role="paragraph" l10n="CHG" oldref="81">
+<item type="input">=NORM.DIST(70;63;5;1)</item> returns 0.9192433408.</paragraph>
+</section>
 <section id="pearson">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3152934"><bookmark_value>PEARSON function</bookmark_value>
 </bookmark>
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 03271c3f4b..d0ea9cd787 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -193,7 +193,7 @@
          <paragraph xml-lang="en-US" id="par_id3151282" role="paragraph" l10n="U" oldref="57"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph>
          <paragraph xml-lang="en-US" id="hd_id3153261" role="heading" level="3" l10n="U"
                     oldref="58">Syntax</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3154195" role="code" l10n="U" oldref="59">NORMINV(Number)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3154195" role="code" l10n="U" oldref="59">NORMSINV(Number)</paragraph>
          <paragraph xml-lang="en-US" id="par_id3148772" role="paragraph" l10n="U" oldref="60">
             <emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated.</paragraph>
          <paragraph xml-lang="en-US" id="hd_id3150934" role="heading" level="3" l10n="U"
@@ -201,6 +201,21 @@
          <paragraph xml-lang="en-US" id="par_id3149030" role="paragraph" l10n="U" oldref="62">
             <item type="input">=NORMSINV(0.908789)</item> returns 1.3333.</paragraph>
       </section>
+      <section id="normdotsdotinv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2957986"><bookmark_value>NORM.S.INV function</bookmark_value>
+         <bookmark_value>normal distribution;inverse of standard</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMINV_MS" id="bm_id2948389" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2957986" role="heading" level="2" l10n="U" oldref="56">NORM.S.INV</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2951282" role="paragraph" l10n="U" oldref="57"><ahelp hid="HID_FUNC_STD_NORMINV_MS">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2953261" role="heading" level="3" l10n="U" oldref="58">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2954195" role="code" l10n="U" oldref="59">NORM.S.INV(Number)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2948772" role="paragraph" l10n="U" oldref="60">
+            <emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated.</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2950934" role="heading" level="3" l10n="U" oldref="61">Example</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2949030" role="paragraph" l10n="U" oldref="62">
+            <item type="input">=NORM.S.INV(0.908789)</item> returns 1.333334673.</paragraph>
+      </section>
       <section id="normsdist">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3147538"><bookmark_value>NORMSDIST function</bookmark_value>
          <bookmark_value>normal distribution;statistics</bookmark_value>
@@ -220,6 +235,25 @@
          <paragraph xml-lang="en-US" id="par_id3155984" role="paragraph" l10n="U" oldref="70">
             <item type="input">=NORMSDIST(1)</item> returns 0.84. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area.</paragraph>
       </section>
+      <section id="normdotsdotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2947538"><bookmark_value>NORM.S.DIST function</bookmark_value>
+         <bookmark_value>normal distribution;statistics</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMDIST_MS" id="bm_id2945269" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2947538" role="heading" level="2" l10n="U" oldref="64">NORM.S.DIST</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2950474" role="paragraph" l10n="CHG" oldref="65"><ahelp hid="HID_FUNC_STD_NORMDIST_MS">Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.</ahelp></paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2955083" role="heading" level="3" l10n="U" oldref="66">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2958411" role="code" l10n="U" oldref="67">NORM.S.DIST(Number; Cumulative)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2954950" role="paragraph" l10n="CHG" oldref="68">
+            <emph>Number</emph> is the value to which the standard normal cumulative distribution is calculated.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2954951" role="paragraph" l10n="CHG" oldref="68">
+            <emph>Cumulative</emph> 0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2993228" role="heading" level="3" l10n="U" oldref="69">Examples</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2955984" role="paragraph" l10n="U" oldref="70">
+            <item type="input">=NORM.S.DIST(1;0)</item> returns 0.2419707245.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2955985" role="paragraph" l10n="U" oldref="70">
+            <item type="input">=NORM.S.DIST(1;1)</item> returns 0.8413447461. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area.</paragraph>
+        </section>
       <section id="slope">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value>
 </bookmark>