[Libreoffice-commits] help.git: source/text
Olivier Hallot
olivier.hallot at edx.srv.br
Mon Jul 21 01:07:46 PDT 2014
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.hallot at 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 <caolanm at redhat.com>
Tested-by: Caolán McNamara <caolanm at 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>
More information about the Libreoffice-commits
mailing list