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