[Libreoffice-commits] help.git: source/text

Rafael Lima (via logerrit) logerrit at kemper.freedesktop.org
Fri Aug 27 18:43:34 UTC 2021


 source/text/scalc/01/04060184.xhp |   37 ++++++++++++++++++++-----------------
 1 file changed, 20 insertions(+), 17 deletions(-)

New commits:
commit 04f49b69b26dc5d9cb2939f86b7c10653b7c36e6
Author:     Rafael Lima <rafael.palma.lima at gmail.com>
AuthorDate: Thu Aug 26 16:00:27 2021 +0200
Commit:     Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Fri Aug 27 20:43:14 2021 +0200

    tdf#116576 Fix the description of the PHI function
    
    Change-Id: Ia15cadc19186519767044b1d75a5e033f0096ebf
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121058
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>

diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp
index ce1f60559..e73b6c04b 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -18,8 +18,6 @@
  *   except in compliance with the License. You may obtain a copy of
  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  -->
-
-
 <meta>
 <topic id="textscalc0104060184xml" indexer="include">
 <title xml-lang="en-US" id="tit">Statistical Functions Part Four</title>
@@ -331,21 +329,26 @@
 <item type="input">=PEARSON(A1:A30;B1:B30)</item> returns the Pearson correlation coefficient of both data sets.</paragraph>
 </section>
 <section id="phi">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3152806"><bookmark_value>PHI function</bookmark_value>
-</bookmark>
-<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PHI" id="bm_id3153757" localize="false"/>
-<h2 id="hd_id3152806">PHI</h2>
-<paragraph xml-lang="en-US" id="par_id3150254" role="paragraph"><ahelp hid="HID_FUNC_PHI">Returns the values of the distribution function for a standard normal distribution.</ahelp></paragraph>
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph xml-lang="en-US" id="par_id3149976" role="code">PHI(Number)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3156108" role="paragraph"><emph>Number</emph> represents the value based on which the standard normal distribution is calculated.</paragraph>
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph xml-lang="en-US" id="par_id3155849" role="paragraph">
-<item type="input">=PHI(2.25) </item>= 0.03</paragraph>
-<paragraph xml-lang="en-US" id="par_id3143236" role="paragraph">
-<item type="input">=PHI(-2.25)</item> = 0.03</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149286" role="paragraph">
-<item type="input">=PHI(0)</item> = 0.4</paragraph>
+  <bookmark xml-lang="en-US" branch="index" id="bm_id3152806">
+    <bookmark_value>PHI function</bookmark_value>
+  </bookmark>
+  <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PHI" id="bm_id3153757" localize="false"/>
+  <h2 id="hd_id3152806">PHI</h2>
+  <paragraph xml-lang="en-US" id="par_id3150254" role="paragraph"><ahelp hid="HID_FUNC_PHI">Returns the value of the probability density function for a given value considering the standard normal distribution.</ahelp></paragraph>
+  <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+  <paragraph role="paragraph" id="par_id151629986285891"><input>PHI(Number)</input></paragraph>
+  <paragraph id="par_id3156108" role="paragraph"><emph>Number</emph> is the value for which the probability density function is calculated.</paragraph>
+  <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+  <paragraph id="par_id3155849" role="paragraph">
+    <input>=PHI(2.25)</input> returns 0.0317.
+  </paragraph>
+  <paragraph id="par_id3143236" role="paragraph">
+    <input>=PHI(-2.25)</input> also returns 0.0317 because the normal distribution is symmetrical.
+  </paragraph>
+  <paragraph id="par_id3149286" role="paragraph">
+    <input>=PHI(0)</input> returns 0.3989.
+  </paragraph>
+  <tip id="par_id611629985664328">Calling <input>PHI(Number)</input> is equivalent to calling <input>NORMDIST(Number,0,1,FALSE())</input> or <input>NORM.S.DIST(Number;FALSE())</input>, hence using the standard normal distribution with mean equal to 0 and standard deviation equal to 1 with the <emph>Cumulative</emph> argument set to <emph>False.</emph></tip>
 </section>
 <section id="poisson">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153985"><bookmark_value>POISSON function</bookmark_value>


More information about the Libreoffice-commits mailing list