1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements.  See the NOTICE file
8 * distributed with this work for additional information
9 * regarding copyright ownership.  The ASF licenses this file
10 * to you under the Apache License, Version 2.0 (the
11 * "License"); you may not use this file except in compliance
12 * with the License.  You may obtain a copy of the License at
13 *
14 *   http://www.apache.org/licenses/LICENSE-2.0
15 *
16 * Unless required by applicable law or agreed to in writing,
17 * software distributed under the License is distributed on an
18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19 * KIND, either express or implied.  See the License for the
20 * specific language governing permissions and limitations
21 * under the License.
22 *
23 ***********************************************************-->
24
25
26
27
28<meta>
29      <topic id="textscalc0104060182xml" indexer="include">
30         <title xml-lang="en-US" id="tit">Statistical Functions Part Two</title>
31         <filename>/text/scalc/01/04060182.xhp</filename>
32      </topic>
33   </meta>
34   <body>
35      <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>
36</variable></paragraph>
37<sort order="asc">
38<section id="finv">
39<bookmark xml-lang="en-US" branch="index" id="bm_id3145388"><bookmark_value>FINV function</bookmark_value>
40         <bookmark_value>inverse F probability distribution</bookmark_value>
41</bookmark><comment>mw added one entry</comment>
42<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FINV" id="bm_id3146113" localize="false"/>
43<paragraph xml-lang="en-US" id="hd_id3145388" role="heading" level="2" l10n="U" oldref="2">FINV</paragraph>
44         <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>
45         <paragraph xml-lang="en-US" id="hd_id3153816" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph>
46         <paragraph xml-lang="en-US" id="par_id3153068" role="code" l10n="U" oldref="5">FINV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
47         <paragraph xml-lang="en-US" id="par_id3146866" role="paragraph" l10n="U" oldref="6">
48            <emph>Number</emph> is probability value for which the inverse F distribution is to be calculated.</paragraph>
49         <paragraph xml-lang="en-US" id="par_id3153914" role="paragraph" l10n="U" oldref="7">
50            <emph>DegreesFreedom1</emph> is the number of degrees of freedom in the numerator of the F distribution.</paragraph>
51         <paragraph xml-lang="en-US" id="par_id3148607" role="paragraph" l10n="U" oldref="8">
52            <emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution.</paragraph>
53         <paragraph xml-lang="en-US" id="hd_id3156021" role="heading" level="3" l10n="U" oldref="9">Example</paragraph>
54         <paragraph xml-lang="en-US" id="par_id3145073" role="paragraph" l10n="U" oldref="10">
55            <item type="input">=FINV(0.5;5;10)</item> yields 0.93.</paragraph>
56      </section>
57      <section id="fisher">
58<bookmark xml-lang="en-US" branch="index" id="bm_id3150888"><bookmark_value>FISHER function</bookmark_value>
59</bookmark>
60<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FISHER" id="bm_id3146782" localize="false"/>
61<paragraph xml-lang="en-US" id="hd_id3150888" role="heading" level="2" l10n="U"
62                    oldref="12">FISHER</paragraph>
63         <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>
64         <paragraph xml-lang="en-US" id="hd_id3149898" role="heading" level="3" l10n="U"
65                    oldref="14">Syntax</paragraph>
66         <paragraph xml-lang="en-US" id="par_id3143220" role="code" l10n="U" oldref="15">FISHER(Number)</paragraph>
67         <paragraph xml-lang="en-US" id="par_id3159228" role="paragraph" l10n="U" oldref="16">
68            <emph>Number</emph> is the value to be transformed.</paragraph>
69         <paragraph xml-lang="en-US" id="hd_id3154763" role="heading" level="3" l10n="U"
70                    oldref="17">Example</paragraph>
71         <paragraph xml-lang="en-US" id="par_id3149383" role="paragraph" l10n="U" oldref="18">
72            <item type="input">=FISHER(0.5)</item> yields 0.55.</paragraph>
73      </section>
74      <section id="fisherinv">
75<bookmark xml-lang="en-US" branch="index" id="bm_id3155758"><bookmark_value>FISHERINV function</bookmark_value>
76         <bookmark_value>inverse of Fisher transformation</bookmark_value>
77</bookmark><comment>mw added one entry</comment>
78<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FISHERINV" id="bm_id3149317" localize="false"/>
79<paragraph xml-lang="en-US" id="hd_id3155758" role="heading" level="2" l10n="U"
80                    oldref="20">FISHERINV</paragraph>
81         <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>
82         <paragraph xml-lang="en-US" id="hd_id3155755" role="heading" level="3" l10n="U"
83                    oldref="22">Syntax</paragraph>
84         <paragraph xml-lang="en-US" id="par_id3146108" role="code" l10n="U" oldref="23">FISHERINV(Number)</paragraph>
85         <paragraph xml-lang="en-US" id="par_id3145115" role="paragraph" l10n="U" oldref="24">
86            <emph>Number</emph> is the value that is to undergo reverse-transformation.</paragraph>
87         <paragraph xml-lang="en-US" id="hd_id3155744" role="heading" level="3" l10n="U"
88                    oldref="25">Example</paragraph>
89         <paragraph xml-lang="en-US" id="par_id3150432" role="paragraph" l10n="U" oldref="26">
90            <item type="input">=FISHERINV(0.5)</item> yields 0.46.</paragraph>
91      </section>
92      <section id="ftest">
93<bookmark xml-lang="en-US" branch="index" id="bm_id3151390"><bookmark_value>FTEST function</bookmark_value>
94</bookmark>
95<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FTEST" id="bm_id3159263" localize="false"/>
96<paragraph xml-lang="en-US" id="hd_id3151390" role="heading" level="2" l10n="U"
97                    oldref="28">FTEST</paragraph>
98         <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>
99         <paragraph xml-lang="en-US" id="hd_id3166466" role="heading" level="3" l10n="U"
100                    oldref="30">Syntax</paragraph>
101         <paragraph xml-lang="en-US" id="par_id3153024" role="code" l10n="U" oldref="31">FTEST(Data1; Data2)</paragraph>
102         <paragraph xml-lang="en-US" id="par_id3150032" role="paragraph" l10n="U" oldref="32">
103            <emph>Data1</emph> is the first record array.</paragraph>
104         <paragraph xml-lang="en-US" id="par_id3153018" role="paragraph" l10n="U" oldref="33">
105            <emph>Data2</emph> is the second record array.</paragraph>
106         <paragraph xml-lang="en-US" id="hd_id3153123" role="heading" level="3" l10n="U"
107                    oldref="34">Example</paragraph>
108         <paragraph xml-lang="en-US" id="par_id3159126" role="paragraph" l10n="U" oldref="35">
109            <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>
110      </section>
111      <section id="fdist">
112<bookmark xml-lang="en-US" branch="index" id="bm_id3150372"><bookmark_value>FDIST function</bookmark_value>
113</bookmark>
114<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FVERT" id="bm_id3149722" localize="false"/>
115<paragraph xml-lang="en-US" id="hd_id3150372" role="heading" level="2" l10n="U"
116                    oldref="37">FDIST</paragraph>
117         <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>
118         <paragraph xml-lang="en-US" id="hd_id3150484" role="heading" level="3" l10n="U"
119                    oldref="39">Syntax</paragraph>
120         <paragraph xml-lang="en-US" id="par_id3145826" role="code" l10n="U" oldref="40">FDIST(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
121         <paragraph xml-lang="en-US" id="par_id3150461" role="paragraph" l10n="U" oldref="41">
122            <emph>Number</emph> is the value for which the F distribution is to be calculated.</paragraph>
123         <paragraph xml-lang="en-US" id="par_id3150029" role="paragraph" l10n="U" oldref="42">
124            <emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution.</paragraph>
125         <paragraph xml-lang="en-US" id="par_id3146877" role="paragraph" l10n="U" oldref="43">
126            <emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph>
127         <paragraph xml-lang="en-US" id="hd_id3147423" role="heading" level="3" l10n="U"
128                    oldref="44">Example</paragraph>
129         <paragraph xml-lang="en-US" id="par_id3150696" role="paragraph" l10n="U" oldref="45">
130            <item type="input">=FDIST(0.8;8;12)</item> yields 0.61.</paragraph>
131      </section>
132      <section id="gamma">
133<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMA" id="bm_id0119200903221254" localize="false"/>
134<bookmark xml-lang="en-US" branch="index" id="bm_id0119200903223192"><bookmark_value>GAMMA function</bookmark_value>
135</bookmark>
136<paragraph xml-lang="en-US" id="hd_id0119200903205393" role="heading" level="2" l10n="NEW">GAMMA</paragraph>
137         <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>
138         <paragraph xml-lang="en-US" id="hd_id0119200903271613" role="heading" level="3" l10n="NEW">Syntax</paragraph>
139         <paragraph xml-lang="en-US" id="par_id0119200903271614" role="paragraph" l10n="NEW">
140            <emph>Number</emph> is the number for which the Gamma function value is to be calculated.</paragraph>
141      </section>
142      <section id="gammainv">
143<bookmark xml-lang="en-US" branch="index" id="bm_id3154841"><bookmark_value>GAMMAINV function</bookmark_value>
144</bookmark>
145<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMAINV" id="bm_id3149249" localize="false"/>
146<paragraph xml-lang="en-US" id="hd_id3154841" role="heading" level="2" l10n="U"
147                    oldref="47">GAMMAINV</paragraph>
148         <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>
149         <paragraph xml-lang="en-US" id="hd_id3149949" role="heading" level="3" l10n="U"
150                    oldref="49">Syntax</paragraph>
151         <paragraph xml-lang="en-US" id="par_id3155828" role="code" l10n="U" oldref="50">GAMMAINV(Number; Alpha; Beta)</paragraph>
152         <paragraph xml-lang="en-US" id="par_id3145138" role="paragraph" l10n="U" oldref="51">
153            <emph>Number</emph> is the probability value for which the inverse Gamma distribution is to be calculated.</paragraph>
154         <paragraph xml-lang="en-US" id="par_id3152785" role="paragraph" l10n="U" oldref="52">
155            <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
156         <paragraph xml-lang="en-US" id="par_id3154561" role="paragraph" l10n="U" oldref="53">
157            <emph>Beta</emph> is the parameter Beta of the Gamma distribution.</paragraph>
158         <paragraph xml-lang="en-US" id="hd_id3148734" role="heading" level="3" l10n="U"
159                    oldref="54">Example</paragraph>
160         <paragraph xml-lang="en-US" id="par_id3153331" role="paragraph" l10n="U" oldref="55">
161            <item type="input">=GAMMAINV(0.8;1;1)</item> yields 1.61.</paragraph>
162      </section>
163      <section id="gammaln">
164<bookmark xml-lang="en-US" branch="index" id="bm_id3154806"><bookmark_value>GAMMALN function</bookmark_value>
165         <bookmark_value>natural logarithm of Gamma function</bookmark_value>
166</bookmark><comment>mw added one entry</comment>
167<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMALN" id="bm_id3149511" localize="false"/>
168<paragraph xml-lang="en-US" id="hd_id3154806" role="heading" level="2" l10n="U"
169                    oldref="57">GAMMALN</paragraph>
170         <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>
171         <paragraph xml-lang="en-US" id="hd_id3152999" role="heading" level="3" l10n="U"
172                    oldref="59">Syntax</paragraph>
173         <paragraph xml-lang="en-US" id="par_id3153112" role="code" l10n="U" oldref="60">GAMMALN(Number)</paragraph>
174         <paragraph xml-lang="en-US" id="par_id3154502" role="paragraph" l10n="U" oldref="61">
175            <emph>Number</emph> is the value for which the natural logarithm of the Gamma function is to be calculated.</paragraph>
176         <paragraph xml-lang="en-US" id="hd_id3153568" role="heading" level="3" l10n="U"
177                    oldref="62">Example</paragraph>
178         <paragraph xml-lang="en-US" id="par_id3153730" role="paragraph" l10n="U" oldref="63">
179            <item type="input">=GAMMALN(2)</item> yields 0.</paragraph>
180      </section>
181      <section id="gammadist">
182<bookmark xml-lang="en-US" branch="index" id="bm_id3150132"><bookmark_value>GAMMADIST function</bookmark_value>
183</bookmark>
184<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMAVERT" id="bm_id3154330" localize="false"/>
185<paragraph xml-lang="en-US" id="hd_id3150132" role="heading" level="2" l10n="U"
186                    oldref="65">GAMMADIST</paragraph>
187         <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>
188         <paragraph xml-lang="en-US" id="par_id0119200903333675" role="paragraph" l10n="NEW">The inverse function is GAMMAINV.</paragraph>
189         <paragraph xml-lang="en-US" id="hd_id3147373" role="heading" level="3" l10n="U"
190                    oldref="67">Syntax</paragraph>
191         <paragraph xml-lang="en-US" id="par_id3155436" role="code" l10n="U" oldref="68">GAMMADIST(Number; Alpha; Beta; C)</paragraph>
192         <paragraph xml-lang="en-US" id="par_id3150571" role="paragraph" l10n="U" oldref="69">
193            <emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph>
194         <paragraph xml-lang="en-US" id="par_id3145295" role="paragraph" l10n="U" oldref="70">
195            <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
196         <paragraph xml-lang="en-US" id="par_id3151015" role="paragraph" l10n="U" oldref="71">
197            <emph>Beta</emph> is the parameter Beta of the Gamma distribution</paragraph>
198         <paragraph xml-lang="en-US" id="par_id3157972" role="paragraph" l10n="CHG" oldref="72">
199            <emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution.</paragraph>
200         <paragraph xml-lang="en-US" id="hd_id3149535" role="heading" level="3" l10n="U"
201                    oldref="73">Example</paragraph>
202         <paragraph xml-lang="en-US" id="par_id3145354" role="paragraph" l10n="U" oldref="74">
203            <item type="input">=GAMMADIST(2;1;1;1)</item> yields 0.86.</paragraph>
204      </section>
205      <section id="gauss">
206<bookmark xml-lang="en-US" branch="index" id="bm_id3150272"><bookmark_value>GAUSS function</bookmark_value>
207         <bookmark_value>normal distribution; standard</bookmark_value>
208</bookmark><comment>mw added one entry</comment>
209<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAUSS" id="bm_id3149388" localize="false"/>
210<paragraph xml-lang="en-US" id="hd_id3150272" role="heading" level="2" l10n="U"
211                    oldref="76">GAUSS</paragraph>
212         <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>
213         <paragraph xml-lang="en-US" id="par_id2059694" role="paragraph" l10n="NEW">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph>
214         <paragraph xml-lang="en-US" id="hd_id3153551" role="heading" level="3" l10n="U"
215                    oldref="78">Syntax</paragraph>
216         <paragraph xml-lang="en-US" id="par_id3155368" role="code" l10n="U" oldref="79">GAUSS(Number)</paragraph>
217         <paragraph xml-lang="en-US" id="par_id3153228" role="paragraph" l10n="CHG" oldref="80">
218            <emph>Number</emph> is the value for which the value of the standard normal distribution is to be calculated.</paragraph>
219         <paragraph xml-lang="en-US" id="hd_id3150691" role="heading" level="3" l10n="U"
220                    oldref="81">Example</paragraph>
221         <paragraph xml-lang="en-US" id="par_id3154867" role="paragraph" l10n="U" oldref="82">
222            <item type="input">=GAUSS(0.19)</item> = 0.08</paragraph>
223         <paragraph xml-lang="en-US" id="par_id3148594" role="paragraph" l10n="U" oldref="83">
224            <item type="input">=GAUSS(0.0375)</item> = 0.01</paragraph>
225      </section>
226      <section id="geomean">
227<bookmark xml-lang="en-US" branch="index" id="bm_id3148425"><bookmark_value>GEOMEAN function</bookmark_value>
228         <bookmark_value>means;geometric</bookmark_value>
229</bookmark><comment>mw added one entry</comment>
230<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GEOMITTEL" id="bm_id3149777" localize="false"/>
231<paragraph xml-lang="en-US" id="hd_id3148425" role="heading" level="2" l10n="U"
232                    oldref="85">GEOMEAN</paragraph>
233         <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>
234         <paragraph xml-lang="en-US" id="hd_id3147167" role="heading" level="3" l10n="U"
235                    oldref="87">Syntax</paragraph>
236         <paragraph xml-lang="en-US" id="par_id3153720" role="code" l10n="U" oldref="88">GEOMEAN(Number1; Number2; ...Number30)</paragraph>
237         <paragraph xml-lang="en-US" id="par_id3152585" role="paragraph" l10n="CHG" oldref="89">
238            <emph>Number1, Number2,...Number30</emph> are numeric arguments or ranges that represent a random sample.</paragraph>
239         <paragraph xml-lang="en-US" id="hd_id3146146" role="heading" level="3" l10n="U"
240                    oldref="90">Example</paragraph>
241         <paragraph xml-lang="en-US" id="par_id3149819" role="paragraph" l10n="U" oldref="92">
242            <item type="input">=GEOMEAN(23;46;69)</item> = 41.79. The geometric mean value of this random sample is therefore 41.79.</paragraph>
243      </section>
244      <section id="trimmean">
245<bookmark xml-lang="en-US" branch="index" id="bm_id3152966"><bookmark_value>TRIMMEAN function</bookmark_value>
246         <bookmark_value>means;of data set without margin data</bookmark_value>
247</bookmark><comment>mw added one entry</comment>
248<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GESTUTZTMITTEL" id="bm_id3145081" localize="false"/>
249<paragraph xml-lang="en-US" id="hd_id3152966" role="heading" level="2" l10n="U"
250                    oldref="94">TRIMMEAN</paragraph>
251         <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>
252         <paragraph xml-lang="en-US" id="hd_id3149281" role="heading" level="3" l10n="U"
253                    oldref="96">Syntax</paragraph>
254         <paragraph xml-lang="en-US" id="par_id3154821" role="code" l10n="U" oldref="97">TRIMMEAN(Data; Alpha)</paragraph>
255         <paragraph xml-lang="en-US" id="par_id3155834" role="paragraph" l10n="U" oldref="98">
256            <emph>Data</emph> is the array of data in the sample.</paragraph>
257         <paragraph xml-lang="en-US" id="par_id3156304" role="paragraph" l10n="U" oldref="99">
258            <emph>Alpha</emph> is the percentage of the marginal data that will not be taken into consideration.</paragraph>
259         <paragraph xml-lang="en-US" id="hd_id3151180" role="heading" level="3" l10n="U"
260                    oldref="100">Example</paragraph>
261         <paragraph xml-lang="en-US" id="par_id3156130" role="paragraph" l10n="U" oldref="101">
262            <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>
263      </section>
264      <section id="ztest">
265<bookmark xml-lang="en-US" branch="index" id="bm_id3153216"><bookmark_value>ZTEST function</bookmark_value>
266</bookmark>
267<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GTEST" id="bm_id3147569" localize="false"/>
268<paragraph xml-lang="en-US" id="hd_id3153216" role="heading" level="2" l10n="U"
269                    oldref="103">ZTEST</paragraph>
270         <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>
271         <paragraph xml-lang="en-US" id="hd_id3150872" role="heading" level="3" l10n="U"
272                    oldref="105">Syntax</paragraph>
273         <paragraph xml-lang="en-US" id="par_id3153274" role="code" l10n="CHG" oldref="106">ZTEST(Data; mu; Sigma)</paragraph>
274         <paragraph xml-lang="en-US" id="par_id3156109" role="paragraph" l10n="CHG" oldref="107">
275            <emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph>
276         <paragraph xml-lang="en-US" id="par_id3149977" role="paragraph" l10n="CHG" oldref="108">
277            <emph>mu</emph> is the known mean of the population.</paragraph>
278         <paragraph xml-lang="en-US" id="par_id3154740" role="paragraph" l10n="CHG" oldref="109">
279            <emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph>
280	 <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>
281      </section>
282      <section id="harmean">
283<bookmark xml-lang="en-US" branch="index" id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value>
284         <bookmark_value>means;harmonic</bookmark_value>
285</bookmark><comment>mw added one entry</comment>
286<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HARMITTEL" id="bm_id3154052" localize="false"/>
287<paragraph xml-lang="en-US" id="hd_id3153623" role="heading" level="2" l10n="U"
288                    oldref="113">HARMEAN</paragraph>
289         <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>
290         <paragraph xml-lang="en-US" id="hd_id3146900" role="heading" level="3" l10n="U"
291                    oldref="115">Syntax</paragraph>
292         <paragraph xml-lang="en-US" id="par_id3149287" role="code" l10n="U" oldref="116">HARMEAN(Number1; Number2; ...Number30)</paragraph>
293         <paragraph xml-lang="en-US" id="par_id3154303" role="paragraph" l10n="CHG" oldref="117">
294            <emph>Number1,Number2,...Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean.</paragraph>
295         <paragraph xml-lang="en-US" id="hd_id3159179" role="heading" level="3" l10n="U"
296                    oldref="118">Example</paragraph>
297         <paragraph xml-lang="en-US" id="par_id3146093" role="paragraph" l10n="U" oldref="120">
298            <item type="input">=HARMEAN(23;46;69)</item> = 37.64. The harmonic mean of this random sample is thus 37.64</paragraph>
299      </section>
300      <section id="hypgeomdist">
301<bookmark xml-lang="en-US" branch="index" id="bm_id3152801"><bookmark_value>HYPGEOMDIST function</bookmark_value>
302         <bookmark_value>sampling without replacement</bookmark_value>
303</bookmark><comment>mw added one entry</comment>
304<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYPGEOMVERT" id="bm_id3153910" localize="false"/>
305<paragraph xml-lang="en-US" id="hd_id3152801" role="heading" level="2" l10n="U"
306                    oldref="122">HYPGEOMDIST</paragraph>
307         <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>
308         <paragraph xml-lang="en-US" id="hd_id3154697" role="heading" level="3" l10n="U"
309                    oldref="124">Syntax</paragraph>
310         <paragraph xml-lang="en-US" id="par_id3155388" role="code" l10n="U" oldref="125">HYPGEOMDIST(X; NSample; Successes; NPopulation)</paragraph>
311         <paragraph xml-lang="en-US" id="par_id3154933" role="paragraph" l10n="U" oldref="126">
312            <emph>X</emph> is the number of results achieved in the random sample.</paragraph>
313         <paragraph xml-lang="en-US" id="par_id3153106" role="paragraph" l10n="U" oldref="127">
314            <emph>NSample</emph> is the size of the random sample.</paragraph>
315         <paragraph xml-lang="en-US" id="par_id3146992" role="paragraph" l10n="U" oldref="128">
316            <emph>Successes</emph> is the number of possible results in the total population.</paragraph>
317         <paragraph xml-lang="en-US" id="par_id3148826" role="paragraph" l10n="U" oldref="129">
318            <emph>NPopulation </emph>is the size of the total population.</paragraph>
319         <paragraph xml-lang="en-US" id="hd_id3150529" role="heading" level="3" l10n="U"
320                    oldref="130">Example</paragraph>
321         <paragraph xml-lang="en-US" id="par_id3154904" role="paragraph" l10n="U" oldref="131">
322            <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>
323      </section>
324</sort>
325<section id="relatedtopics">
326         <embed href="text/scalc/01/04060100.xhp#drking"/>
327      </section>
328   </body>
329</helpdocument>