helpcontent2/source/text/scalc/01/04060183.xhp

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