diff options
Diffstat (limited to 'source/text/scalc/01/04060182.xhp')
| -rw-r--r-- | source/text/scalc/01/04060182.xhp | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index 3d595d033b..c3b2767b07 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> |