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