1 <?xml version=
"1.0" encoding=
"UTF-8"?>
2 <helpdocument version=
"1.0">
5 ***********************************************************************
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 * Copyright 2008 by Sun Microsystems, Inc.
11 * OpenOffice.org - a multi-platform office productivity suite
13 * $RCSfile: soffice2xmlhelp.xsl,v $
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 ************************************************************************
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>
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>
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>
67 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3150888"><bookmark_value>FISHER function
</bookmark_value>
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>
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>
102 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3151390"><bookmark_value>FTEST function
</bookmark_value>
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>
121 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3150372"><bookmark_value>FDIST function
</bookmark_value>
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>
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>
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>
151 <section id=
"gammainv">
152 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3154841"><bookmark_value>GAMMAINV function
</bookmark_value>
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>
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>
190 <section id=
"gammadist">
191 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3150132"><bookmark_value>GAMMADIST function
</bookmark_value>
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>
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>
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>
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>
274 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3153216"><bookmark_value>ZTEST function
</bookmark_value>
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>
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>
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>
337 <section id=
"relatedtopics">
338 <embed href=
"text/scalc/01/04060100.xhp#drking"/>