source/text/scalc/01/04060184.xhp | 37 ++++++++++++++++++++-----------------
1 file changed, 20 insertions(+), 17 deletions(-)
New commits:
commit 04f49b69b26dc5d9cb2939f86b7c10653b7c36e6
Author: Rafael Lima <rafael.palma.l...@gmail.com>
AuthorDate: Thu Aug 26 16:00:27 2021 +0200
Commit: Olivier Hallot <olivier.hal...@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.hal...@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>
