source/text/scalc/01/04060182.xhp | 14 +++++++++++
source/text/scalc/01/04060184.xhp | 47 ++++++++++++++++++++++++++++++++++++++
2 files changed, 61 insertions(+)
New commits:
commit 76e8934ce147560cd18db1f62885e05d4d9e530e
Author: Olivier Hallot <olivier.hal...@edx.srv.br>
Date: Sat Jul 19 23:12:26 2014 -0300
Fix fdo#80436 Help pages for MODE functions
MODE.SNGL, MODE.MULT, Z.TEST, NEGBINOM.DIST
Change-Id: I0e6ad33f76a09c9d4af7b8146d07eb4f1df86313
Reviewed-on: https://gerrit.libreoffice.org/10411
Reviewed-by: Caolán McNamara <caol...@redhat.com>
Tested-by: Caolán McNamara <caol...@redhat.com>
diff --git a/source/text/scalc/01/04060182.xhp
b/source/text/scalc/01/04060182.xhp
index 3d595d0..c3b2767 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -333,6 +333,20 @@
<emph>Sigma</emph> (optional) is the known standard deviation of
the population. If omitted, the standard deviation of the given sample is
used.</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372999"
role="paragraph" l10n="NEW">See also the <link
href="http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function";>Wiki
page</link>.</paragraph>
</section>
+<section id="zdottest">
+<bookmark xml-lang="en-US" branch="index"
id="bm_id2953216"><bookmark_value>Z.TEST function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_Z_TEST_MS"
id="bm_id2947569" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2953216" role="heading" level="2"
l10n="U" oldref="103">Z.TEST</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950758" role="paragraph" l10n="CHG"
oldref="104"><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>
+<paragraph xml-lang="en-US" id="hd_id2950872" role="heading" level="3"
l10n="U" oldref="105">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953274" role="code" l10n="CHG"
oldref="106">Z.TEST(Data; mu; Sigma)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2956109" role="paragraph" l10n="CHG"
oldref="107"><emph>Data</emph> is the given sample, drawn from a normally
distributed population.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2949977" role="paragraph" l10n="CHG"
oldref="108"><emph>mu</emph> is the known mean of the population.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2954740" role="paragraph" l10n="CHG"
oldref="109"><emph>Sigma</emph> (optional) is the known standard deviation of
the population. If omitted, the standard deviation of the given sample is
used.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2949539" role="heading" level="3"
l10n="U" oldref="58">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948770" role="paragraph" l10n="U"
oldref="59"><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>
+</section>
<section id="harmean">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value>
<bookmark_value>means;harmonic</bookmark_value>
diff --git a/source/text/scalc/01/04060184.xhp
b/source/text/scalc/01/04060184.xhp
index 12d3201..1cd71a2 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -184,6 +184,35 @@ oldref="48">Example</paragraph>
<item type="input">=MODE(A1:A50)</item>
</paragraph>
</section>
+
+<section id="modedotsngl">
+<bookmark xml-lang="en-US" branch="index"
id="bm_id2953933"><bookmark_value>MODE.SNGL function</bookmark_value>
+<bookmark_value>most common value</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MS"
id="bm_id2949253" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2953933" role="heading" level="2"
l10n="U" oldref="43">MODE.SNGL</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953085" role="paragraph" l10n="U"
oldref="44"><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>
+<paragraph xml-lang="en-US" id="hd_id2953003" role="heading" level="3"
l10n="U" oldref="45">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2955950" role="code" l10n="U"
oldref="46">MODE.SNGL(Number1; Number2; ...Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950337" role="paragraph" l10n="CHG"
oldref="47"><emph>Number1; Number2;...Number30</emph> are numerical values or
ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2963792" role="warning" l10n="CHG"
oldref="629">If the data set contains no duplicate data points, MODE.SNGL
returns the #VALUE! error value.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2953571" role="heading" level="3"
l10n="U" oldref="48">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953733" role="paragraph" l10n="U"
oldref="49"><item type="input">=MODE.SNGL(A1:A50)</item></paragraph>
+</section>
+<section id="modedotmult">
+<bookmark xml-lang="en-US" branch="index"
id="bm_id2853933"><bookmark_value>MODE.MULT function</bookmark_value>
+<bookmark_value>most common value</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MULTI"
id="bm_id2849253" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2853933" role="heading" level="2"
l10n="U" oldref="43">MODE.MULT</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853085" role="paragraph" l10n="U"
oldref="44"><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>
+<paragraph xml-lang="en-US" id="hd_id2853003" role="heading" level="3"
l10n="U" oldref="45">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2855950" role="code" l10n="U"
oldref="46">MODE.MULT(Number1; Number2; ...Number30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2850337" role="paragraph" l10n="CHG"
oldref="47"><emph>Number1; Number2;...Number30</emph> are numerical values or
ranges.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2863792" role="warning" l10n="CHG"
oldref="629">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.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2853571" role="heading" level="3"
l10n="U" oldref="48">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2853733" role="paragraph" l10n="U"
oldref="49"><item type="input">=MODE.MULT(A1:A50)</item></paragraph>
+</section>
<section id="negbinomdist">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149879"><bookmark_value>NEGBINOMDIST function</bookmark_value>
<bookmark_value>negative binomial distribution</bookmark_value>
@@ -203,6 +232,24 @@ oldref="58">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3148770" role="paragraph" l10n="U"
oldref="59">
<item type="input">=NEGBINOMDIST(1;1;0.5)</item> returns 0.25.</paragraph>
</section>
+<section id="negbinomdotdist">
+<bookmark xml-lang="en-US" branch="index"
id="bm_id2949879"><bookmark_value>NEGBINOM.DIST function</bookmark_value>
+<bookmark_value>negative binomial distribution</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMDIST_MS"
id="bm_id2959135" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2949879" role="heading" level="2"
l10n="U" oldref="51">NEGBINOM.DIST</paragraph>
+<paragraph xml-lang="en-US" id="par_id2955437" role="paragraph" l10n="U"
oldref="52"><ahelp hid="HID_FUNC_NEGBINOMDIST_MS">Returns the negative binomial
density or distribution function.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id2945351" role="heading" level="3" l10n="U"
+oldref="53">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id2950935" role="code" l10n="U"
oldref="54">NEGBINOM.DIST(X; R; SP; Cumulative)</paragraph>
+<paragraph xml-lang="en-US" id="par_id2953044" role="paragraph" l10n="U"
oldref="55"><emph>X</emph> represents the value returned for unsuccessful
tests.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2951018" role="paragraph" l10n="U"
oldref="56"><emph>R</emph> represents the value returned for successful
tests.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948878" role="paragraph" l10n="U"
oldref="57"><emph>SP</emph> is the probability of the success of an
attempt.</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948879" role="paragraph" l10n="U"
oldref="57"><emph>Cumulative</emph> = 0 calculates the density function,
<emph>Cumulative</emph> = 1 calculates the distribution.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id2949539" role="heading" level="3"
l10n="U" oldref="58">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id2948770" role="paragraph" l10n="U"
oldref="59"><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" l10n="U"
oldref="59"><item type="input">=NEGBINOM.DIST(1;1;0.5;1)</item> returns
0.75.</paragraph>
+</section>
<section id="norminv">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155516"><bookmark_value>NORMINV function</bookmark_value>
<bookmark_value>normal distribution;inverse of</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
