source/text/scalc/01/04060110.xhp | 17 +-
source/text/scalc/01/04060115.xhp | 16 +-
source/text/scalc/01/04060181.xhp | 171 ++++++++---------------
source/text/scalc/01/04060182.xhp | 50 +++++-
source/text/scalc/01/04060183.xhp | 31 +++-
source/text/scalc/01/04060184.xhp | 63 ++++++--
source/text/scalc/01/04060185.xhp | 77 ++++++++--
source/text/scalc/01/func_aggregate.xhp | 13 -
source/text/scalc/01/func_ceiling.xhp | 20 ++
source/text/scalc/01/func_concat.xhp | 5
source/text/scalc/01/func_floor.xhp | 17 +-
source/text/scalc/01/func_forecastetsadd.xhp | 8 -
source/text/scalc/01/func_forecastetspiadd.xhp | 9 -
source/text/scalc/01/func_forecastetsseason.xhp | 7
source/text/scalc/01/func_forecastetsstatadd.xhp | 7
source/text/scalc/01/func_ifs.xhp | 5
source/text/scalc/01/func_maxifs.xhp | 5
source/text/scalc/01/func_minifs.xhp | 5
source/text/scalc/01/func_networkdays.intl.xhp | 5
source/text/scalc/01/func_switch.xhp | 5
source/text/scalc/01/func_textjoin.xhp | 5
source/text/scalc/01/func_webservice.xhp | 15 +-
source/text/scalc/01/func_workday.intl.xhp | 5
23 files changed, 356 insertions(+), 205 deletions(-)
New commits:
commit 7ad8f2bbd7b786557b8bcd9b275e0c312a921bf8
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Dec 31 14:23:17 2021 -0300
Commit: Adolfo Jayme Barrientos <fit...@ubuntu.com>
CommitDate: Sat Jan 1 03:26:08 2022 +0100
tdf#94537 COM.MICROSOFT.* namespace information
+ Covered all COM.MICROSOFT namespace of wiki page in the bug report.
+ refactor of other info such as release number availability.
+ Muted l10N in a table and drop duplication.
Change-Id: Id77f9657f164193d5e672e9edf82a2170b5f4040
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127817
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 9ddbcf00a..c05a24580 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -46,15 +46,15 @@
<bookmark_value>using double quotation marks in formulas</bookmark_value>
<bookmark_value>formulas; using double quotation marks</bookmark_value>
</bookmark>
-
-<h2 id="hd_id291624454173529">Using double quotation marks in formulas</h2>
+
+<h2 id="hd_id291624454173529">Using double quotation marks in formulas</h2>
<paragraph role="paragraph" id="par_id891624454058773">To include a text
string in a formula, place the text string between two double quotation marks
(") and Calc takes the characters in the string without attempting to interpret
them. For example, the formula <input>="Hello world!"</input> displays the text
string <literal>Hello world!</literal> in the cell, with no surrounding double
quotation marks.</paragraph>
<paragraph role="paragraph" id="par_id461624454425320">The more complex
formula <input>=CONCATENATE("Life is really simple, "; "but we insist on making
it complicated "; "(Confucius).")</input> concatenates three individual strings
in double quotation marks, outputting <literal>Life is really simple, but we
insist on making it complicated (Confucius).</literal></paragraph>
<paragraph role="paragraph" id="par_id711624454477483">To place a literal
double quotation mark within a string inside a formula, two methods can be
used:</paragraph>
-
+
<list type="ordered">
<listitem>
<paragraph id="par_id541624454496424" role="listitem">You can "escape"
the double quotation mark with an additional double quotation mark, and Calc
treats the escaped double quotation mark as a literal value. For example, the
formula <input>="My name is ""John Doe""."</input> outputs the string
<literal>My name is "John Doe".</literal> Another simple example is the formula
<input>=UNICODE("""")</input> which returns <literal>34</literal>, the decimal
value of the Unicode quotation mark character (U+0022) — here the first and
fourth double quotation marks indicate the beginning and end of the string,
while the second double quotation mark escapes the third.</paragraph>
@@ -82,9 +82,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id9323709">
<bookmark_value>BAHTTEXT function</bookmark_value>
</bookmark>
-
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BAHTTEXT" id="bm_id744346"
localize="false"/><comment>i66350</comment>
-
<h2 id="hd_id6695455">BAHTTEXT</h2>
<paragraph id="par_id354014" role="paragraph" xml-lang="en-US">Converts a
number to Thai text, including the Thai currency names.</paragraph>
@@ -94,6 +92,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3289284" role="paragraph" xml-lang="en-US"> <item
type="input">=BAHTTEXT(12.65)</item> returns a string in Thai characters with
the meaning of "Twelve Baht and sixty five Satang".</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.BAHTTEXT</literal></paragraph>
</section>
<section id="base">
@@ -163,10 +164,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3147472" role="code"
xml-lang="en-US">CLEAN("Text")</paragraph>
<paragraph id="par_id3150695" role="paragraph" xml-lang="en-US">
<emph>Text</emph> refers to the text from which to remove all non-printable
characters.</paragraph>
-
+
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph"
id="par_id581621538151600"><input>=LEN(CLEAN(CHAR(7) & "LibreOffice Calc"
& CHAR(8)))</input> returns 16, showing that the CLEAN function removes the
non-printable Unicode U+0007 ("BEL") and U+0008 ("BS") characters at the
beginning and end of the string argument. CLEAN does not remove
spaces.</paragraph>
-
+
</section>
<section id="code">
@@ -527,7 +528,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3148626" role="paragraph" xml-lang="en-US"> <item
type="input">=REPT("Good morning";2)</item> returns Good morningGood
morning.</paragraph>
-
+
<tip id="par_id381626381556310">Refer to the <link
href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT";
name="REPT_Wiki">REPT</link> wiki page for more details about this
function.</tip></section>
<section id="right">
diff --git a/source/text/scalc/01/04060115.xhp
b/source/text/scalc/01/04060115.xhp
index 39203961e..2629e93d0 100644
--- a/source/text/scalc/01/04060115.xhp
+++ b/source/text/scalc/01/04060115.xhp
@@ -64,7 +64,7 @@
<section id="besselj">
<bookmark xml-lang="en-US" branch="index" id="bm_id161618267677640">
<bookmark_value>BESSELJ function</bookmark_value>
-</bookmark>
+</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELJ"
id="bm_id3150539" localize="false"/>
<h2 id="hd_id3153027">BESSELJ</h2>
@@ -84,7 +84,7 @@
<section id="besselk">
<bookmark xml-lang="en-US" branch="index" id="bm_id151618267791726">
<bookmark_value>BESSELK function</bookmark_value>
-</bookmark>
+</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELK"
id="bm_id3147616" localize="false"/>
<h2 id="hd_id3149946">BESSELK</h2>
@@ -104,7 +104,7 @@
<section id="bessely">
<bookmark xml-lang="en-US" branch="index" id="bm_id201618267836525">
<bookmark_value>BESSELY function</bookmark_value>
-</bookmark>
+</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELY"
id="bm_id3150461" localize="false"/>
<h2 id="hd_id3145828">BESSELY</h2>
@@ -288,13 +288,16 @@
<h2 id="hd_id2983446">ERF.PRECISE</h2>
<paragraph id="par_id2950381" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ERF_MS">Returns values of the Gaussian error integral between 0
and the given limit.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2963824" role="code"
xml-lang="en-US">ERF.PRECISE(LowerLimit)</paragraph>
<paragraph id="par_id2949715" role="paragraph"
xml-lang="en-US"><emph>LowerLimit</emph> is the limit of the integral. The
calculation takes place between 0 and this limit.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2952974" role="paragraph" xml-lang="en-US"> <item
type="input">=ERF.PRECISE(1)</item> returns 0.842701.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id351640873986703"
localize="false"><literal>COM.MICROSOFT.ERF.PRECISE</literal></paragraph>
</section>
<section id="erfc">
@@ -324,13 +327,16 @@
<h2 id="hd_id2945082">ERFC.PRECISE</h2>
<paragraph id="par_id2949453" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ERFC_MS">Returns complementary values of the Gaussian error
integral between x and infinity.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2953220" role="code"
xml-lang="en-US">ERFC.PRECISE(LowerLimit)</paragraph>
<paragraph id="par_id2947620" role="paragraph" xml-lang="en-US">
<emph>LowerLimit</emph> is the lower limit of the integral</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2956102" role="paragraph" xml-lang="en-US"> <item
type="input">=ERFC.PRECISE(1)</item> returns 0.157299.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640853986703"
localize="false"><literal>COM.MICROSOFT.ERFC.PRECISE</literal></paragraph>
</section>
<section id="gestep">
diff --git a/source/text/scalc/01/04060181.xhp
b/source/text/scalc/01/04060181.xhp
index 21bf538df..65550ba42 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -221,7 +221,6 @@
<h2 id="hd_id2945620">BETA.INV</h2>
<paragraph id="par_id2949825" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_BETAINV_MS">Returns the inverse of the cumulative beta
probability density function.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2956300" role="code" xml-lang="en-US">BETA.INV(Number;
Alpha; Beta [; Start [; End]])</paragraph>
<paragraph id="par_id2949266" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value between <emph>Start</emph>
and <emph>End</emph> at which to evaluate the function.</paragraph>
@@ -233,6 +232,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2946859" role="paragraph" xml-lang="en-US"><item
type="input">=BETA.INV(0.5;5;10)</item> returns the value
0.3257511553.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id311640873986703"
localize="false"><literal>COM.MICROSOFT.BETA.INV</literal></paragraph>
</section>
<section id="betadist">
@@ -284,6 +287,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2956118" role="paragraph" xml-lang="en-US"><item
type="input">=BETA.DIST(2;8;10;1;1;3)</item> returns the value
0.6854706</paragraph>
<paragraph id="par_id2956119" role="paragraph" xml-lang="en-US"><item
type="input">=BETA.DIST(2;8;10;0;1;3)</item> returns the value
1.4837646</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341645873986703"
localize="false"><literal>COM.MICROSOFT.BETA.DIST</literal></paragraph>
</section>
<section id="binomdist">
@@ -317,7 +323,6 @@
<h2 id="hd_id2943228">BINOM.DIST</h2>
<paragraph id="par_id2946897" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_BINOM_DIST_MS">Returns the individual term binomial distribution
probability.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2956009" role="code" xml-lang="en-US">BINOM.DIST(X;
Trials; SP; C)</paragraph>
<paragraph id="par_id2954304" role="paragraph" xml-lang="en-US"><emph>X</emph>
is the number of successes in a set of trials.</paragraph>
@@ -328,6 +333,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id295666" role="paragraph" xml-lang="en-US"><item
type="input">=BINOM.DIST(A1;12;0.5;0)</item> shows (if the values <item
type="input">0</item> to <item type="input">12</item> are entered in A1) the
probabilities for 12 flips of a coin that <emph>Heads</emph> will come up
exactly the number of times entered in A1.</paragraph>
<paragraph id="par_id290120" role="paragraph" xml-lang="en-US"><item
type="input">=BINOM.DIST(A1;12;0.5;1)</item> shows the cumulative probabilities
for the same series. For example, if A1 = <item type="input">4</item>, the
cumulative probability of the series is 0, 1, 2, 3 or 4 times
<emph>Heads</emph> (non-exclusive OR).</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873786703"
localize="false"><literal>COM.MICROSOFT.BINOM.DIST</literal></paragraph>
</section>
<section id="binomdotinv">
@@ -339,7 +348,6 @@
<h2 id="hd_id2843228">BINOM.INV</h2>
<paragraph id="par_id2846897" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_BINOM_INV_MS">Returns the smallest value for which the cumulative
binomial distribution is greater than or equal to a criterion
value.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2856009" role="code" xml-lang="en-US">BINOM.INV(Trials;
SP; Alpha)</paragraph>
<paragraph id="par_id2847492" role="paragraph"
xml-lang="en-US"><emph>Trials</emph> The total number of trials.</paragraph>
@@ -348,6 +356,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id285666" role="paragraph" xml-lang="en-US"><item
type="input">=BINOM.INV(8;0.6;0.9)</item> returns 7, the smallest value for
which the cumulative binomial distribution is greater than or equal to a
criterion value.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873986706"
localize="false"><literal>COM.MICROSOFT.BINOM.INV</literal></paragraph>
</section>
<section id="chisqinv">
@@ -373,7 +385,6 @@
<h2 id="hd_id2919200902421451">CHISQ.INV</h2>
<paragraph id="par_id2919200902421449" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_CHISQINV_MS">Returns the inverse of the
left-tailed probability of the chi-square distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id1150504" role="code"
xml-lang="en-US">CHISQ.INV(Probability; DegreesFreedom)</paragraph>
<paragraph id="par_id2919200902475286" role="paragraph"
xml-lang="en-US"><emph>Probability</emph> is the probability value for which
the inverse of the chi-square distribution is to be calculated.</paragraph>
@@ -381,6 +392,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id275666" role="paragraph" xml-lang="en-US"><item
type="input">=CHISQ.INV(0,5;1)</item> returns 0.4549364231.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873986753"
localize="false"><literal>COM.MICROSOFT.CHISQ.INV</literal></paragraph>
</section>
<section id="chiinv">
@@ -416,7 +431,6 @@
<h2 id="hd_id2948835">CHISQ.INV.RT</h2>
<paragraph id="par_id2949906" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CHIINV_MS">Returns the inverse of the one-tailed probability of
the chi-squared distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2950504" role="code"
xml-lang="en-US">CHISQ.INV.RT(Number; DegreesFreedom)</paragraph>
<paragraph id="par_id2954898" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value of the error
probability.</paragraph>
@@ -429,6 +443,10 @@
<paragraph id="par_id2949763" role="paragraph" xml-lang="en-US"><item
type="input">=CHISQ.INV.RT(0.05;5)</item> returns 11.0704976935.</paragraph>
<paragraph id="par_id2959142" role="paragraph" xml-lang="en-US"><item
type="input">=CHISQ.INV.RT(0.02;5)</item> returns 13.388222599.</paragraph>
<paragraph id="par_id2958401" role="paragraph" xml-lang="en-US">If the
probability of error is 5%, the die is not true. If the probability of error is
2%, there is no reason to believe it is fixed.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873983703"
localize="false"><literal>COM.MICROSOFT.CHISQ.INV.RT</literal></paragraph>
</section>
<section id="chitest">
@@ -449,84 +467,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<table id="tbl_id3153233">
- <tablerow>
- <tablecell>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3154096" role="paragraph" xml-lang="en-US">Data_B
(observed)</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3152948" role="paragraph" xml-lang="en-US">Data_E
(expected)</paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id3152876" role="paragraph"
xml-lang="en-US">1</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3159279" role="paragraph" xml-lang="en-US"><item
type="input">195</item></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3149105" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id3149922" role="paragraph"
xml-lang="en-US">2</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3148621" role="paragraph" xml-lang="en-US"><item
type="input">151</item></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3148987" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id3149417" role="paragraph"
xml-lang="en-US">3</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3148661" role="paragraph" xml-lang="en-US"><item
type="input">148</item></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3151128" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id3148467" role="paragraph"
xml-lang="en-US">4</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3149237" role="paragraph" xml-lang="en-US"><item
type="input">189</item></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3145304" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id3149927" role="paragraph"
xml-lang="en-US">5</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3150630" role="paragraph" xml-lang="en-US"><item
type="input">183</item></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3150423" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id3143275" role="paragraph"
xml-lang="en-US">6</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3144750" role="paragraph" xml-lang="en-US"><item
type="input">154</item></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id3153947" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
- </tablecell>
- </tablerow>
-</table>
+<embed href="text/scalc/01/04060181.xhp#data_sample"/>
<paragraph id="par_id3149481" role="paragraph" xml-lang="en-US"><item
type="input">=CHITEST(A1:A6;B1:B6)</item> equals 0.02. This is the probability
which suffices the observed data of the theoretical Chi-square
distribution.</paragraph>
</section>
@@ -541,94 +482,97 @@
<h2 id="hd_id2954260">CHISQ.TEST</h2>
<paragraph id="par_id2951052" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CHITEST_MS">Returns the probability of a deviance from a random
distribution of two test series based on the chi-squared test for
independence.</ahelp> CHISQ.TEST returns the chi-squared distribution of the
data.</paragraph>
<paragraph id="par_id2948925" role="paragraph" xml-lang="en-US">The
probability determined by CHISQ.TEST can also be determined with CHISQ.DIST, in
which case the Chi square of the random sample must then be passed as a
parameter instead of the data row.</paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2949162" role="code" xml-lang="en-US">CHISQ.TEST(DataB;
DataE)</paragraph>
<paragraph id="par_id2958421" role="paragraph"
xml-lang="en-US"><emph>DataB</emph> is the array of the
observations.</paragraph>
<paragraph id="par_id2966453" role="paragraph"
xml-lang="en-US"><emph>DataE</emph> is the range of the expected
values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-
+<section id="data_sample">
<table id="tbl_id2953233">
<tablerow>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id2954096" role="paragraph" xml-lang="en-US">Data_B
(observed)</paragraph>
+ <paragraph id="par_id2954096" role="tablehead" xml-lang="en-US">Data_B
(observed)</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2952948" role="paragraph" xml-lang="en-US">Data_E
(expected)</paragraph>
+ <paragraph id="par_id2952948" role="tablehead" xml-lang="en-US">Data_E
(expected)</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id2952876" role="paragraph"
xml-lang="en-US">1</paragraph>
+ <paragraph id="par_id2952876" role="tablehead" localize="false"
xml-lang="en-US">1</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2959279" role="paragraph" xml-lang="en-US"><item
type="input">195</item></paragraph>
+ <paragraph id="par_id2959279" role="tablecontent" localize="false"
xml-lang="en-US">195</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2949105" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
+ <paragraph id="par_id2949105" role="tablecontent" localize="false"
xml-lang="en-US">170</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id2949922" role="paragraph"
xml-lang="en-US">2</paragraph>
+ <paragraph id="par_id2949922" role="tablehead" localize="false"
xml-lang="en-US">2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2948621" role="paragraph" xml-lang="en-US"><item
type="input">151</item></paragraph>
+ <paragraph id="par_id2948621" role="tablecontent" localize="false"
xml-lang="en-US">151</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2948987" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
+ <paragraph id="par_id2948987" role="tablecontent" localize="false"
xml-lang="en-US">170</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id2949417" role="paragraph"
xml-lang="en-US">3</paragraph>
+ <paragraph id="par_id2949417" role="tablehead" localize="false"
xml-lang="en-US">3</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2948661" role="paragraph" xml-lang="en-US"><item
type="input">148</item></paragraph>
+ <paragraph id="par_id2948661" role="tablecontent" localize="false"
xml-lang="en-US">148</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2951128" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
+ <paragraph id="par_id2951128" role="tablecontent" localize="false"
xml-lang="en-US">170</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id2948467" role="paragraph"
xml-lang="en-US">4</paragraph>
+ <paragraph id="par_id2948467" role="tablehead" localize="false"
xml-lang="en-US">4</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2949237" role="paragraph" xml-lang="en-US"><item
type="input">189</item></paragraph>
+ <paragraph id="par_id2949237" role="tablecontent" localize="false"
xml-lang="en-US">189</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2945304" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
+ <paragraph id="par_id2945304" role="tablecontent" localize="false"
xml-lang="en-US">170</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id2949927" role="paragraph"
xml-lang="en-US">5</paragraph>
+ <paragraph id="par_id2949927" role="tablehead" localize="false"
xml-lang="en-US">5</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2950630" role="paragraph" xml-lang="en-US"><item
type="input">183</item></paragraph>
+ <paragraph id="par_id2950630" role="tablecontent" localize="false"
xml-lang="en-US">183</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2950423" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
+ <paragraph id="par_id2950423" role="tablecontent" localize="false"
xml-lang="en-US">170</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id2943275" role="paragraph"
xml-lang="en-US">6</paragraph>
+ <paragraph id="par_id2943275" role="tablehead" localize="false"
xml-lang="en-US">6</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2944750" role="paragraph" xml-lang="en-US"><item
type="input">154</item></paragraph>
+ <paragraph id="par_id2944750" role="tablecontent" localize="false"
xml-lang="en-US">154</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id2953947" role="paragraph" xml-lang="en-US"><item
type="input">170</item></paragraph>
+ <paragraph id="par_id2953947" role="tablecontent" localize="false"
xml-lang="en-US">170</paragraph>
</tablecell>
</tablerow>
</table>
-
+</section>
<paragraph id="par_id2949481" role="paragraph" xml-lang="en-US"><item
type="input">=CHISQ.TEST(A1:A6;B1:B6)</item> equals 0.0209708029. This is the
probability which suffices the observed data of the theoretical Chi-square
distribution.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873989703"
localize="false"><literal>COM.MICROSOFT.CHISQ.TEST</literal></paragraph>
</section>
<section id="chidist">
@@ -661,7 +605,6 @@
<h2 id="hd_id2848690">CHISQ.DIST</h2>
<paragraph id="par_id2856338" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CHISQDIST_MS">Returns the probability density function or the
cumulative distribution function for the chi-square
distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2858439" role="code" xml-lang="en-US">CHISQ.DIST(Number;
DegreesFreedom; Cumulative)</paragraph>
<paragraph id="par_id2848675" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the chi-square value of the random
sample used to determine the error probability.</paragraph>
@@ -671,6 +614,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2845774" role="paragraph" xml-lang="en-US"><item
type="input">=CHISQ.DIST(3; 2; 0) </item>equals 0.1115650801, the probability
density function with 2 degrees of freedom, at x = 3.</paragraph>
<paragraph id="par_id2745774" role="paragraph" xml-lang="en-US"><item
type="input">=CHISQ.DIST(3; 2; 1) </item>equals 0.7768698399, the cumulative
chi-square distribution with 2 degrees of freedom, at the value x =
3.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873984703"
localize="false"><literal>COM.MICROSOFT.CHISQ.DIST</literal></paragraph>
</section>
<section id="chisqdotdistdotrt">
@@ -683,7 +630,6 @@
<h2 id="hd_id2948690">CHISQ.DIST.RT</h2>
<paragraph id="par_id2956338" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CHIVERT_MS">Returns the probability value from the indicated Chi
square that a hypothesis is confirmed.</ahelp> CHISQ.DIST.RT compares the Chi
square value to be given for a random sample that is calculated from the sum of
(observed value-expected value)^2/expected value for all values with the
theoretical Chi square distribution and determines from this the probability of
error for the hypothesis to be tested.</paragraph>
<paragraph id="par_id2951316" role="paragraph" xml-lang="en-US">The
probability determined by CHISQ.DIST.RT can also be determined by
CHITEST.</paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2958439" role="code"
xml-lang="en-US">CHISQ.DIST.RT(Number; DegreesFreedom)</paragraph>
<paragraph id="par_id2948675" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the chi-square value of the random
sample used to determine the error probability.</paragraph>
@@ -692,6 +638,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2945774" role="paragraph" xml-lang="en-US"><item
type="input">=CHISQ.DIST.RT(13.27; 5)</item> equals 0.0209757694.</paragraph>
<paragraph id="par_id2956141" role="paragraph" xml-lang="en-US">If the Chi
square value of the random sample is 13.27 and if the experiment has 5 degrees
of freedom, then the hypothesis is assured with a probability of error of
2%.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id343640873986703"
localize="false"><literal>COM.MICROSOFT.CHISQ.DIST.RT</literal></paragraph>
</section>
<section id="chisqdist">
@@ -743,7 +693,6 @@
<h2 id="hd_id2950603">EXPON.DIST</h2>
<paragraph id="par_id2949563" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_EXP_DIST_MS">Returns the exponential
distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2950987" role="code" xml-lang="en-US">EXPON.DIST(Number;
Lambda; C)</paragraph>
<paragraph id="par_id2954663" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value of the function.</paragraph>
@@ -752,6 +701,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2950357" role="paragraph" xml-lang="en-US"><item
type="input">=EXPON.DIST(3;0.5;1)</item> returns 0.7768698399.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341660873986703"
localize="false"><literal>COM.MICROSOFT.EXPON.DIST</literal></paragraph>
</section>
</sort>
diff --git a/source/text/scalc/01/04060182.xhp
b/source/text/scalc/01/04060182.xhp
index df82688b3..8591243a9 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -56,7 +56,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_LT"
id="bm_id2946113" localize="false"/>
<h2 id="hd_id2945388">F.INV</h2>
<paragraph xml-lang="en-US" id="par_id2955089" role="paragraph"><ahelp
hid="HID_FUNC_F_INV_LT">Returns the inverse of the cumulative F
distribution.</ahelp> The F distribution is used for F tests in order to set
the relation between two differing data sets.</paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953068" role="code">F.INV(Number;
DegreesFreedom1; DegreesFreedom2)</paragraph>
<paragraph xml-lang="en-US" id="par_id2946866"
role="paragraph"><emph>Number</emph> is probability value for which the inverse
F distribution is to be calculated.</paragraph>
@@ -64,6 +63,10 @@
<paragraph xml-lang="en-US" id="par_id2948607"
role="paragraph"><emph>DegreesFreedom2</emph> is the number of degrees of
freedom in the denominator of the F distribution.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2945073" role="paragraph"><item
type="input">=F.INV(0.5;5;10)</item> yields 0.9319331609.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873984703"
localize="false"><literal>COM.MICROSOFT.F.INV</literal></paragraph>
</section>
<section id="fdotinvdotrt">
<bookmark xml-lang="en-US" branch="index" id="bm_id2845388">
@@ -74,7 +77,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_RT"
id="bm_id2846113" localize="false"/>
<h2 id="hd_id2845388">F.INV.RT</h2>
<paragraph xml-lang="en-US" id="par_id2855089" role="paragraph"><ahelp
hid="HID_FUNC_F_INV_RT">Returns the inverse right tail of the F
distribution.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853068"
role="code">F.INV.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
<paragraph xml-lang="en-US" id="par_id2846866"
role="paragraph"><emph>Number</emph> is probability value for which the inverse
F distribution is to be calculated.</paragraph>
@@ -82,6 +84,10 @@
<paragraph xml-lang="en-US" id="par_id2848607"
role="paragraph"><emph>DegreesFreedom2</emph> is the number of degrees of
freedom in the denominator of the F distribution.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2845073" role="paragraph"><item
type="input">=F.INV.RT(0.5;5;10)</item> yields 0.9319331609.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341660873986703"
localize="false"><literal>COM.MICROSOFT.F.INV.RT</literal></paragraph>
</section>
<section id="fisher">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150888"><bookmark_value>FISHER function</bookmark_value>
@@ -136,13 +142,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_TEST_MS"
id="bm_id2959263" localize="false"/>
<h2 id="hd_id2951390">F.TEST</h2>
<paragraph xml-lang="en-US" id="par_id2950534" role="paragraph"><ahelp
hid="HID_FUNC_F_TEST_MS">Returns the result of an F test.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953024" role="code">F.TEST(Data1;
Data2)</paragraph>
<paragraph xml-lang="en-US" id="par_id2950032"
role="paragraph"><emph>Data1</emph> is the first record array.</paragraph>
<paragraph xml-lang="en-US" id="par_id2953018"
role="paragraph"><emph>Data2</emph> is the second record array.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2959126" role="paragraph"><item
type="input">=F.TEST(A1:A30;B1:B12)</item> calculates whether the two data sets
are different in their variance and returns the probability that both sets
could have come from the same total population.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640273986703"
localize="false"><literal>COM.MICROSOFT.F.TEST</literal></paragraph>
</section>
<section id="fdist">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150372"><bookmark_value>FDIST function</bookmark_value>
@@ -169,7 +178,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_LT"
id="bm_id2949722" localize="false"/>
<h2 id="hd_id2950372">F.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2952981" role="paragraph"><ahelp
hid="HID_FUNC_F_DIST_LT">Calculates the values of the left tail of the F
distribution.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2945826" role="code">F.DIST(Number;
DegreesFreedom1; DegreesFreedom2 [; Cumulative])</paragraph>
<paragraph xml-lang="en-US" id="par_id2950461"
role="paragraph"><emph>Number</emph> is the value for which the F distribution
is to be calculated.</paragraph>
@@ -179,6 +187,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2950696" role="paragraph"><item
type="input">=F.DIST(0.8;8;12;0)</item> yields 0.7095282499.</paragraph>
<paragraph xml-lang="en-US" id="par_id2950697" role="paragraph"><item
type="input">=F.DIST(0.8;8;12;1)</item> yields 0.3856603563.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986707"
localize="false"><literal>COM.MICROSOFT.F.DIST</literal></paragraph>
</section>
<section id="fdotdistdotrt">
<bookmark xml-lang="en-US" branch="index" id="bm_id2850372">
@@ -187,7 +199,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_RT"
id="bm_id289722" localize="false"/>
<h2 id="hd_id280372">F.DIST.RT</h2>
<paragraph xml-lang="en-US" id="par_id2852981" role="paragraph"><ahelp
hid="HID_FUNC_F_DIST_RT">Calculates the values of the right tail of the F
distribution.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2845826"
role="code">F.DIST.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
<paragraph xml-lang="en-US" id="par_id2850461"
role="paragraph"><emph>Number</emph> is the value for which the F distribution
is to be calculated.</paragraph>
@@ -195,6 +206,10 @@
<paragraph xml-lang="en-US" id="par_id2846877"
role="paragraph"><emph>degreesFreedom2</emph> is the degrees of freedom in the
denominator in the F distribution.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2850696" role="paragraph"><item
type="input">=F.DIST.RT(0.8;8;12)</item> yields 0.6143396437.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986763"
localize="false"><literal>COM.MICROSOFT.F.DIST.RT</literal></paragraph>
</section>
<section id="gamma">
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMA"
id="bm_id0119200903221254" localize="false"/>
@@ -232,7 +247,6 @@
<h2 id="hd_id2914841">GAMMA.INV</h2>
<paragraph xml-lang="en-US" id="par_id2913932"
role="paragraph"><ahelp hid="HID_FUNC_GAMMAINV_MS">Returns the inverse of the
Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to
search for variables with different distribution.</paragraph>
<paragraph id="par_id291422405814" role="paragraph"
xml-lang="en-US">This function is identical to GAMMAINV and was introduced for
interoperability with other office suites.</paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2915828"
role="code">GAMMA.INV(Number; Alpha; Beta)</paragraph>
<paragraph xml-lang="en-US" id="par_id2915138" role="paragraph">
@@ -244,6 +258,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2913331" role="paragraph">
<item type="input">=GAMMA.INV(0.8;1;1)</item> yields
1.61.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341630873986703"
localize="false"><literal>COM.MICROSOFT.GAMMA.INV</literal></paragraph>
</section>
<section id="gammaln">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154806"><bookmark_value>GAMMALN function</bookmark_value>
@@ -267,7 +285,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMALN_MS"
id="bm_id2919511" localize="false"/>
<h2 id="hd_id2914806">GAMMALN.PRECISE</h2>
<paragraph xml-lang="en-US" id="par_id2918572"
role="paragraph"><ahelp hid="HID_FUNC_GAMMALN_MS">Returns the natural logarithm
of the Gamma function: G(x).</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2913112"
role="code">GAMMALN.PRECISE(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id2914502" role="paragraph">
@@ -275,6 +292,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2913730" role="paragraph">
<item type="input">=GAMMALN.PRECISE(2)</item> yields 0.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id541640873986703"
localize="false"><literal>COM.MICROSOFT.GAMMALN.PRECISE</literal></paragraph>
</section>
<section id="gammadist">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150132"><bookmark_value>GAMMADIST function</bookmark_value>
@@ -306,7 +327,6 @@
<paragraph id="par_id2406201422414690" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_GAMMADIST_MS">Returns the values of a
Gamma distribution.</ahelp></paragraph>
<paragraph id="par_id24061422414690" role="paragraph" xml-lang="en-US">The
inverse function is GAMMAINV or GAMMA.INV.</paragraph>
<paragraph id="par_id2406201422405814" role="paragraph" xml-lang="en-US">This
function is similar to GAMMADIST and was introduced for interoperability with
other office suites.</paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id240620142238475" role="code"
xml-lang="en-US">GAMMA.DIST(Number; Alpha; Beta; Cumulative)</paragraph>
<paragraph id="par_id2406201422385134" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value for which the Gamma
distribution is to be calculated.</paragraph>
@@ -315,6 +335,10 @@
<paragraph id="par_id2406201422391058" role="paragraph"
xml-lang="en-US"><emph>Cumulative</emph> = 0 or False calculates the
probability density function; <emph>Cumulative</emph> = 1, True, or any other
value calculates the cumulative distribution function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id2406201422392251" role="paragraph" xml-lang="en-US"><item
type="input">=GAMMA.DIST(2;1;1;1)</item> yields 0.86.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640273086703"
localize="false"><literal>COM.MICROSOFT.GAMMA.DIST</literal></paragraph>
</section>
<section id="gauss">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150272"><bookmark_value>GAUSS function</bookmark_value>
@@ -390,7 +414,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_Z_TEST_MS"
id="bm_id2947569" localize="false"/>
<h2 id="hd_id2953216">Z.TEST</h2>
<paragraph xml-lang="en-US" id="par_id2950758" role="paragraph"><ahelp
hid="HID_FUNC_Z_TEST_MS">Calculates the probability of observing a z-statistic
greater than the one computed based on a sample.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953274" role="code">Z.TEST(Data; mu [;
Sigma])</paragraph>
<paragraph xml-lang="en-US" id="par_id2956109"
role="paragraph"><emph>Data</emph> is the given sample, drawn from a normally
distributed population.</paragraph>
@@ -398,6 +421,10 @@
<paragraph xml-lang="en-US" id="par_id2954740"
role="paragraph"><emph>Sigma</emph> (optional) is the known standard deviation
of the population. If omitted, the standard deviation of the given sample is
used.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2948770" role="paragraph"><item
type="input">=Z.TEST(A2:A20; 9; 2)</item> returns the result of a z-test on a
sample A2:A20 drawn from a population with known mean 9 and known standard
deviation 2.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873986700"
localize="false"><literal>COM.MICROSOFT.Z.TEST</literal></paragraph>
</section>
<section id="harmean">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value>
@@ -446,7 +473,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYP_GEOM_DIST_MS"
id="bm_id2953910" localize="false"/>
<h2 id="hd_id2952801">HYPGEOM.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2959341" role="paragraph"><ahelp
hid="HID_FUNC_HYP_GEOM_DIST_MS">Returns the hypergeometric
distribution.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2955388" role="code">HYPGEOM.DIST(X;
NSample; Successes; NPopulation; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954933"
role="paragraph"><emph>X</emph> is the number of results achieved in the random
sample.</paragraph>
@@ -457,6 +483,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2954904" role="paragraph"><item
type="input">=HYPGEOM.DIST(2;2;90;100;0)</item> yields 0.8090909091. If 90 out
of 100 pieces of buttered toast fall from the table and hit the floor with the
buttered side first, then if 2 pieces of buttered toast are dropped from the
table, the probability is 81%, that both will strike buttered side
first.</paragraph>
<paragraph xml-lang="en-US" id="par_id2954905" role="paragraph"><item
type="input">=HYPGEOM.DIST(2;2;90;100;1)</item> yields 1.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986704"
localize="false"><literal>COM.MICROSOFT.HYPGEOM.DIST</literal></paragraph>
</section>
</sort>
<section id="relatedtopics">
diff --git a/source/text/scalc/01/04060183.xhp
b/source/text/scalc/01/04060183.xhp
index a4e5524bd..5a1344375 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -19,7 +19,6 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<meta>
<topic id="textscalc0104060183xml" indexer="include">
<title id="tit" xml-lang="en-US">Statistical Functions Part Three</title>
@@ -87,7 +86,6 @@
<h2 id="hd_id2953559">CONFIDENCE.T</h2>
<paragraph role="paragraph" id="par_id2953814" xml-lang="en-US">
<ahelp hid="HID_FUNC_CONFIDENCE_T">Returns the (1-alpha) confidence
interval for a Student's t distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2947501" xml-lang="en-US">CONFIDENCE.T(Alpha;
StDev; Size)</paragraph>
<paragraph role="paragraph" id="par_id2949872" xml-lang="en-US">
@@ -99,6 +97,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id2953335" xml-lang="en-US">
<item type="input">=CONFIDENCE.T(0.05;1.5;100)</item> gives
0.2976325427.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640973986703"
localize="false"><literal>COM.MICROSOFT.CONFIDENCE.T</literal></paragraph>
</section>
<section id="confidencedotnorm">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2853559"><bookmark_value>CONFIDENCE.NORM function</bookmark_value>
@@ -107,7 +109,6 @@
<h2 id="hd_id2853559">CONFIDENCE.NORM</h2>
<paragraph role="paragraph" id="par_id2853814" xml-lang="en-US">
<ahelp hid="HID_FUNC_CONFIDENCE_N">Returns the (1-alpha) confidence
interval for a normal distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2847501"
xml-lang="en-US">CONFIDENCE.NORM(Alpha; StDev; Size)</paragraph>
<paragraph role="paragraph" id="par_id2849872" xml-lang="en-US">
@@ -119,6 +120,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id2853335" xml-lang="en-US">
<item type="input">=CONFIDENCE.NORM(0.05;1.5;100)</item> gives
0.2939945977.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341340873986703"
localize="false"><literal>COM.MICROSOFT.CONFIDENCE.NORM</literal></paragraph>
</section>
<section id="correl">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148746"><bookmark_value>CORREL function</bookmark_value>
@@ -161,13 +166,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_P"
id="bm_id2952983" localize="false"/>
<h2 id="hd_id2950652">COVARIANCE.P</h2>
<paragraph role="paragraph" id="par_id2946875" xml-lang="en-US"><ahelp
hid="HID_FUNC_COVARIANCE_P">Returns the covariance of the product of paired
deviations, for the entire population.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2950740"
xml-lang="en-US">COVARIANCE.P(Data1; Data2)</paragraph>
<paragraph role="paragraph" id="par_id2945827"
xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph>
<paragraph role="paragraph" id="par_id2950465"
xml-lang="en-US"><emph>Data2</emph> is the second data set.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id2944748" xml-lang="en-US"><item
type="input">=COVARIANCE.P(A1:A30;B1:B30)</item></paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id641640873986703"
localize="false"><literal>COM.MICROSOFT.COVARIANCE.P</literal></paragraph>
</section>
<section id="covariancedots">
<bookmark xml-lang="en-US" branch="index" id="bm_id280652">
@@ -176,13 +184,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_S"
id="bm_id2852983" localize="false"/>
<h2 id="hd_id2850652">COVARIANCE.S</h2>
<paragraph role="paragraph" id="par_id2846875" xml-lang="en-US"><ahelp
hid="HID_FUNC_COVARIANCE_S">Returns the covariance of the product of paired
deviations, for a sample of the population.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2850740"
xml-lang="en-US">COVARIANCE.S(Data1; Data2)</paragraph>
<paragraph role="paragraph" id="par_id2845827"
xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph>
<paragraph role="paragraph" id="par_id2850465"
xml-lang="en-US"><emph>Data2</emph> is the second data set.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id2844748" xml-lang="en-US"><item
type="input">=COVARIANCE.S(A1:A30;B1:B30)</item></paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341670873986703"
localize="false"><literal>COM.MICROSOFT.COVARIANCE.S</literal></paragraph>
</section>
<section id="critbinom">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3147472"><bookmark_value>CRITBINOM function</bookmark_value>
@@ -245,7 +256,6 @@
<h2 id="hd_id2901928">LOGNORM.INV</h2>
<paragraph role="paragraph" id="par_id2901297" xml-lang="en-US"><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>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number
[; Mean [; StDev]])</paragraph>
<paragraph role="paragraph" id="par_id2901390" xml-lang="en-US">
@@ -257,6 +267,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id2901623" xml-lang="en-US">
<item type="input">=LOGNORM.INV(0.05;0;1)</item> returns
0.1930408167.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873906703"
localize="false"><literal>COM.MICROSOFT.LOGNORM.INV</literal></paragraph>
</section>
<section id="lognormdist">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3158417"><bookmark_value>LOGNORMDIST function</bookmark_value>
@@ -286,7 +300,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMDIST_MS"
id="bm_id2901366" localize="false"/>
<h2 id="hd_id2908417">LOGNORM.DIST</h2>
<paragraph role="paragraph" id="par_id2904953" xml-lang="en-US"><ahelp
hid="HID_FUNC_LOGNORMDIST_MS">Returns the values of a lognormal
distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2900686"
xml-lang="en-US">LOGNORM.DIST(Number; Mean; StDev; Cumulative)</paragraph>
<paragraph role="paragraph" id="par_id2904871" xml-lang="en-US">
@@ -300,6 +313,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id2909778" xml-lang="en-US">
<item type="input">=LOGNORM.DIST(0.1;0;1;1)</item> returns
0.0106510993.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341670873986703"
localize="false"><literal>COM.MICROSOFT.LOGNORM.DIST</literal></paragraph>
</section>
</sort>
<section id="relatedtopics">
diff --git a/source/text/scalc/01/04060184.xhp
b/source/text/scalc/01/04060184.xhp
index e73b6c04b..c3fb40e19 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -182,13 +182,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MS"
id="bm_id2949253" localize="false"/>
<h2 id="hd_id2953933">MODE.SNGL</h2>
<paragraph xml-lang="en-US" id="par_id2953085" role="paragraph"><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>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2955950" role="code">MODE.SNGL(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#number255"/>
<warning id="par_id2963792">If the data set contains no duplicate data points,
MODE.SNGL returns the #VALUE! error value.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953733" role="paragraph"><item
type="input">=MODE.SNGL(A1:A50)</item></paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341540873986703"
localize="false"><literal>COM.MICROSOFT.MODE.SNGL</literal></paragraph>
</section>
<section id="modedotmult">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2853933"><bookmark_value>MODE.MULT function</bookmark_value>
@@ -197,16 +200,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MULTI"
id="bm_id2849253" localize="false"/>
<h2 id="hd_id2853933">MODE.MULT</h2>
<paragraph xml-lang="en-US" id="par_id2853085" role="paragraph"><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>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-
<paragraph xml-lang="en-US" id="par_id2855950" role="code">MODE.MULT(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
<embed href="text/scalc/01/ful_func.xhp#number255"/>
-
-
<warning id="par_id2863792">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.</warning>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2853733" role="paragraph"><item
type="input">=MODE.MULT(A1:A50)</item></paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640875986703"
localize="false"><literal>COM.MICROSOFT.MODE.MULT</literal></paragraph>
</section>
<section id="negbinomdist">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149879"><bookmark_value>NEGBINOMDIST function</bookmark_value>
@@ -231,7 +234,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMDIST_MS"
id="bm_id2959135" localize="false"/>
<h2 id="hd_id2949879">NEGBINOM.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2955437" role="paragraph"><ahelp
hid="HID_FUNC_NEGBINOMDIST_MS">Returns the negative binomial density or
distribution function.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2950935" role="code">NEGBINOM.DIST(X; R;
SP; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2953044" role="paragraph"><emph>X</emph>
represents the value returned for unsuccessful tests.</paragraph>
@@ -241,6 +243,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2948770" role="paragraph"><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"><item
type="input">=NEGBINOM.DIST(1;1;0.5;1)</item> returns 0.75.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873985703"
localize="false"><literal>COM.MICROSOFT.NEGBINOM.DIST</literal></paragraph>
</section>
<section id="norminv">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155516"><bookmark_value>NORMINV function</bookmark_value>
@@ -265,7 +271,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV_MS"
id="bm_id2949396" localize="false"/>
<h2 id="hd_id2955516">NORM.INV</h2>
<paragraph xml-lang="en-US" id="par_id2954634" role="paragraph"><ahelp
hid="HID_FUNC_NORMINV_MS">Returns the inverse of the normal cumulative
distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2947534" role="code">NORM.INV(Number;
Mean; StDev)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954950"
role="paragraph"><emph>Number</emph> represents the probability value used to
determine the inverse normal distribution.</paragraph>
@@ -274,6 +279,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953921" role="paragraph">
<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>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873966703"
localize="false"><literal>COM.MICROSOFT.NORM.INV</literal></paragraph>
</section>
<section id="normdist">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153722"><bookmark_value>NORMDIST function</bookmark_value>
@@ -301,7 +310,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMDIST_MS"
id="bm_id2917484" localize="false"/>
<h2 id="hd_id2913722">NORM.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2910386" role="paragraph"><ahelp
hid="HID_FUNC_NORMDIST_MS">Returns the density function or the normal
cumulative distribution.</ahelp></paragraph>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2910613" role="code">NORM.DIST(Number;
Mean; StDev; C)</paragraph>
<paragraph xml-lang="en-US" id="par_id2919820"
role="paragraph"><emph>Number</emph> is the value of the distribution based on
which the normal distribution is to be calculated.</paragraph>
@@ -313,6 +321,10 @@
<item type="input">=NORM.DIST(70;63;5;0)</item> returns
0.029945493.</paragraph>
<paragraph xml-lang="en-US" id="par_id2919448" role="paragraph">
<item type="input">=NORM.DIST(70;63;5;1)</item> returns
0.9192433408.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640373986703"
localize="false"><literal>COM.MICROSOFT.NORM.DIST</literal></paragraph>
</section>
<section id="pearson">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152934"><bookmark_value>PEARSON function</bookmark_value>
@@ -372,7 +384,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POISSON_DIST_MS"
id="bm_id2956011" localize="false"/>
<h2 id="hd_id2953985">POISSON.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2954298" role="paragraph"><ahelp
hid="HID_FUNC_POISSON_DIST_MS">Returns the Poisson
distribution.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2946093"
role="code">POISSON.DIST(Number; Mean ; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2947253"
role="paragraph"><emph>Number</emph> represents the value based on which the
Poisson distribution is calculated.</paragraph>
@@ -380,6 +391,10 @@
<paragraph xml-lang="en-US" id="par_id2949200"
role="paragraph"><emph>Cumulative</emph> = 0 or False to calculate the
probability mass function; <emph>Cumulative</emph> = 1, True, or any other
non-zero value to calculate the cumulative distribution function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2950113" role="paragraph"><item
type="input">=POISSON.DIST(60;50;1)</item> returns 0.9278398202.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341630873986703"
localize="false"><literal>COM.MICROSOFT.POISSON.DIST</literal></paragraph>
</section>
<section id="percentile">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153100"><bookmark_value>PERCENTILE function</bookmark_value>
@@ -404,13 +419,16 @@
<paragraph xml-lang="en-US" id="par_id2854940" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTILE_EXC">Returns the <item type="literal">Alpha</item>'th
percentile of a supplied range of values for a given value of <item
type="literal">Alpha</item>, within the range 0 to 1 (exclusive).</ahelp> A
percentile returns the scale value for a data series which goes from the
smallest (<item type="literal">Alpha=0</item>) to the largest value (<item
type="literal">Alpha=1</item>) of a data series. For <item
type="literal">Alpha</item> = 25%, the percentile means the first quartile;
<item type="literal">Alpha</item> = 50% is the MEDIAN.</paragraph>
<warning id="par_id2754940">If <item type="literal">Alpha</item> is not a
multiple of <item type="literal">1/(n+1)</item>, (where n is the number of
values in the supplied array), the function interpolates between the values in
the supplied array, to calculate the percentile value. However, if <item
type="literal">Alpha</item> is less than <item type="literal">1/(n+1)</item> or
<item type="literal">Alpha</item> is greater than <item
type="literal">n/(n+1)</item>, the function is unable to interpolate, and so
returns an error.</warning>
<note id="par_id2653976">The difference between <item
type="input">PERCENTILE.INC</item> and <item type="input">PERCENTILE.EXC</item>
is that, in the <item type="input">PERCENTILE.INC</item> function the value of
alpha is within the range 0 to 1 inclusive, and in the <item
type="input">PERCENTILE.EXC</item> function, the value of alpha is within the
range 0 to 1 exclusive.</note>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2848813"
role="code">PERCENTILE.EXC(Data; Alpha)</paragraph>
<paragraph xml-lang="en-US" id="par_id2853054"
role="paragraph"><emph>Data</emph> represents the array of data.</paragraph>
<paragraph xml-lang="en-US" id="par_id2854212"
role="paragraph"><emph>Alpha</emph> represents the percentage of the scale
between 0 and 1.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2859147" role="paragraph"><item
type="input">=PERCENTILE.EXC(A1:A50;10%)</item> represents the value in the
data set, which equals 10% of the total data scale in A1:A50.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id342640873986703"
localize="false"><literal>COM.MICROSOFT.PERCENTILE.EXC</literal></paragraph>
</section>
<section id="percentileinc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2953100"><bookmark_value>PERCENTILE.INC function</bookmark_value>
@@ -419,13 +437,16 @@
<h2 id="hd_id2953100">PERCENTILE.INC</h2>
<paragraph xml-lang="en-US" id="par_id2954940" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTILE_INC">Returns the alpha-percentile of data values in an
array.</ahelp> A percentile returns the scale value for a data series which
goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data
series. For <item type="literal">Alpha</item> = 25%, the percentile means the
first quartile; <item type="literal">Alpha</item> = 50% is the
MEDIAN.</paragraph>
<note id="par_id2753976">The difference between <item
type="input">PERCENTILE.INC</item> and <item type="input">PERCENTILE.EXC</item>
is that, in the <item type="input">PERCENTILE.INC</item> function the value of
alpha is within the range 0 to 1 inclusive, and in the <item
type="input">PERCENTILE.EXC</item> function, the value of alpha is within the
range 0 to 1 exclusive.</note>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2948813"
role="code">PERCENTILE.INC(Data; Alpha)</paragraph>
<paragraph xml-lang="en-US" id="par_id2953054"
role="paragraph"><emph>Data</emph> represents the array of data.</paragraph>
<paragraph xml-lang="en-US" id="par_id2954212"
role="paragraph"><emph>Alpha</emph> represents the percentage of the scale
between 0 and 1.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2959147" role="paragraph"><item
type="input">=PERCENTILE.INC(A1:A50;0.1)</item> represents the value in the
data set, which equals 10% of the total data scale in A1:A50.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341340873986703"
localize="false"><literal>COM.MICROSOFT.PERCENTILE.INC</literal></paragraph>
</section>
<section id="percentrank">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148807"><bookmark_value>PERCENTRANK function</bookmark_value>
@@ -449,7 +470,6 @@
<h2 id="hd_id2848807">PERCENTRANK.EXC</h2>
<paragraph xml-lang="en-US" id="par_id2853573" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTRANK_EXC"> Returns the relative position, between 0 and 1
(exclusive), of a specified value within a supplied array.</ahelp></paragraph>
<note id="par_id2553976">The difference between <item
type="input">PERCENTRANK.INC</item> and <item
type="input">PERCENTRANK.EXC</item> is that <item
type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1
inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function
calculates a value in the range 0 to 1 exclusive.</note>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2847238"
role="code">PERCENTRANK.EXC(Data; Value [; Significance])</paragraph>
<paragraph xml-lang="en-US" id="par_id2854266"
role="paragraph"><emph>Data</emph> represents the array of data in the
sample.</paragraph>
@@ -457,6 +477,10 @@
<paragraph xml-lang="en-US" id="par_id2748475"
role="paragraph"><emph>Significance</emph> An optional argument that specifies
the number of significant digits that the returned percentage value is rounded
to.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2849163" role="paragraph"><item
type="input">=PERCENTRANK.EXC(A1:A50;50)</item> returns the percentage rank of
the value 50 from the total range of all values found in A1:A50. If 50 falls
outside the total range, an error message will appear.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640878986703"
localize="false"><literal>COM.MICROSOFT.PERCENTRANK.EXC</literal></paragraph>
</section>
<section id="percentrankinc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2948807"><bookmark_value>PERCENTRANK.INC
function</bookmark_value></bookmark>
@@ -464,7 +488,6 @@
<h2 id="hd_id2948807">PERCENTRANK.INC</h2>
<paragraph xml-lang="en-US" id="par_id2953573" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTRANK_INC">Returns the relative position, between 0 and 1
(inclusive), of a specified value within a supplied array.</ahelp></paragraph>
<note id="par_id2453976">The difference between <item
type="input">PERCENTRANK.INC</item> and <item
type="input">PERCENTRANK.EXC</item> is that <item
type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1
inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function
calculates a value in the range 0 to 1 exclusive.</note>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2947238"
role="code">PERCENTRANK.INC(Data; Value [; Significance])</paragraph>
<paragraph xml-lang="en-US" id="par_id2954266"
role="paragraph"><emph>Data</emph> represents the array of data in the
sample.</paragraph>
@@ -472,6 +495,10 @@
<paragraph xml-lang="en-US" id="par_id2648475"
role="paragraph"><emph>Significance</emph> An optional argument that specifies
the number of significant digits that the returned percentage value is rounded
to.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2949163" role="paragraph"><item
type="input">=PERCENTRANK.INC(A1:A50;50)</item> returns the percentage rank of
the value 50 from the total range of all values found in A1:A50. If 50 falls
outside the total range, an error message will appear.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873086703"
localize="false"><literal>COM.MICROSOFT.PERCENTRANK.INC</literal></paragraph>
</section>
<section id="quartile">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3166442"><bookmark_value>QUARTILE function</bookmark_value>
@@ -495,7 +522,6 @@
<h2 id="hd_id2866442">QUARTILE.EXC</h2>
<paragraph xml-lang="en-US" id="par_id2846958" role="paragraph"><ahelp
hid="HID_FUNC_QUARTILE_EXC">Returns a requested quartile of a supplied range of
values, based on a percentile range of 0 to 1 exclusive.</ahelp></paragraph>
<note id="par_id2353976">The difference between <item
type="input">QUARTILE.INC</item> and <item type="input">QUARTILE.EXC</item> is
that the <item type="input">QUARTILE.INC</item> function bases its calculation
on a percentile range of 0 to 1 inclusive, whereas the <item
type="input">QUARTILE.EXC</item> function bases its calculation on a percentile
range of 0 to 1 exclusive.</note>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853684" role="code">QUARTILE.EXC(Data;
Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2853387"
role="paragraph"><emph>Data</emph> represents the range of data values for
which you want to calculate the specified quartile.</paragraph>
@@ -503,6 +529,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2859276" role="paragraph">
<item type="input">=QUARTILE.EXC(A1:A50;2)</item> returns the value of which
50% of the scale corresponds to the lowest to highest values in the range
A1:A50.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873986700"
localize="false"><literal>COM.MICROSOFT.QUARTILE.EXC</literal></paragraph>
</section>
<section id="quartileinc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id2966442"><bookmark_value>QUARTILE.INC function</bookmark_value>
@@ -511,7 +541,6 @@
<h2 id="hd_id2966442">QUARTILE.INC</h2>
<paragraph xml-lang="en-US" id="par_id2946958" role="paragraph"><ahelp
hid="HID_FUNC_QUARTILE_INC">Returns the quartile of a data
set.</ahelp></paragraph>
<note id="par_id2253976">The difference between <item
type="input">QUARTILE.INC</item> and <item type="input">QUARTILE.EXC</item> is
that the <item type="input">QUARTILE.INC</item> function bases its calculation
on a percentile range of 0 to 1 inclusive, whereas the <item
type="input">QUARTILE.EXC</item> function bases its calculation on a percentile
range of 0 to 1 exclusive.</note>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953684" role="code">QUARTILE.INC(Data;
Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2953387"
role="paragraph"><emph>Data</emph> represents the array of data in the
sample.</paragraph>
@@ -519,6 +548,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2959276" role="paragraph">
<item type="input">=QUARTILE.INC(A1:A50;2)</item> returns the value of which
50% of the scale corresponds to the lowest to highest values in the range
A1:A50.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873986707"
localize="false"><literal>COM.MICROSOFT.QUARTILE.INC</literal></paragraph>
</section>
</sort>
<section id="relatedtopics">
diff --git a/source/text/scalc/01/04060185.xhp
b/source/text/scalc/01/04060185.xhp
index 412625f74..9223f4a2b 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -61,7 +61,6 @@
<h2 id="hd_id2955071">RANK.AVG</h2>
<paragraph xml-lang="en-US" id="par_id2953976" role="paragraph"><ahelp
hid="HID_FUNC_RANK_AVG">Returns the statistical rank of a given value, within a
supplied array of values.</ahelp> If there are duplicate values in the list,
the average rank is returned.</paragraph>
<note id="par_id2653976">The difference between <item
type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when
there are duplicates in the list of values. The <item
type="input">RANK.EQ</item> function returns the lower rank, whereas the <item
type="input">RANK.AVG</item> function returns the average rank.</note>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953250" role="code">RANK.AVG(Value;
Data [; Type])</paragraph>
<paragraph xml-lang="en-US" id="par_id2954543"
role="paragraph"><emph>Value</emph> is the value, whose rank is to be
determined.</paragraph>
@@ -71,6 +70,10 @@
<paragraph xml-lang="en-US" id="par_id0996948" role="paragraph">Type = 1 means
ascending from the first item of the range to the last.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2955919" role="paragraph"><item
type="input">=RANK.AVG(A10;A1:A50)</item> returns the ranking of the value in
A10 in value range A1:A50. If <item type="literal">Value</item> does not exist
within the range an error message is displayed.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341640873886703"
localize="false"><literal>COM.MICROSOFT.RANK.AVG</literal></paragraph>
</section>
<section id="rankeq">
<bookmark xml-lang="en-US" branch="index" id="bm_id2855071">
@@ -81,7 +84,6 @@
<h2 id="hd_id2855071">RANK.EQ</h2>
<paragraph xml-lang="en-US" id="par_id2853976" role="paragraph"><ahelp
hid="HID_FUNC_RANK_EQ">Returns the statistical rank of a given value, within a
supplied array of values.</ahelp> If there are duplicate values in the list,
these are given the same rank.</paragraph>
<note id="par_id2753976">The difference between <item
type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when
there are duplicates in the list of values. The <item
type="input">RANK.EQ</item> function returns the lower rank, whereas the <item
type="input">RANK.AVG</item> function returns the average rank.</note>
-<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853250" role="code">RANK.EQ(Value; Data
[; Type])</paragraph>
<paragraph xml-lang="en-US" id="par_id2854543"
role="paragraph"><emph>Value</emph> is the value, whose rank is to be
determined.</paragraph>
@@ -91,6 +93,10 @@
<paragraph xml-lang="en-US" id="par_id89996948" role="paragraph">Type = 1
means ascending from the first item of the range to the last.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2855919" role="paragraph"><item
type="input">=RANK.EQ(A10;A1:A50)</item> returns the ranking of the value in
A10 in value range A1:A50. If <item type="literal">Value</item> does not exist
within the range an error message is displayed.</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
+<embed href="text/scalc/01/common_func.xhp#notODFF"/>
+<paragraph role="paragraph" id="par_id341040873966703"
localize="false"><literal>COM.MICROSOFT.RANK.EQ</literal></paragraph>
</section>
<section id="skew">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value>
@@ -150,6 +156,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3157875" role="paragraph">
<item type="input">=FORECAST.LINEAR(50;A1:A50;B1;B50)</item>
returns the Y value expected for the X value of 50 if the X and Y values in
both references are linked by a linear trend.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873980703"
localize="false"><literal>COM.MICROSOFT.FORECAST.LINEAR</literal></paragraph>
</section>
<section id="stdev">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149143"><bookmark_value>STDEV function</bookmark_value>
@@ -205,7 +214,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_P_MS"
id="bm_id2946139" localize="false"/>
<h2 id="hd_id2949734">STDEV.P</h2>
<paragraph xml-lang="en-US" id="par_id2949187" role="paragraph"><ahelp
hid="HID_FUNC_ST_DEV_P_MS">Calculates the standard deviation based on the
entire population.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2954392"
role="code">STDEV.P(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
@@ -213,8 +221,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953933" role="paragraph"><item
type="input">=STDEV.P(A1:A50)</item> returns a standard deviation of the data
referenced.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#notODFF"/>
- <paragraph role="paragraph" id="par_id341640873986703"
localize="false"><literal>COM.MICROSOFT.STDEV.P</literal></paragraph>
+ <paragraph role="paragraph" id="par_id341640873986700"
localize="false"><literal>COM.MICROSOFT.STDEV.P</literal></paragraph>
</section>
<section id="stdevdots">
<bookmark xml-lang="en-US" branch="index" id="bm_id2849734">
@@ -224,7 +233,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_S"
id="bm_id2846139" localize="false"/>
<h2 id="hd_id2849734">STDEV.S</h2>
<paragraph xml-lang="en-US" id="par_id2849187" role="paragraph"><ahelp
hid="HID_FUNC_ST_DEV_S">Calculates the standard deviation based on sample of
the population.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2854392"
role="code">STDEV.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
@@ -232,6 +240,10 @@
<paragraph id="par_id671585163972431" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2853933" role="paragraph"><item
type="input">=STDEV.S(A1:A50)</item> returns a standard deviation of the data
referenced.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id301640873986703"
localize="false"><literal>COM.MICROSOFT.STDEV.S</literal></paragraph>
</section>
<section id="stdevpa">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154522"><bookmark_value>STDEVPA function</bookmark_value>
@@ -288,7 +300,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMINV_MS"
id="bm_id2948389" localize="false"/>
<h2 id="hd_id2957986">NORM.S.INV</h2>
<paragraph xml-lang="en-US" id="par_id2951282"
role="paragraph"><ahelp hid="HID_FUNC_STD_NORMINV_MS">Returns the inverse of
the standard normal cumulative distribution.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2954195"
role="code">NORM.S.INV(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id2948772" role="paragraph">
@@ -296,6 +307,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2949030" role="paragraph">
<item type="input">=NORM.S.INV(0.908789)</item> returns
1.333334673.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341000873986703"
localize="false"><literal>COM.MICROSOFT.NORM.S.INV</literal></paragraph>
</section>
<section id="normsdist">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3147538"><bookmark_value>NORMSDIST function</bookmark_value>
@@ -320,7 +335,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMDIST_MS"
id="bm_id2945269" localize="false"/>
<h2 id="hd_id2947538">NORM.S.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2950474"
role="paragraph"><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>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2958411"
role="code">NORM.S.DIST(Number; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954950" role="paragraph">
@@ -332,6 +346,10 @@
<item type="input">=NORM.S.DIST(1;0)</item> returns
0.2419707245.</paragraph>
<paragraph xml-lang="en-US" id="par_id2955985" role="paragraph">
<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>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873980003"
localize="false"><literal>COM.MICROSOFT.NORM.S.DIST</literal></paragraph>
</section>
<section id="slope">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value>
@@ -409,13 +427,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_MS"
id="bm_id2953155" localize="false"/>
<h2 id="hd_id2949579">T.INV</h2>
<paragraph xml-lang="en-US" id="par_id2943232" role="paragraph"><ahelp
hid="HID_FUNC_TINV_MS">Returns the one tailed inverse of the
t-distribution.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2949289" role="code">T.INV(Number;
DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954070"
role="paragraph"><emph>Number</emph> is the probability associated with the
one-tailed t-distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2955315"
role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of
freedom for the t-distribution.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2956010" role="paragraph"><item
type="input">=T.INV(0.1;6)</item> returns -1.4397557473.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341000873986703"
localize="false"><literal>COM.MICROSOFT.T.INV</literal></paragraph>
</section>
<section id="tdotinvdot2t">
<bookmark xml-lang="en-US" branch="index" id="bm_id2849579">
@@ -425,13 +446,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_2T"
id="bm_id2853155" localize="false"/>
<h2 id="hd_id2849579">T.INV.2T</h2>
<paragraph xml-lang="en-US" id="par_id2843232" role="paragraph"><ahelp
hid="HID_FUNC_TINV_2T">Calculates the inverse of the two-tailed Student's T
Distribution </ahelp>, which is a continuous probability distribution that is
frequently used for testing hypotheses on small sample data sets.</paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2849289"
role="code">T.INV.2T(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2854070"
role="paragraph"><emph>Number</emph> is the probability associated with the
two-tailed t-distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2855315"
role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of
freedom for the t-distribution.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2856010" role="paragraph"><item
type="input">=T.INV.2T(0.25; 10)</item> returns 1.221255395.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986003"
localize="false"><literal>COM.MICROSOFT.T.INV.2T</literal></paragraph>
</section>
<section id="ttest">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value>
@@ -461,7 +485,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST_MS"
id="bm_id2953981" localize="false"/>
<h2 id="hd_id2954129">T.TEST</h2>
<paragraph xml-lang="en-US" id="par_id2959184" role="paragraph"><ahelp
hid="HID_FUNC_TTEST_MS">Returns the probability associated with a Student's
t-Test.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2951175" role="code">T.TEST(Data1;
Data2; Mode; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2949202"
role="paragraph"><emph>Data1</emph> is the dependent array or range of data for
the first record.</paragraph>
@@ -470,6 +493,10 @@
<paragraph xml-lang="en-US" id="par_id2955327"
role="paragraph"><emph>Type</emph> is the kind of t-test to perform. Type 1
means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3
means two samples, unequal variance (heteroscedastic).</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2950119" role="paragraph"><item
type="input">=T.TEST(A1:A50;B1:B50;2;2)</item></paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640844986703"
localize="false"><literal>COM.MICROSOFT.T.TEST</literal></paragraph>
</section>
<section id="tdist">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154930"><bookmark_value>TDIST function</bookmark_value>
@@ -499,7 +526,6 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_MS"
id="bm_id2953095" localize="false"/>
<h2 id="hd_id2954930">T.DIST</h2>
<paragraph xml-lang="en-US" id="par_id2953372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_MS">Returns the t-distribution.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2950521" role="code">T.DIST(Number;
DegreesFreedom; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2946991"
role="paragraph"><emph>Number</emph> is the value for which the t-distribution
is calculated.</paragraph>
@@ -507,6 +533,10 @@
<paragraph xml-lang="en-US" id="par_id2949340"
role="paragraph"><emph>Cumulative</emph> = 0 or FALSE returns the probability
density function, 1 or TRUE returns the cumulative distribution
function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2949773" role="paragraph"><item
type="input">=T.DIST(1; 10; TRUE)</item> returns 0.8295534338</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341330873986703"
localize="false"><literal>COM.MICROSOFT.T.DIST</literal></paragraph>
</section>
<section id="tdotdistdot2t">
<bookmark xml-lang="en-US" branch="index" id="bm_id2854930">
@@ -516,13 +546,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_2T"
id="bm_id2853095" localize="false"/>
<h2 id="hd_id2854930">T.DIST.2T</h2>
<paragraph xml-lang="en-US" id="par_id2853372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_2T">Calculates the two-tailed Student's T Distribution,
which is a continuous probability distribution that is frequently used for
testing hypotheses on small sample data sets.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2850521"
role="code">T.DIST.2T(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2846991"
role="paragraph"><emph>Number</emph> is the value for which the t-distribution
is calculated.</paragraph>
<paragraph xml-lang="en-US" id="par_id2848824"
role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of
freedom for the t-distribution.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2849773" role="paragraph"><item
type="input">=T.DIST.2T(1; 10)</item> returns 0.3408931323.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341655873986703"
localize="false"><literal>COM.MICROSOFT.T.DIST.2T</literal></paragraph>
</section>
<section id="tdotdistdotrt">
<bookmark xml-lang="en-US" branch="index" id="bm_id274930">
@@ -532,13 +565,16 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_RT"
id="bm_id273095" localize="false"/>
<h2 id="hd_id274930">T.DIST.RT</h2>
<paragraph xml-lang="en-US" id="par_id2753372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_RT">Calculates the right-tailed Student's T Distribution,
which is a continuous probability distribution that is frequently used for
testing hypotheses on small sample data sets.</ahelp></paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2750521"
role="code">T.DIST.RT(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2746991"
role="paragraph"><emph>Number</emph> is the value for which the t-distribution
is calculated.</paragraph>
<paragraph xml-lang="en-US" id="par_id2748824"
role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of
freedom for the t-distribution.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2749773" role="paragraph"><item
type="input">=T.DIST.RT(1; 10)</item> returns 0.1704465662.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
... etc. - the rest is truncated
