diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060182.xhp')
-rwxr-xr-x | helpcontent2/source/text/scalc/01/04060182.xhp | 26 |
1 files changed, 10 insertions, 16 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060182.xhp b/helpcontent2/source/text/scalc/01/04060182.xhp index 2c38afb43d..c895f6e288 100755 --- a/helpcontent2/source/text/scalc/01/04060182.xhp +++ b/helpcontent2/source/text/scalc/01/04060182.xhp @@ -6,13 +6,10 @@ * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * - * Copyright 2008 by Sun Microsystems, Inc. + * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ - * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify @@ -276,20 +273,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> |