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="textscalc0104060183xml" indexer="include"> 36<title id="tit" xml-lang="en-US">Statistical Functions Part Three</title> 37<filename>/text/scalc/01/04060183.xhp</filename> 38</topic> 39</meta> 40<body> 41<paragraph role="heading" id="hd_id3166425" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="kl"><link href="text/scalc/01/04060183.xhp" name="Statistical Functions Part Three">Statistical Functions Part Three</link> 42</variable></paragraph> 43<sort order="asc"> 44<section id="large"> 45<bookmark xml-lang="en-US" branch="index" id="bm_id3149530"><bookmark_value>LARGE function</bookmark_value> 46</bookmark> 47<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KGROESSTE" id="bm_id3150883" localize="false"/> 48<paragraph role="heading" id="hd_id3149530" xml-lang="en-US" level="2" l10n="U" oldref="2">LARGE</paragraph> 49<paragraph role="paragraph" id="par_id3150518" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_FUNC_KGROESSTE">Returns the Rank_c-th largest value in a data set.</ahelp></paragraph> 50<paragraph role="heading" id="hd_id3152990" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph> 51<paragraph role="code" id="par_id3154372" xml-lang="en-US" l10n="U" oldref="5">LARGE(Data; RankC)</paragraph> 52<paragraph role="paragraph" id="par_id3152986" xml-lang="en-US" l10n="U" oldref="6"> 53<emph>Data</emph> is the cell range of data.</paragraph> 54<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US" l10n="U" oldref="7"> 55<emph>RankC</emph> is the ranking of the value.</paragraph> 56<paragraph role="heading" id="hd_id3152889" xml-lang="en-US" level="3" l10n="U" oldref="8">Example</paragraph> 57<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US" l10n="U" oldref="9"> 58<item type="input">=LARGE(A1:C50;2)</item> gives the second largest value in A1:C50.</paragraph> 59</section> 60<section id="small"> 61<bookmark xml-lang="en-US" branch="index" id="bm_id3154532"><bookmark_value>SMALL function</bookmark_value> 62</bookmark> 63<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KKLEINSTE" id="bm_id3148609" localize="false"/> 64<paragraph role="heading" id="hd_id3154532" xml-lang="en-US" level="2" l10n="U" oldref="11">SMALL</paragraph> 65<paragraph role="paragraph" id="par_id3157981" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="HID_FUNC_KKLEINSTE">Returns the Rank_c-th smallest value in a data set.</ahelp></paragraph> 66<paragraph role="heading" id="hd_id3154957" xml-lang="en-US" level="3" l10n="U" oldref="13">Syntax</paragraph> 67<paragraph role="code" id="par_id3153974" xml-lang="en-US" l10n="U" oldref="14">SMALL(Data; RankC)</paragraph> 68<paragraph role="paragraph" id="par_id3154540" xml-lang="en-US" l10n="U" oldref="15"> 69<emph>Data</emph> is the cell range of data.</paragraph> 70<paragraph role="paragraph" id="par_id3155094" xml-lang="en-US" l10n="U" oldref="16"> 71<emph>RankC</emph> is the rank of the value.</paragraph> 72<paragraph role="heading" id="hd_id3153247" xml-lang="en-US" level="3" l10n="U" oldref="17">Example</paragraph> 73<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US" l10n="U" oldref="18"> 74<item type="input">=SMALL(A1:C50;2)</item> gives the second smallest value in A1:C50.</paragraph> 75</section> 76<section id="confidence"> 77<bookmark xml-lang="en-US" branch="index" id="bm_id3153559"><bookmark_value>CONFIDENCE function</bookmark_value> 78</bookmark> 79<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KONFIDENZ" id="bm_id3153803" localize="false"/> 80<paragraph role="heading" id="hd_id3153559" xml-lang="en-US" level="2" l10n="U" oldref="20">CONFIDENCE</paragraph> 81<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid="HID_FUNC_KONFIDENZ">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph> 82<paragraph role="heading" id="hd_id3149315" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph> 83<paragraph role="code" id="par_id3147501" xml-lang="en-US" l10n="U" oldref="23">CONFIDENCE(Alpha; StDev; Size)</paragraph> 84<paragraph role="paragraph" id="par_id3149872" xml-lang="en-US" l10n="U" oldref="24"> 85<emph>Alpha</emph> is the level of the confidence interval.</paragraph> 86<paragraph role="paragraph" id="par_id3145324" xml-lang="en-US" l10n="U" oldref="25"> 87<emph>StDev</emph> is the standard deviation for the total population.</paragraph> 88<paragraph role="paragraph" id="par_id3153075" xml-lang="en-US" l10n="U" oldref="26"> 89<emph>Size</emph> is the size of the total population.</paragraph> 90<paragraph role="heading" id="hd_id3150435" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph> 91<paragraph role="paragraph" id="par_id3153335" xml-lang="en-US" l10n="U" oldref="28"> 92<item type="input">=CONFIDENCE(0.05;1.5;100)</item> gives 0.29.</paragraph> 93</section> 94<section id="correl"> 95<bookmark xml-lang="en-US" branch="index" id="bm_id3148746"><bookmark_value>CORREL function</bookmark_value> 96<bookmark_value>coefficient of correlation</bookmark_value> 97</bookmark><comment>mw added one entry</comment> 98<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KORREL" id="bm_id3147403" localize="false"/> 99<paragraph role="heading" id="hd_id3148746" xml-lang="en-US" level="2" l10n="U" oldref="30">CORREL</paragraph> 100<paragraph role="paragraph" id="par_id3147299" xml-lang="en-US" l10n="U" oldref="31"><ahelp hid="HID_FUNC_KORREL">Returns the correlation coefficient between two data sets.</ahelp></paragraph> 101<paragraph role="heading" id="hd_id3156397" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph> 102<paragraph role="code" id="par_id3153023" xml-lang="en-US" l10n="U" oldref="33">CORREL(Data1; Data2)</paragraph> 103<paragraph role="paragraph" id="par_id3150036" xml-lang="en-US" l10n="U" oldref="34"> 104<emph>Data1</emph> is the first data set.</paragraph> 105<paragraph role="paragraph" id="par_id3153021" xml-lang="en-US" l10n="U" oldref="35"> 106<emph>Data2</emph> is the second data set.</paragraph> 107<paragraph role="heading" id="hd_id3149720" xml-lang="en-US" level="3" l10n="U" oldref="36">Example</paragraph> 108<paragraph role="paragraph" id="par_id3149941" xml-lang="en-US" l10n="U" oldref="37"> 109<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> 110</section> 111<section id="covar"> 112<bookmark xml-lang="en-US" branch="index" id="bm_id3150652"><bookmark_value>COVAR function</bookmark_value> 113</bookmark> 114<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOVAR" id="bm_id3152983" localize="false"/> 115<paragraph role="heading" id="hd_id3150652" xml-lang="en-US" level="2" l10n="U" oldref="39">COVAR</paragraph> 116<paragraph role="paragraph" id="par_id3146875" xml-lang="en-US" l10n="U" oldref="40"><ahelp hid="HID_FUNC_KOVAR">Returns the covariance of the product of paired deviations.</ahelp></paragraph> 117<paragraph role="heading" id="hd_id3149013" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph> 118<paragraph role="code" id="par_id3150740" xml-lang="en-US" l10n="U" oldref="42">COVAR(Data1; Data2)</paragraph> 119<paragraph role="paragraph" id="par_id3145827" xml-lang="en-US" l10n="U" oldref="43"> 120<emph>Data1</emph> is the first data set.</paragraph> 121<paragraph role="paragraph" id="par_id3150465" xml-lang="en-US" l10n="U" oldref="44"> 122<emph>Data2</emph> is the second data set.</paragraph> 123<paragraph role="heading" id="hd_id3154677" xml-lang="en-US" level="3" l10n="U" oldref="45">Example</paragraph> 124<paragraph role="paragraph" id="par_id3144748" xml-lang="en-US" l10n="U" oldref="46"> 125<item type="input">=COVAR(A1:A30;B1:B30)</item> 126</paragraph> 127</section> 128<section id="critbinom"> 129<bookmark xml-lang="en-US" branch="index" id="bm_id3147472"><bookmark_value>CRITBINOM function</bookmark_value> 130</bookmark> 131<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KRITBINOM" id="bm_id3154848" localize="false"/> 132<paragraph role="heading" id="hd_id3147472" xml-lang="en-US" level="2" l10n="U" oldref="48">CRITBINOM</paragraph> 133<paragraph role="paragraph" id="par_id3149254" xml-lang="en-US" l10n="U" oldref="49"><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> 134<paragraph role="heading" id="hd_id3153930" xml-lang="en-US" level="3" l10n="U" oldref="50">Syntax</paragraph> 135<paragraph role="code" id="par_id3148586" xml-lang="en-US" l10n="U" oldref="51">CRITBINOM(Trials; SP; Alpha)</paragraph> 136<paragraph role="paragraph" id="par_id3145593" xml-lang="en-US" l10n="U" oldref="52"> 137<emph>Trials</emph> is the total number of trials.</paragraph> 138<paragraph role="paragraph" id="par_id3153084" xml-lang="en-US" l10n="U" oldref="53"> 139<emph>SP</emph> is the probability of success for one trial.</paragraph> 140<paragraph role="paragraph" id="par_id3149726" xml-lang="en-US" l10n="U" oldref="54"> 141<emph>Alpha</emph> is the threshold probability to be reached or exceeded.</paragraph> 142<paragraph role="heading" id="hd_id3148752" xml-lang="en-US" level="3" l10n="U" oldref="55">Example</paragraph> 143<paragraph role="paragraph" id="par_id3148740" xml-lang="en-US" l10n="U" oldref="56"> 144<item type="input">=CRITBINOM(100;0.5;0.1)</item> yields 44.</paragraph> 145</section> 146<section id="kurt"> 147<bookmark xml-lang="en-US" branch="index" id="bm_id3155956"><bookmark_value>KURT function</bookmark_value> 148</bookmark> 149<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KURT" id="bm_id3146847" localize="false"/> 150<paragraph role="heading" id="hd_id3155956" xml-lang="en-US" level="2" l10n="U" oldref="58">KURT</paragraph> 151<paragraph role="paragraph" id="par_id3153108" xml-lang="en-US" l10n="U" oldref="59"><ahelp hid="HID_FUNC_KURT">Returns the kurtosis of a data set (at least 4 values required).</ahelp></paragraph> 152<paragraph role="heading" id="hd_id3150334" xml-lang="en-US" level="3" l10n="U" oldref="60">Syntax</paragraph> 153<paragraph role="code" id="par_id3154508" xml-lang="en-US" l10n="U" oldref="61">KURT(Number1; Number2; ...Number30)</paragraph> 154<paragraph role="paragraph" id="par_id3145167" xml-lang="en-US" l10n="CHG" oldref="62"> 155<emph>Number1,Number2,...Number30</emph> are numeric arguments or ranges representing a random sample of distribution.</paragraph> 156<paragraph role="heading" id="hd_id3158000" xml-lang="en-US" level="3" l10n="U" oldref="63">Example</paragraph> 157<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US" l10n="U" oldref="64"> 158<item type="input">=KURT(A1;A2;A3;A4;A5;A6)</item> 159</paragraph> 160</section> 161<section id="loginv"> 162<bookmark xml-lang="en-US" branch="index" id="bm_id3150928"><bookmark_value>LOGINV function</bookmark_value> 163<bookmark_value>inverse of lognormal distribution</bookmark_value> 164</bookmark><comment>mw added one entry</comment> 165<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGINV" id="bm_id3156062" localize="false"/> 166<paragraph role="heading" id="hd_id3150928" xml-lang="en-US" level="2" l10n="U" oldref="66">LOGINV</paragraph> 167<paragraph role="paragraph" id="par_id3145297" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_FUNC_LOGINV">Returns the inverse of the lognormal distribution.</ahelp></paragraph> 168<paragraph role="heading" id="hd_id3151016" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph> 169<paragraph role="code" id="par_id3153049" xml-lang="en-US" l10n="U" oldref="69">LOGINV(Number; Mean; StDev)</paragraph> 170<paragraph role="paragraph" id="par_id3148390" xml-lang="en-US" l10n="U" oldref="70"> 171<emph>Number</emph> is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> 172<paragraph role="paragraph" id="par_id3149538" xml-lang="en-US" l10n="U" oldref="71"> 173<emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution.</paragraph> 174<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" l10n="U" oldref="72"> 175<emph>StDev</emph> is the standard deviation of the standard logarithmic distribution.</paragraph> 176<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph> 177<paragraph role="paragraph" id="par_id3155623" xml-lang="en-US" l10n="U" oldref="74"> 178<item type="input">=LOGINV(0.05;0;1)</item> returns 0.19.</paragraph> 179</section> 180<section id="lognormdist"> 181<bookmark xml-lang="en-US" branch="index" id="bm_id3158417"><bookmark_value>LOGNORMDIST function</bookmark_value> 182<bookmark_value>cumulative lognormal distribution</bookmark_value> 183</bookmark><comment>mw added one entry</comment> 184<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMVERT" id="bm_id3155366" localize="false"/> 185<paragraph role="heading" id="hd_id3158417" xml-lang="en-US" level="2" l10n="U" oldref="76">LOGNORMDIST</paragraph> 186<paragraph role="paragraph" id="par_id3154953" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_LOGNORMVERT">Returns the cumulative lognormal distribution.</ahelp></paragraph> 187<paragraph role="heading" id="hd_id3150474" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph> 188<paragraph role="code" id="par_id3150686" xml-lang="en-US" l10n="U" oldref="79">LOGNORMDIST(Number; Mean; StDev; Cumulative)</paragraph> 189<paragraph role="paragraph" id="par_id3154871" xml-lang="en-US" l10n="U" oldref="80"> 190<emph>Number</emph> is the probability value for which the standard logarithmic distribution is to be calculated.</paragraph> 191<paragraph role="paragraph" id="par_id3155820" xml-lang="en-US" l10n="U" oldref="81"> 192<emph>Mean</emph> (optional) is the mean value of the standard logarithmic distribution.</paragraph> 193<paragraph role="paragraph" id="par_id3155991" xml-lang="en-US" l10n="U" oldref="82"> 194<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution.</paragraph> 195<paragraph role="paragraph" id="par_id3155992" xml-lang="en-US" l10n="NEW"> 196<emph>Cumulative</emph> (optional) = 0 calculates the density function, Cumulative = 1 calculates the distribution.</paragraph> 197<paragraph role="heading" id="hd_id3153178" xml-lang="en-US" level="3" l10n="U" oldref="83">Example</paragraph> 198<paragraph role="paragraph" id="par_id3149778" xml-lang="en-US" l10n="U" oldref="84"> 199<item type="input">=LOGNORMDIST(0.1;0;1)</item> returns 0.01.</paragraph> 200</section> 201</sort> 202<section id="relatedtopics"> 203<embed href="text/scalc/01/04060100.xhp#drking"/> 204</section> 205</body> 206</helpdocument> 207