1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 302dbb15cSAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 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 12cdf0e10cSrcweir * 1302dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 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. 21cdf0e10cSrcweir * 2202dbb15cSAndrew Rist ***********************************************************--> 2302dbb15cSAndrew Rist 24695fa56cSmseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalc0104060183xml" indexer="include"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Statistical Functions Part Three</title> 28cdf0e10cSrcweir<filename>/text/scalc/01/04060183.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32*d5240548Smseidel<paragraph role="heading" id="hd_id3166425" xml-lang="en-US" level="1" l10n="U"><variable id="kl"><link href="text/scalc/01/04060183.xhp" name="Statistical Functions Part Three">Statistical Functions Part Three</link> 33cdf0e10cSrcweir</variable></paragraph> 34cdf0e10cSrcweir<sort order="asc"> 35cdf0e10cSrcweir<section id="large"> 3688cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3149530"> 3788cae784Smseidel<bookmark_value>LARGE function</bookmark_value> 38cdf0e10cSrcweir</bookmark> 39cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KGROESSTE" id="bm_id3150883" localize="false"/> 40*d5240548Smseidel<paragraph role="heading" id="hd_id3149530" xml-lang="en-US" level="2" l10n="U">LARGE</paragraph> 41*d5240548Smseidel<paragraph role="paragraph" id="par_id3150518" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_KGROESSTE">Returns the Rank_c-th largest value in a data set.</ahelp></paragraph> 42*d5240548Smseidel<paragraph role="heading" id="hd_id3152990" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 43*d5240548Smseidel<paragraph role="code" id="par_id3154372" xml-lang="en-US" l10n="U">LARGE(Data; RankC)</paragraph> 44*d5240548Smseidel<paragraph role="paragraph" id="par_id3152986" xml-lang="en-US" l10n="U"><emph>Data</emph> is the cell range of data.</paragraph> 45*d5240548Smseidel<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US" l10n="U"><emph>RankC</emph> is the ranking of the value.</paragraph> 46*d5240548Smseidel<paragraph role="heading" id="hd_id3152889" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 47*d5240548Smseidel<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US" l10n="U"><item type="input">=LARGE(A1:C50;2)</item> gives the second largest value in A1:C50.</paragraph> 48cdf0e10cSrcweir</section> 49cdf0e10cSrcweir<section id="small"> 5088cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154532"> 5188cae784Smseidel<bookmark_value>SMALL function</bookmark_value> 52cdf0e10cSrcweir</bookmark> 53cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KKLEINSTE" id="bm_id3148609" localize="false"/> 54*d5240548Smseidel<paragraph role="heading" id="hd_id3154532" xml-lang="en-US" level="2" l10n="U">SMALL</paragraph> 55*d5240548Smseidel<paragraph role="paragraph" id="par_id3157981" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_KKLEINSTE">Returns the Rank_c-th smallest value in a data set.</ahelp></paragraph> 56*d5240548Smseidel<paragraph role="heading" id="hd_id3154957" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 57*d5240548Smseidel<paragraph role="code" id="par_id3153974" xml-lang="en-US" l10n="U">SMALL(Data; RankC)</paragraph> 58*d5240548Smseidel<paragraph role="paragraph" id="par_id3154540" xml-lang="en-US" l10n="U"><emph>Data</emph> is the cell range of data.</paragraph> 59*d5240548Smseidel<paragraph role="paragraph" id="par_id3155094" xml-lang="en-US" l10n="U"><emph>RankC</emph> is the rank of the value.</paragraph> 60*d5240548Smseidel<paragraph role="heading" id="hd_id3153247" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 61*d5240548Smseidel<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US" l10n="U"><item type="input">=SMALL(A1:C50;2)</item> gives the second smallest value in A1:C50.</paragraph> 62cdf0e10cSrcweir</section> 63cdf0e10cSrcweir<section id="confidence"> 6488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153559"> 6588cae784Smseidel<bookmark_value>CONFIDENCE function</bookmark_value> 66cdf0e10cSrcweir</bookmark> 67cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KONFIDENZ" id="bm_id3153803" localize="false"/> 68*d5240548Smseidel<paragraph role="heading" id="hd_id3153559" xml-lang="en-US" level="2" l10n="U">CONFIDENCE</paragraph> 69*d5240548Smseidel<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_KONFIDENZ">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph> 70*d5240548Smseidel<paragraph role="heading" id="hd_id3149315" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 71*d5240548Smseidel<paragraph role="code" id="par_id3147501" xml-lang="en-US" l10n="U">CONFIDENCE(Alpha; StDev; Size)</paragraph> 72*d5240548Smseidel<paragraph role="paragraph" id="par_id3149872" xml-lang="en-US" l10n="U"><emph>Alpha</emph> is the level of the confidence interval.</paragraph> 73*d5240548Smseidel<paragraph role="paragraph" id="par_id3145324" xml-lang="en-US" l10n="U"><emph>StDev</emph> is the standard deviation for the total population.</paragraph> 74*d5240548Smseidel<paragraph role="paragraph" id="par_id3153075" xml-lang="en-US" l10n="U"><emph>Size</emph> is the size of the total population.</paragraph> 75*d5240548Smseidel<paragraph role="heading" id="hd_id3150435" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 76*d5240548Smseidel<paragraph role="paragraph" id="par_id3153335" xml-lang="en-US" l10n="U"><item type="input">=CONFIDENCE(0.05;1.5;100)</item> gives 0.29.</paragraph> 77cdf0e10cSrcweir</section> 78cdf0e10cSrcweir<section id="correl"> 7988cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3148746"> 8088cae784Smseidel<bookmark_value>CORREL function</bookmark_value> 81cdf0e10cSrcweir<bookmark_value>coefficient of correlation</bookmark_value> 82cdf0e10cSrcweir</bookmark><comment>mw added one entry</comment> 83cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KORREL" id="bm_id3147403" localize="false"/> 84*d5240548Smseidel<paragraph role="heading" id="hd_id3148746" xml-lang="en-US" level="2" l10n="U">CORREL</paragraph> 85*d5240548Smseidel<paragraph role="paragraph" id="par_id3147299" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_KORREL">Returns the correlation coefficient between two data sets.</ahelp></paragraph> 86*d5240548Smseidel<paragraph role="heading" id="hd_id3156397" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 87*d5240548Smseidel<paragraph role="code" id="par_id3153023" xml-lang="en-US" l10n="U">CORREL(Data1; Data2)</paragraph> 88*d5240548Smseidel<paragraph role="paragraph" id="par_id3150036" xml-lang="en-US" l10n="U"><emph>Data1</emph> is the first data set.</paragraph> 89*d5240548Smseidel<paragraph role="paragraph" id="par_id3153021" xml-lang="en-US" l10n="U"><emph>Data2</emph> is the second data set.</paragraph> 90*d5240548Smseidel<paragraph role="heading" id="hd_id3149720" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 91*d5240548Smseidel<paragraph role="paragraph" id="par_id3149941" xml-lang="en-US" l10n="U"><item type="input">=CORREL(A1:A50;B1:B50)</item> calculates the correlation coefficient as a measure of the linear correlation of the two data sets.</paragraph> 92cdf0e10cSrcweir</section> 93cdf0e10cSrcweir<section id="covar"> 9488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3150652"> 9588cae784Smseidel<bookmark_value>COVAR function</bookmark_value> 96cdf0e10cSrcweir</bookmark> 97cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOVAR" id="bm_id3152983" localize="false"/> 98*d5240548Smseidel<paragraph role="heading" id="hd_id3150652" xml-lang="en-US" level="2" l10n="U">COVAR</paragraph> 99*d5240548Smseidel<paragraph role="paragraph" id="par_id3146875" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_KOVAR">Returns the covariance of the product of paired deviations.</ahelp></paragraph> 100*d5240548Smseidel<paragraph role="heading" id="hd_id3149013" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 101*d5240548Smseidel<paragraph role="code" id="par_id3150740" xml-lang="en-US" l10n="U">COVAR(Data1; Data2)</paragraph> 102*d5240548Smseidel<paragraph role="paragraph" id="par_id3145827" xml-lang="en-US" l10n="U"><emph>Data1</emph> is the first data set.</paragraph> 103*d5240548Smseidel<paragraph role="paragraph" id="par_id3150465" xml-lang="en-US" l10n="U"><emph>Data2</emph> is the second data set.</paragraph> 104*d5240548Smseidel<paragraph role="heading" id="hd_id3154677" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 105*d5240548Smseidel<paragraph role="paragraph" id="par_id3144748" xml-lang="en-US" l10n="U"><item type="input">=COVAR(A1:A30;B1:B30)</item> 106cdf0e10cSrcweir</paragraph> 107cdf0e10cSrcweir</section> 108cdf0e10cSrcweir<section id="critbinom"> 10988cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3147472"> 11088cae784Smseidel<bookmark_value>CRITBINOM function</bookmark_value> 111cdf0e10cSrcweir</bookmark> 112cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KRITBINOM" id="bm_id3154848" localize="false"/> 113*d5240548Smseidel<paragraph role="heading" id="hd_id3147472" xml-lang="en-US" level="2" l10n="U">CRITBINOM</paragraph> 114*d5240548Smseidel<paragraph role="paragraph" id="par_id3149254" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_KRITBINOM">Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.</ahelp></paragraph> 115*d5240548Smseidel<paragraph role="heading" id="hd_id3153930" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 116*d5240548Smseidel<paragraph role="code" id="par_id3148586" xml-lang="en-US" l10n="U">CRITBINOM(Trials; SP; Alpha)</paragraph> 117*d5240548Smseidel<paragraph role="paragraph" id="par_id3145593" xml-lang="en-US" l10n="U"><emph>Trials</emph> is the total number of trials.</paragraph> 118*d5240548Smseidel<paragraph role="paragraph" id="par_id3153084" xml-lang="en-US" l10n="U"><emph>SP</emph> is the probability of success for one trial.</paragraph> 119*d5240548Smseidel<paragraph role="paragraph" id="par_id3149726" xml-lang="en-US" l10n="U"><emph>Alpha</emph> is the threshold probability to be reached or exceeded.</paragraph> 120*d5240548Smseidel<paragraph role="heading" id="hd_id3148752" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 121*d5240548Smseidel<paragraph role="paragraph" id="par_id3148740" xml-lang="en-US" l10n="U"><item type="input">=CRITBINOM(100;0.5;0.1)</item> yields 44.</paragraph> 122cdf0e10cSrcweir</section> 123cdf0e10cSrcweir<section id="kurt"> 12488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155956"> 12588cae784Smseidel<bookmark_value>KURT function</bookmark_value> 126cdf0e10cSrcweir</bookmark> 127cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KURT" id="bm_id3146847" localize="false"/> 128*d5240548Smseidel<paragraph role="heading" id="hd_id3155956" xml-lang="en-US" level="2" l10n="U">KURT</paragraph> 129*d5240548Smseidel<paragraph role="paragraph" id="par_id3153108" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_KURT">Returns the kurtosis of a data set (at least 4 values required).</ahelp></paragraph> 130*d5240548Smseidel<paragraph role="heading" id="hd_id3150334" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 131*d5240548Smseidel<paragraph role="code" id="par_id3154508" xml-lang="en-US" l10n="U">KURT(Number1; Number2; ...Number30)</paragraph> 132*d5240548Smseidel<paragraph role="paragraph" id="par_id3145167" xml-lang="en-US" l10n="CHG"><emph>Number1,Number2,...Number30</emph> are numeric arguments or ranges representing a random sample of distribution.</paragraph> 133*d5240548Smseidel<paragraph role="heading" id="hd_id3158000" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 134*d5240548Smseidel<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US" l10n="U"><item type="input">=KURT(A1;A2;A3;A4;A5;A6)</item> 135cdf0e10cSrcweir</paragraph> 136cdf0e10cSrcweir</section> 137cdf0e10cSrcweir<section id="loginv"> 13888cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3150928"> 13988cae784Smseidel<bookmark_value>LOGINV function</bookmark_value> 140cdf0e10cSrcweir<bookmark_value>inverse of lognormal distribution</bookmark_value> 141cdf0e10cSrcweir</bookmark><comment>mw added one entry</comment> 142cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGINV" id="bm_id3156062" localize="false"/> 143*d5240548Smseidel<paragraph role="heading" id="hd_id3150928" xml-lang="en-US" level="2" l10n="U">LOGINV</paragraph> 144*d5240548Smseidel<paragraph role="paragraph" id="par_id3145297" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_LOGINV">Returns the inverse of the lognormal distribution.</ahelp></paragraph> 145*d5240548Smseidel<paragraph role="heading" id="hd_id3151016" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 146*d5240548Smseidel<paragraph role="code" id="par_id3153049" xml-lang="en-US" l10n="U">LOGINV(Number; Mean; StDev)</paragraph> 147*d5240548Smseidel<paragraph role="paragraph" id="par_id3148390" xml-lang="en-US" l10n="U"><emph>Number</emph> is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> 148*d5240548Smseidel<paragraph role="paragraph" id="par_id3149538" xml-lang="en-US" l10n="U"><emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution.</paragraph> 149*d5240548Smseidel<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" l10n="U"><emph>StDev</emph> is the standard deviation of the standard logarithmic distribution.</paragraph> 150*d5240548Smseidel<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 151*d5240548Smseidel<paragraph role="paragraph" id="par_id3155623" xml-lang="en-US" l10n="U"><item type="input">=LOGINV(0.05;0;1)</item> returns 0.19.</paragraph> 152cdf0e10cSrcweir</section> 153cdf0e10cSrcweir<section id="lognormdist"> 15488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3158417"> 15588cae784Smseidel<bookmark_value>LOGNORMDIST function</bookmark_value> 156cdf0e10cSrcweir<bookmark_value>cumulative lognormal distribution</bookmark_value> 157cdf0e10cSrcweir</bookmark><comment>mw added one entry</comment> 158cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMVERT" id="bm_id3155366" localize="false"/> 159*d5240548Smseidel<paragraph role="heading" id="hd_id3158417" xml-lang="en-US" level="2" l10n="U">LOGNORMDIST</paragraph> 160*d5240548Smseidel<paragraph role="paragraph" id="par_id3154953" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_LOGNORMVERT">Returns the cumulative lognormal distribution.</ahelp></paragraph> 161*d5240548Smseidel<paragraph role="heading" id="hd_id3150474" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 162*d5240548Smseidel<paragraph role="code" id="par_id3150686" xml-lang="en-US" l10n="U">LOGNORMDIST(Number; Mean; StDev; Cumulative)</paragraph> 163*d5240548Smseidel<paragraph role="paragraph" id="par_id3154871" xml-lang="en-US" l10n="U"><emph>Number</emph> is the probability value for which the standard logarithmic distribution is to be calculated.</paragraph> 164*d5240548Smseidel<paragraph role="paragraph" id="par_id3155820" xml-lang="en-US" l10n="U"><emph>Mean</emph> (optional) is the mean value of the standard logarithmic distribution.</paragraph> 165*d5240548Smseidel<paragraph role="paragraph" id="par_id3155991" xml-lang="en-US" l10n="U"><emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution.</paragraph> 166*d5240548Smseidel<paragraph role="paragraph" id="par_id3155992" xml-lang="en-US" l10n="NEW"><emph>Cumulative</emph> (optional) = 0 calculates the density function, Cumulative = 1 calculates the distribution.</paragraph> 167*d5240548Smseidel<paragraph role="heading" id="hd_id3153178" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 168*d5240548Smseidel<paragraph role="paragraph" id="par_id3149778" xml-lang="en-US" l10n="U"><item type="input">=LOGNORMDIST(0.1;0;1)</item> returns 0.01.</paragraph> 169cdf0e10cSrcweir</section> 170cdf0e10cSrcweir</sort> 171cdf0e10cSrcweir<section id="relatedtopics"> 172cdf0e10cSrcweir<embed href="text/scalc/01/04060100.xhp#drking"/> 173cdf0e10cSrcweir</section> 174cdf0e10cSrcweir</body> 175cdf0e10cSrcweir</helpdocument> 176