Update ooo320-m1
[ooovba.git] / helpcontent2 / source / text / scalc / 01 / 04060182.xhp
blob2c38afb43de4f35e7d046f56e261f8f2baaf848e
1 <?xml version="1.0" encoding="UTF-8"?>
2 <helpdocument version="1.0">
4 <!--
5 ***********************************************************************
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 *
9 * Copyright 2008 by Sun Microsystems, Inc.
11 * OpenOffice.org - a multi-platform office productivity suite
13 * $RCSfile: soffice2xmlhelp.xsl,v $
14 * $Revision: 1.10 $
16 * This file is part of OpenOffice.org.
18 * OpenOffice.org is free software: you can redistribute it and/or modify
19 * it under the terms of the GNU Lesser General Public License version 3
20 * only, as published by the Free Software Foundation.
22 * OpenOffice.org is distributed in the hope that it will be useful,
23 * but WITHOUT ANY WARRANTY; without even the implied warranty of
24 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
25 * GNU Lesser General Public License version 3 for more details
26 * (a copy is included in the LICENSE file that accompanied this code).
28 * You should have received a copy of the GNU Lesser General Public License
29 * version 3 along with OpenOffice.org. If not, see
30 * <http://www.openoffice.org/license.html>
31 * for a copy of the LGPLv3 License.
33 ************************************************************************
34 -->
37 <meta>
38 <topic id="textscalc0104060182xml" indexer="include">
39 <title xml-lang="en-US" id="tit">Statistical Functions Part Two</title>
40 <filename>/text/scalc/01/04060182.xhp</filename>
41 </topic>
42 </meta>
43 <body>
44 <paragraph xml-lang="en-US" id="hd_id3154372" role="heading" level="1" l10n="U" oldref="1"><variable id="fh"><link href="text/scalc/01/04060182.xhp" name="Statistical Functions Part Two">Statistical Functions Part Two</link>
45 </variable></paragraph>
46 <sort order="asc">
47 <section id="finv">
48 <bookmark xml-lang="en-US" branch="index" id="bm_id3145388"><bookmark_value>FINV function</bookmark_value>
49 <bookmark_value>inverse F probability distribution</bookmark_value>
50 </bookmark><comment>mw added one entry</comment>
51 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_FINV" id="bm_id3146113" localize="false"/>
52 <paragraph xml-lang="en-US" id="hd_id3145388" role="heading" level="2" l10n="U" oldref="2">FINV</paragraph>
53 <paragraph xml-lang="en-US" id="par_id3155089" role="paragraph" l10n="U" oldref="3"><ahelp hid="HID_FUNC_FINV">Returns the inverse of the F probability distribution.</ahelp> The F distribution is used for F tests in order to set the relation between two differing data sets.</paragraph>
54 <paragraph xml-lang="en-US" id="hd_id3153816" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph>
55 <paragraph xml-lang="en-US" id="par_id3153068" role="code" l10n="U" oldref="5">FINV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
56 <paragraph xml-lang="en-US" id="par_id3146866" role="paragraph" l10n="U" oldref="6">
57 <emph>Number</emph> is probability value for which the inverse F distribution is to be calculated.</paragraph>
58 <paragraph xml-lang="en-US" id="par_id3153914" role="paragraph" l10n="U" oldref="7">
59 <emph>DegreesFreedom1</emph> is the number of degrees of freedom in the numerator of the F distribution.</paragraph>
60 <paragraph xml-lang="en-US" id="par_id3148607" role="paragraph" l10n="U" oldref="8">
61 <emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution.</paragraph>
62 <paragraph xml-lang="en-US" id="hd_id3156021" role="heading" level="3" l10n="U" oldref="9">Example</paragraph>
63 <paragraph xml-lang="en-US" id="par_id3145073" role="paragraph" l10n="U" oldref="10">
64 <item type="input">=FINV(0.5;5;10)</item> yields 0.93.</paragraph>
65 </section>
66 <section id="fisher">
67 <bookmark xml-lang="en-US" branch="index" id="bm_id3150888"><bookmark_value>FISHER function</bookmark_value>
68 </bookmark>
69 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_FISHER" id="bm_id3146782" localize="false"/>
70 <paragraph xml-lang="en-US" id="hd_id3150888" role="heading" level="2" l10n="U"
71 oldref="12">FISHER</paragraph>
72 <paragraph xml-lang="en-US" id="par_id3155384" role="paragraph" l10n="U" oldref="13"><ahelp hid="HID_FUNC_FISHER">Returns the Fisher transformation for x and creates a function close to a normal distribution.</ahelp></paragraph>
73 <paragraph xml-lang="en-US" id="hd_id3149898" role="heading" level="3" l10n="U"
74 oldref="14">Syntax</paragraph>
75 <paragraph xml-lang="en-US" id="par_id3143220" role="code" l10n="U" oldref="15">FISHER(Number)</paragraph>
76 <paragraph xml-lang="en-US" id="par_id3159228" role="paragraph" l10n="U" oldref="16">
77 <emph>Number</emph> is the value to be transformed.</paragraph>
78 <paragraph xml-lang="en-US" id="hd_id3154763" role="heading" level="3" l10n="U"
79 oldref="17">Example</paragraph>
80 <paragraph xml-lang="en-US" id="par_id3149383" role="paragraph" l10n="U" oldref="18">
81 <item type="input">=FISHER(0.5)</item> yields 0.55.</paragraph>
82 </section>
83 <section id="fisherinv">
84 <bookmark xml-lang="en-US" branch="index" id="bm_id3155758"><bookmark_value>FISHERINV function</bookmark_value>
85 <bookmark_value>inverse of Fisher transformation</bookmark_value>
86 </bookmark><comment>mw added one entry</comment>
87 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_FISHERINV" id="bm_id3149317" localize="false"/>
88 <paragraph xml-lang="en-US" id="hd_id3155758" role="heading" level="2" l10n="U"
89 oldref="20">FISHERINV</paragraph>
90 <paragraph xml-lang="en-US" id="par_id3154734" role="paragraph" l10n="U" oldref="21"><ahelp hid="HID_FUNC_FISHERINV">Returns the inverse of the Fisher transformation for x and creates a function close to a normal distribution.</ahelp></paragraph>
91 <paragraph xml-lang="en-US" id="hd_id3155755" role="heading" level="3" l10n="U"
92 oldref="22">Syntax</paragraph>
93 <paragraph xml-lang="en-US" id="par_id3146108" role="code" l10n="U" oldref="23">FISHERINV(Number)</paragraph>
94 <paragraph xml-lang="en-US" id="par_id3145115" role="paragraph" l10n="U" oldref="24">
95 <emph>Number</emph> is the value that is to undergo reverse-transformation.</paragraph>
96 <paragraph xml-lang="en-US" id="hd_id3155744" role="heading" level="3" l10n="U"
97 oldref="25">Example</paragraph>
98 <paragraph xml-lang="en-US" id="par_id3150432" role="paragraph" l10n="U" oldref="26">
99 <item type="input">=FISHERINV(0.5)</item> yields 0.46.</paragraph>
100 </section>
101 <section id="ftest">
102 <bookmark xml-lang="en-US" branch="index" id="bm_id3151390"><bookmark_value>FTEST function</bookmark_value>
103 </bookmark>
104 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_FTEST" id="bm_id3159263" localize="false"/>
105 <paragraph xml-lang="en-US" id="hd_id3151390" role="heading" level="2" l10n="U"
106 oldref="28">FTEST</paragraph>
107 <paragraph xml-lang="en-US" id="par_id3150534" role="paragraph" l10n="U" oldref="29"><ahelp hid="HID_FUNC_FTEST">Returns the result of an F test.</ahelp></paragraph>
108 <paragraph xml-lang="en-US" id="hd_id3166466" role="heading" level="3" l10n="U"
109 oldref="30">Syntax</paragraph>
110 <paragraph xml-lang="en-US" id="par_id3153024" role="code" l10n="U" oldref="31">FTEST(Data1; Data2)</paragraph>
111 <paragraph xml-lang="en-US" id="par_id3150032" role="paragraph" l10n="U" oldref="32">
112 <emph>Data1</emph> is the first record array.</paragraph>
113 <paragraph xml-lang="en-US" id="par_id3153018" role="paragraph" l10n="U" oldref="33">
114 <emph>Data2</emph> is the second record array.</paragraph>
115 <paragraph xml-lang="en-US" id="hd_id3153123" role="heading" level="3" l10n="U"
116 oldref="34">Example</paragraph>
117 <paragraph xml-lang="en-US" id="par_id3159126" role="paragraph" l10n="U" oldref="35">
118 <item type="input">=FTEST(A1:A30;B1:B12)</item> calculates whether the two data sets are different in their variance and returns the probability that both sets could have come from the same total population.</paragraph>
119 </section>
120 <section id="fdist">
121 <bookmark xml-lang="en-US" branch="index" id="bm_id3150372"><bookmark_value>FDIST function</bookmark_value>
122 </bookmark>
123 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_FVERT" id="bm_id3149722" localize="false"/>
124 <paragraph xml-lang="en-US" id="hd_id3150372" role="heading" level="2" l10n="U"
125 oldref="37">FDIST</paragraph>
126 <paragraph xml-lang="en-US" id="par_id3152981" role="paragraph" l10n="U" oldref="38"><ahelp hid="HID_FUNC_FVERT">Calculates the values of an F distribution.</ahelp></paragraph>
127 <paragraph xml-lang="en-US" id="hd_id3150484" role="heading" level="3" l10n="U"
128 oldref="39">Syntax</paragraph>
129 <paragraph xml-lang="en-US" id="par_id3145826" role="code" l10n="U" oldref="40">FDIST(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
130 <paragraph xml-lang="en-US" id="par_id3150461" role="paragraph" l10n="U" oldref="41">
131 <emph>Number</emph> is the value for which the F distribution is to be calculated.</paragraph>
132 <paragraph xml-lang="en-US" id="par_id3150029" role="paragraph" l10n="U" oldref="42">
133 <emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution.</paragraph>
134 <paragraph xml-lang="en-US" id="par_id3146877" role="paragraph" l10n="U" oldref="43">
135 <emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph>
136 <paragraph xml-lang="en-US" id="hd_id3147423" role="heading" level="3" l10n="U"
137 oldref="44">Example</paragraph>
138 <paragraph xml-lang="en-US" id="par_id3150696" role="paragraph" l10n="U" oldref="45">
139 <item type="input">=FDIST(0.8;8;12)</item> yields 0.61.</paragraph>
140 </section>
141 <section id="gamma">
142 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMA" id="bm_id0119200903221254" localize="false"/>
143 <bookmark xml-lang="en-US" branch="index" id="bm_id0119200903223192"><bookmark_value>GAMMA function</bookmark_value>
144 </bookmark>
145 <paragraph xml-lang="en-US" id="hd_id0119200903205393" role="heading" level="2" l10n="NEW">GAMMA</paragraph>
146 <paragraph xml-lang="en-US" id="par_id0119200903205379" role="paragraph" l10n="NEW"><ahelp hid=".">Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST.</paragraph>
147 <paragraph xml-lang="en-US" id="hd_id0119200903271613" role="heading" level="3" l10n="NEW">Syntax</paragraph>
148 <paragraph xml-lang="en-US" id="par_id0119200903271614" role="paragraph" l10n="NEW">
149 <emph>Number</emph> is the number for which the Gamma function value is to be calculated.</paragraph>
150 </section>
151 <section id="gammainv">
152 <bookmark xml-lang="en-US" branch="index" id="bm_id3154841"><bookmark_value>GAMMAINV function</bookmark_value>
153 </bookmark>
154 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMAINV" id="bm_id3149249" localize="false"/>
155 <paragraph xml-lang="en-US" id="hd_id3154841" role="heading" level="2" l10n="U"
156 oldref="47">GAMMAINV</paragraph>
157 <paragraph xml-lang="en-US" id="par_id3153932" role="paragraph" l10n="U" oldref="48"><ahelp hid="HID_FUNC_GAMMAINV">Returns the inverse of the Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to search for variables with different distribution.</paragraph>
158 <paragraph xml-lang="en-US" id="hd_id3149949" role="heading" level="3" l10n="U"
159 oldref="49">Syntax</paragraph>
160 <paragraph xml-lang="en-US" id="par_id3155828" role="code" l10n="U" oldref="50">GAMMAINV(Number; Alpha; Beta)</paragraph>
161 <paragraph xml-lang="en-US" id="par_id3145138" role="paragraph" l10n="U" oldref="51">
162 <emph>Number</emph> is the probability value for which the inverse Gamma distribution is to be calculated.</paragraph>
163 <paragraph xml-lang="en-US" id="par_id3152785" role="paragraph" l10n="U" oldref="52">
164 <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
165 <paragraph xml-lang="en-US" id="par_id3154561" role="paragraph" l10n="U" oldref="53">
166 <emph>Beta</emph> is the parameter Beta of the Gamma distribution.</paragraph>
167 <paragraph xml-lang="en-US" id="hd_id3148734" role="heading" level="3" l10n="U"
168 oldref="54">Example</paragraph>
169 <paragraph xml-lang="en-US" id="par_id3153331" role="paragraph" l10n="U" oldref="55">
170 <item type="input">=GAMMAINV(0.8;1;1)</item> yields 1.61.</paragraph>
171 </section>
172 <section id="gammaln">
173 <bookmark xml-lang="en-US" branch="index" id="bm_id3154806"><bookmark_value>GAMMALN function</bookmark_value>
174 <bookmark_value>natural logarithm of Gamma function</bookmark_value>
175 </bookmark><comment>mw added one entry</comment>
176 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMALN" id="bm_id3149511" localize="false"/>
177 <paragraph xml-lang="en-US" id="hd_id3154806" role="heading" level="2" l10n="U"
178 oldref="57">GAMMALN</paragraph>
179 <paragraph xml-lang="en-US" id="par_id3148572" role="paragraph" l10n="U" oldref="58"><ahelp hid="HID_FUNC_GAMMALN">Returns the natural logarithm of the Gamma function: G(x).</ahelp></paragraph>
180 <paragraph xml-lang="en-US" id="hd_id3152999" role="heading" level="3" l10n="U"
181 oldref="59">Syntax</paragraph>
182 <paragraph xml-lang="en-US" id="par_id3153112" role="code" l10n="U" oldref="60">GAMMALN(Number)</paragraph>
183 <paragraph xml-lang="en-US" id="par_id3154502" role="paragraph" l10n="U" oldref="61">
184 <emph>Number</emph> is the value for which the natural logarithm of the Gamma function is to be calculated.</paragraph>
185 <paragraph xml-lang="en-US" id="hd_id3153568" role="heading" level="3" l10n="U"
186 oldref="62">Example</paragraph>
187 <paragraph xml-lang="en-US" id="par_id3153730" role="paragraph" l10n="U" oldref="63">
188 <item type="input">=GAMMALN(2)</item> yields 0.</paragraph>
189 </section>
190 <section id="gammadist">
191 <bookmark xml-lang="en-US" branch="index" id="bm_id3150132"><bookmark_value>GAMMADIST function</bookmark_value>
192 </bookmark>
193 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAMMAVERT" id="bm_id3154330" localize="false"/>
194 <paragraph xml-lang="en-US" id="hd_id3150132" role="heading" level="2" l10n="U"
195 oldref="65">GAMMADIST</paragraph>
196 <paragraph xml-lang="en-US" id="par_id3155931" role="paragraph" l10n="U" oldref="66"><ahelp hid="HID_FUNC_GAMMAVERT">Returns the values of a Gamma distribution.</ahelp></paragraph>
197 <paragraph xml-lang="en-US" id="par_id0119200903333675" role="paragraph" l10n="NEW">The inverse function is GAMMAINV.</paragraph>
198 <paragraph xml-lang="en-US" id="hd_id3147373" role="heading" level="3" l10n="U"
199 oldref="67">Syntax</paragraph>
200 <paragraph xml-lang="en-US" id="par_id3155436" role="code" l10n="U" oldref="68">GAMMADIST(Number; Alpha; Beta; C)</paragraph>
201 <paragraph xml-lang="en-US" id="par_id3150571" role="paragraph" l10n="U" oldref="69">
202 <emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph>
203 <paragraph xml-lang="en-US" id="par_id3145295" role="paragraph" l10n="U" oldref="70">
204 <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
205 <paragraph xml-lang="en-US" id="par_id3151015" role="paragraph" l10n="U" oldref="71">
206 <emph>Beta</emph> is the parameter Beta of the Gamma distribution</paragraph>
207 <paragraph xml-lang="en-US" id="par_id3157972" role="paragraph" l10n="CHG" oldref="72">
208 <emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution.</paragraph>
209 <paragraph xml-lang="en-US" id="hd_id3149535" role="heading" level="3" l10n="U"
210 oldref="73">Example</paragraph>
211 <paragraph xml-lang="en-US" id="par_id3145354" role="paragraph" l10n="U" oldref="74">
212 <item type="input">=GAMMADIST(2;1;1;1)</item> yields 0.86.</paragraph>
213 </section>
214 <section id="gauss">
215 <bookmark xml-lang="en-US" branch="index" id="bm_id3150272"><bookmark_value>GAUSS function</bookmark_value>
216 <bookmark_value>normal distribution; standard</bookmark_value>
217 </bookmark><comment>mw added one entry</comment>
218 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GAUSS" id="bm_id3149388" localize="false"/>
219 <paragraph xml-lang="en-US" id="hd_id3150272" role="heading" level="2" l10n="U"
220 oldref="76">GAUSS</paragraph>
221 <paragraph xml-lang="en-US" id="par_id3149030" role="paragraph" l10n="U" oldref="77"><ahelp hid="HID_FUNC_GAUSS">Returns the standard normal cumulative distribution.</ahelp></paragraph>
222 <paragraph xml-lang="en-US" id="par_id2059694" role="paragraph" l10n="NEW">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph>
223 <paragraph xml-lang="en-US" id="hd_id3153551" role="heading" level="3" l10n="U"
224 oldref="78">Syntax</paragraph>
225 <paragraph xml-lang="en-US" id="par_id3155368" role="code" l10n="U" oldref="79">GAUSS(Number)</paragraph>
226 <paragraph xml-lang="en-US" id="par_id3153228" role="paragraph" l10n="CHG" oldref="80">
227 <emph>Number</emph> is the value for which the value of the standard normal distribution is to be calculated.</paragraph>
228 <paragraph xml-lang="en-US" id="hd_id3150691" role="heading" level="3" l10n="U"
229 oldref="81">Example</paragraph>
230 <paragraph xml-lang="en-US" id="par_id3154867" role="paragraph" l10n="U" oldref="82">
231 <item type="input">=GAUSS(0.19)</item> = 0.08</paragraph>
232 <paragraph xml-lang="en-US" id="par_id3148594" role="paragraph" l10n="U" oldref="83">
233 <item type="input">=GAUSS(0.0375)</item> = 0.01</paragraph>
234 </section>
235 <section id="geomean">
236 <bookmark xml-lang="en-US" branch="index" id="bm_id3148425"><bookmark_value>GEOMEAN function</bookmark_value>
237 <bookmark_value>means;geometric</bookmark_value>
238 </bookmark><comment>mw added one entry</comment>
239 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GEOMITTEL" id="bm_id3149777" localize="false"/>
240 <paragraph xml-lang="en-US" id="hd_id3148425" role="heading" level="2" l10n="U"
241 oldref="85">GEOMEAN</paragraph>
242 <paragraph xml-lang="en-US" id="par_id3156257" role="paragraph" l10n="U" oldref="86"><ahelp hid="HID_FUNC_GEOMITTEL">Returns the geometric mean of a sample.</ahelp></paragraph>
243 <paragraph xml-lang="en-US" id="hd_id3147167" role="heading" level="3" l10n="U"
244 oldref="87">Syntax</paragraph>
245 <paragraph xml-lang="en-US" id="par_id3153720" role="code" l10n="U" oldref="88">GEOMEAN(Number1; Number2; ...Number30)</paragraph>
246 <paragraph xml-lang="en-US" id="par_id3152585" role="paragraph" l10n="CHG" oldref="89">
247 <emph>Number1, Number2,...Number30</emph> are numeric arguments or ranges that represent a random sample.</paragraph>
248 <paragraph xml-lang="en-US" id="hd_id3146146" role="heading" level="3" l10n="U"
249 oldref="90">Example</paragraph>
250 <paragraph xml-lang="en-US" id="par_id3149819" role="paragraph" l10n="U" oldref="92">
251 <item type="input">=GEOMEAN(23;46;69)</item> = 41.79. The geometric mean value of this random sample is therefore 41.79.</paragraph>
252 </section>
253 <section id="trimmean">
254 <bookmark xml-lang="en-US" branch="index" id="bm_id3152966"><bookmark_value>TRIMMEAN function</bookmark_value>
255 <bookmark_value>means;of data set without margin data</bookmark_value>
256 </bookmark><comment>mw added one entry</comment>
257 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GESTUTZTMITTEL" id="bm_id3145081" localize="false"/>
258 <paragraph xml-lang="en-US" id="hd_id3152966" role="heading" level="2" l10n="U"
259 oldref="94">TRIMMEAN</paragraph>
260 <paragraph xml-lang="en-US" id="par_id3149716" role="paragraph" l10n="U" oldref="95"><ahelp hid="HID_FUNC_GESTUTZTMITTEL">Returns the mean of a data set without the Alpha percent of data at the margins.</ahelp></paragraph>
261 <paragraph xml-lang="en-US" id="hd_id3149281" role="heading" level="3" l10n="U"
262 oldref="96">Syntax</paragraph>
263 <paragraph xml-lang="en-US" id="par_id3154821" role="code" l10n="U" oldref="97">TRIMMEAN(Data; Alpha)</paragraph>
264 <paragraph xml-lang="en-US" id="par_id3155834" role="paragraph" l10n="U" oldref="98">
265 <emph>Data</emph> is the array of data in the sample.</paragraph>
266 <paragraph xml-lang="en-US" id="par_id3156304" role="paragraph" l10n="U" oldref="99">
267 <emph>Alpha</emph> is the percentage of the marginal data that will not be taken into consideration.</paragraph>
268 <paragraph xml-lang="en-US" id="hd_id3151180" role="heading" level="3" l10n="U"
269 oldref="100">Example</paragraph>
270 <paragraph xml-lang="en-US" id="par_id3156130" role="paragraph" l10n="U" oldref="101">
271 <item type="input">=TRIMMEAN(A1:A50; 0.1)</item> calculates the mean value of numbers in A1:A50, without taking into consideration the 5 percent of the values representing the highest values and the 5 percent of the values representing the lowest ones. The percentage numbers refer to the amount of the untrimmed mean value, not to the number of summands.</paragraph>
272 </section>
273 <section id="ztest">
274 <bookmark xml-lang="en-US" branch="index" id="bm_id3153216"><bookmark_value>ZTEST function</bookmark_value>
275 </bookmark>
276 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GTEST" id="bm_id3147569" localize="false"/>
277 <paragraph xml-lang="en-US" id="hd_id3153216" role="heading" level="2" l10n="U"
278 oldref="103">ZTEST</paragraph>
279 <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>
280 <paragraph xml-lang="en-US" id="hd_id3150872" role="heading" level="3" l10n="U"
281 oldref="105">Syntax</paragraph>
282 <paragraph xml-lang="en-US" id="par_id3153274" role="code" l10n="U" oldref="106">ZTEST(Data; Number; Sigma)</paragraph>
283 <paragraph xml-lang="en-US" id="par_id3156109" role="paragraph" l10n="U" oldref="107">
284 <emph>Data</emph> is the array of the data.</paragraph>
285 <paragraph xml-lang="en-US" id="par_id3149977" role="paragraph" l10n="U" oldref="108">
286 <emph>Number</emph> is the value to be tested.</paragraph>
287 <paragraph xml-lang="en-US" id="par_id3154740" role="paragraph" l10n="U" oldref="109">
288 <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>
289 <paragraph xml-lang="en-US" id="hd_id3151289" role="heading" level="3" l10n="U"
290 oldref="110">Example</paragraph>
291 <paragraph xml-lang="en-US" id="par_id3153756" role="paragraph" l10n="U" oldref="111">
292 <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>
293 </section>
294 <section id="harmean">
295 <bookmark xml-lang="en-US" branch="index" id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value>
296 <bookmark_value>means;harmonic</bookmark_value>
297 </bookmark><comment>mw added one entry</comment>
298 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_HARMITTEL" id="bm_id3154052" localize="false"/>
299 <paragraph xml-lang="en-US" id="hd_id3153623" role="heading" level="2" l10n="U"
300 oldref="113">HARMEAN</paragraph>
301 <paragraph xml-lang="en-US" id="par_id3155102" role="paragraph" l10n="U" oldref="114"><ahelp hid="HID_FUNC_HARMITTEL">Returns the harmonic mean of a data set.</ahelp></paragraph>
302 <paragraph xml-lang="en-US" id="hd_id3146900" role="heading" level="3" l10n="U"
303 oldref="115">Syntax</paragraph>
304 <paragraph xml-lang="en-US" id="par_id3149287" role="code" l10n="U" oldref="116">HARMEAN(Number1; Number2; ...Number30)</paragraph>
305 <paragraph xml-lang="en-US" id="par_id3154303" role="paragraph" l10n="CHG" oldref="117">
306 <emph>Number1,Number2,...Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean.</paragraph>
307 <paragraph xml-lang="en-US" id="hd_id3159179" role="heading" level="3" l10n="U"
308 oldref="118">Example</paragraph>
309 <paragraph xml-lang="en-US" id="par_id3146093" role="paragraph" l10n="U" oldref="120">
310 <item type="input">=HARMEAN(23;46;69)</item> = 37.64. The harmonic mean of this random sample is thus 37.64</paragraph>
311 </section>
312 <section id="hypgeomdist">
313 <bookmark xml-lang="en-US" branch="index" id="bm_id3152801"><bookmark_value>HYPGEOMDIST function</bookmark_value>
314 <bookmark_value>sampling without replacement</bookmark_value>
315 </bookmark><comment>mw added one entry</comment>
316 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_HYPGEOMVERT" id="bm_id3153910" localize="false"/>
317 <paragraph xml-lang="en-US" id="hd_id3152801" role="heading" level="2" l10n="U"
318 oldref="122">HYPGEOMDIST</paragraph>
319 <paragraph xml-lang="en-US" id="par_id3159341" role="paragraph" l10n="U" oldref="123"><ahelp hid="HID_FUNC_HYPGEOMVERT">Returns the hypergeometric distribution.</ahelp></paragraph>
320 <paragraph xml-lang="en-US" id="hd_id3154697" role="heading" level="3" l10n="U"
321 oldref="124">Syntax</paragraph>
322 <paragraph xml-lang="en-US" id="par_id3155388" role="code" l10n="U" oldref="125">HYPGEOMDIST(X; NSample; Successes; NPopulation)</paragraph>
323 <paragraph xml-lang="en-US" id="par_id3154933" role="paragraph" l10n="U" oldref="126">
324 <emph>X</emph> is the number of results achieved in the random sample.</paragraph>
325 <paragraph xml-lang="en-US" id="par_id3153106" role="paragraph" l10n="U" oldref="127">
326 <emph>NSample</emph> is the size of the random sample.</paragraph>
327 <paragraph xml-lang="en-US" id="par_id3146992" role="paragraph" l10n="U" oldref="128">
328 <emph>Successes</emph> is the number of possible results in the total population.</paragraph>
329 <paragraph xml-lang="en-US" id="par_id3148826" role="paragraph" l10n="U" oldref="129">
330 <emph>NPopulation </emph>is the size of the total population.</paragraph>
331 <paragraph xml-lang="en-US" id="hd_id3150529" role="heading" level="3" l10n="U"
332 oldref="130">Example</paragraph>
333 <paragraph xml-lang="en-US" id="par_id3154904" role="paragraph" l10n="U" oldref="131">
334 <item type="input">=HYPGEOMDIST(2;2;90;100)</item> yields 0.81. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first.</paragraph>
335 </section>
336 </sort>
337 <section id="relatedtopics">
338 <embed href="text/scalc/01/04060100.xhp#drking"/>
339 </section>
340 </body>
341 </helpdocument>