diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060182.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/04060182.xhp | 23 |
1 files changed, 10 insertions, 13 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060182.xhp b/helpcontent2/source/text/scalc/01/04060182.xhp index 2c38afb43d..7ae9e6e869 100755 --- a/helpcontent2/source/text/scalc/01/04060182.xhp +++ b/helpcontent2/source/text/scalc/01/04060182.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -276,20 +276,17 @@ <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GTEST" id="bm_id3147569" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3153216" role="heading" level="2" l10n="U" oldref="103">ZTEST</paragraph> - <paragraph xml-lang="en-US" id="par_id3150758" role="paragraph" l10n="U" oldref="104"><ahelp hid="HID_FUNC_GTEST">Returns the two-tailed P value of a z test with standard distribution.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id3150758" role="paragraph" l10n="CHG" oldref="104"><ahelp hid="HID_FUNC_GTEST">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_id3150872" role="heading" level="3" l10n="U" oldref="105">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3153274" role="code" l10n="U" oldref="106">ZTEST(Data; Number; Sigma)</paragraph> - <paragraph xml-lang="en-US" id="par_id3156109" role="paragraph" l10n="U" oldref="107"> - <emph>Data</emph> is the array of the data.</paragraph> - <paragraph xml-lang="en-US" id="par_id3149977" role="paragraph" l10n="U" oldref="108"> - <emph>Number</emph> is the value to be tested.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154740" role="paragraph" l10n="U" oldref="109"> - <emph>Sigma</emph> (optional) is the standard deviation of the total population. If this argument is missing, the standard deviation of the sample in question will be processed.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3151289" role="heading" level="3" l10n="U" - oldref="110">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3153756" role="paragraph" l10n="U" oldref="111"> - <item type="input">=ZTEST(A1:A50;12)</item> yields the probability that value 12 belongs to the standard distribution of the total population of data in A1:A50.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153274" role="code" l10n="CHG" oldref="106">ZTEST(Data; mu; Sigma)</paragraph> + <paragraph xml-lang="en-US" id="par_id3156109" 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_id3149977" role="paragraph" l10n="CHG" oldref="108"> + <emph>mu</emph> is the known mean of the population.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154740" 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="par_id0305200911372999" role="paragraph" l10n="NEW">See also the <link href="http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_ZTEST_function">Wiki page</link>.</paragraph> </section> <section id="harmean"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value> |