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>

1 files changed, 35 insertions, 1 deletions

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>