diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060183.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060183.xhp | 326 |
1 files changed, 326 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060183.xhp b/helpcontent2/source/text/scalc/01/04060183.xhp new file mode 100644 index 000000000..41b9d69ea --- /dev/null +++ b/helpcontent2/source/text/scalc/01/04060183.xhp @@ -0,0 +1,326 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> + +<meta> +<topic id="textscalc0104060183xml" indexer="include"> +<title id="tit" xml-lang="en-US">Statistical Functions Part Three</title> +<filename>/text/scalc/01/04060183.xhp</filename> +</topic> +</meta> +<body> +<h1 id="hd_id3166425"><variable id="kl"><link href="text/scalc/01/04060183.xhp" name="Statistical Functions Part Three">Statistical Functions Part Three</link> +</variable></h1> +<sort order="asc" descendant="h2"> +<section id="large"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3149530"><bookmark_value>LARGE function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KGROESSTE" id="bm_id3150883" localize="false"/> +<h2 id="hd_id3149530">LARGE</h2> +<paragraph role="paragraph" id="par_id3150518" xml-lang="en-US"><ahelp hid="HID_FUNC_KGROESSTE">Returns the Rank_c-th largest value in a data set.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3154372" xml-lang="en-US">LARGE(Data; RankC)</paragraph> +<paragraph role="paragraph" id="par_id3152986" xml-lang="en-US"><emph>Data</emph> is the cell range of data.</paragraph> +<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US"><emph>RankC</emph> is the ranking of the value. If RankC is an array, the function becomes an <link href="text/scalc/01/04060107.xhp" name="array function">array function</link>.</paragraph> +<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US"><input>=LARGE(A1:C50;2)</input> gives the second largest value in A1:C50.</paragraph> +<paragraph role="paragraph" id="par_id3248702" xml-lang="en-US"><input>=LARGE(A1:C50;B1:B5)</input> entered as an array function gives an array of the c-th largest value in A1:C50 with ranks defined in B1:B5.</paragraph> +</section> +<section id="small"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3154532"><bookmark_value>SMALL function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KKLEINSTE" id="bm_id3148609" localize="false"/> +<h2 id="hd_id3154532">SMALL</h2> +<paragraph role="paragraph" id="par_id3157981" xml-lang="en-US"><ahelp hid="HID_FUNC_KKLEINSTE">Returns the Rank_c-th smallest value in a data set.</ahelp></paragraph> +<embed href="text/scalc/01/ODFF.xhp#odff"/> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3153974" xml-lang="en-US">SMALL(Data; RankC)</paragraph> +<paragraph role="paragraph" id="par_id3154540" xml-lang="en-US"><emph>Data</emph> is the cell range of data.</paragraph> +<paragraph role="paragraph" id="par_id3155094" xml-lang="en-US"><emph>RankC</emph> is the rank of the value. If RankC is an array, the function becomes an <link href="text/scalc/01/04060107.xhp" name="array function">array function</link>.</paragraph> +<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US"><input>=SMALL(A1:C50;2)</input> gives the second smallest value in A1:C50.</paragraph> +<paragraph role="paragraph" id="par_id3249897" xml-lang="en-US"><input>=SMALL(A1:C50;B1:B5)</input> entered as an array function gives an array of the c-th smallest value in A1:C50 with ranks defined in B1:B5.</paragraph> +</section> +<section id="confidence"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153559"><bookmark_value>CONFIDENCE function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KONFIDENZ" id="bm_id3153803" localize="false"/> +<h2 id="hd_id3153559">CONFIDENCE</h2> +<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US"><ahelp hid="HID_FUNC_KONFIDENZ">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3147501" xml-lang="en-US">CONFIDENCE(Alpha; StDev; Size)</paragraph> +<paragraph role="paragraph" id="par_id3149872" xml-lang="en-US"> +<emph>Alpha</emph> is the level of the confidence interval.</paragraph> +<paragraph role="paragraph" id="par_id3145324" xml-lang="en-US"> +<emph>StDev</emph> is the standard deviation for the total population.</paragraph> +<paragraph role="paragraph" id="par_id3153075" xml-lang="en-US"> +<emph>Size</emph> is the size of the total population.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3153335" xml-lang="en-US"> +<item type="input">=CONFIDENCE(0.05;1.5;100)</item> gives 0.29.</paragraph> +</section> +<section id="confidencedott"> +<bookmark xml-lang="en-US" branch="index" id="bm_id2953559"><bookmark_value>CONFIDENCE.T function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CONFIDENCE_T" id="bm_id2953803" localize="false"/> +<h2 id="hd_id2953559">CONFIDENCE.T</h2> +<paragraph role="paragraph" id="par_id2953814" xml-lang="en-US"> + <ahelp hid="HID_FUNC_CONFIDENCE_T">Returns the (1-alpha) confidence interval for a Student's t distribution.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id2947501" xml-lang="en-US">CONFIDENCE.T(Alpha; StDev; Size)</paragraph> +<paragraph role="paragraph" id="par_id2949872" xml-lang="en-US"> +<emph>Alpha</emph> is the level of the confidence interval.</paragraph> +<paragraph role="paragraph" id="par_id2945324" xml-lang="en-US"> +<emph>StDev</emph> is the standard deviation for the total population.</paragraph> +<paragraph role="paragraph" id="par_id2953075" xml-lang="en-US"> +<emph>Size</emph> is the size of the total population.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id2953335" xml-lang="en-US"> +<item type="input">=CONFIDENCE.T(0.05;1.5;100)</item> gives 0.2976325427.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640973986703" localize="false"><literal>COM.MICROSOFT.CONFIDENCE.T</literal></paragraph> +</section> +<section id="confidencedotnorm"> +<bookmark xml-lang="en-US" branch="index" id="bm_id2853559"><bookmark_value>CONFIDENCE.NORM function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CONFIDENCE_N" id="bm_id2853803" localize="false"/> +<h2 id="hd_id2853559">CONFIDENCE.NORM</h2> +<paragraph role="paragraph" id="par_id2853814" xml-lang="en-US"> + <ahelp hid="HID_FUNC_CONFIDENCE_N">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id2847501" xml-lang="en-US">CONFIDENCE.NORM(Alpha; StDev; Size)</paragraph> +<paragraph role="paragraph" id="par_id2849872" xml-lang="en-US"> +<emph>Alpha</emph> is the level of the confidence interval.</paragraph> +<paragraph role="paragraph" id="par_id2845324" xml-lang="en-US"> +<emph>StDev</emph> is the standard deviation for the total population.</paragraph> +<paragraph role="paragraph" id="par_id2853075" xml-lang="en-US"> +<emph>Size</emph> is the size of the total population.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id2853335" xml-lang="en-US"> +<item type="input">=CONFIDENCE.NORM(0.05;1.5;100)</item> gives 0.2939945977.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341340873986703" localize="false"><literal>COM.MICROSOFT.CONFIDENCE.NORM</literal></paragraph> +</section> +<section id="correl"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148746"><bookmark_value>CORREL function</bookmark_value> +<bookmark_value>coefficient of correlation</bookmark_value> +</bookmark><comment>mw added one entry</comment> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KORREL" id="bm_id3147403" localize="false"/> +<h2 id="hd_id3148746">CORREL</h2> +<paragraph role="paragraph" id="par_id3147299" xml-lang="en-US"><ahelp hid="HID_FUNC_KORREL">Returns the correlation coefficient between two data sets.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3153023" xml-lang="en-US">CORREL(Data1; Data2)</paragraph> +<paragraph role="paragraph" id="par_id3150036" xml-lang="en-US"> +<emph>Data1</emph> is the first data set.</paragraph> +<paragraph role="paragraph" id="par_id3153021" xml-lang="en-US"> +<emph>Data2</emph> is the second data set.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3149941" xml-lang="en-US"> +<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> +</section> +<section id="covar"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150652"><bookmark_value>COVAR function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOVAR" id="bm_id3152983" localize="false"/> +<h2 id="hd_id3150652">COVAR</h2> +<paragraph role="paragraph" id="par_id3146875" xml-lang="en-US"><ahelp hid="HID_FUNC_KOVAR">Returns the covariance of the product of paired deviations.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3150740" xml-lang="en-US">COVAR(Data1; Data2)</paragraph> +<paragraph role="paragraph" id="par_id3145827" xml-lang="en-US"> +<emph>Data1</emph> is the first data set.</paragraph> +<paragraph role="paragraph" id="par_id3150465" xml-lang="en-US"> +<emph>Data2</emph> is the second data set.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3144748" xml-lang="en-US"> +<item type="input">=COVAR(A1:A30;B1:B30)</item> +</paragraph> +</section> +<section id="covariancedotp"> + <bookmark xml-lang="en-US" branch="index" id="bm_id2950652"> + <bookmark_value>COVARIANCE.P function</bookmark_value> + </bookmark> + <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_P" id="bm_id2952983" localize="false"/> + <h2 id="hd_id2950652">COVARIANCE.P</h2> + <paragraph role="paragraph" id="par_id2946875" xml-lang="en-US"><ahelp hid="HID_FUNC_COVARIANCE_P">Returns the covariance of the product of paired deviations, for the entire population.</ahelp></paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph role="code" id="par_id2950740" xml-lang="en-US">COVARIANCE.P(Data1; Data2)</paragraph> + <paragraph role="paragraph" id="par_id2945827" xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph> + <paragraph role="paragraph" id="par_id2950465" xml-lang="en-US"><emph>Data2</emph> is the second data set.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph role="paragraph" id="par_id2944748" xml-lang="en-US"><item type="input">=COVARIANCE.P(A1:A30;B1:B30)</item></paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id641640873986703" localize="false"><literal>COM.MICROSOFT.COVARIANCE.P</literal></paragraph> +</section> +<section id="covariancedots"> + <bookmark xml-lang="en-US" branch="index" id="bm_id280652"> + <bookmark_value>COVARIANCE.S function</bookmark_value> + </bookmark> + <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_S" id="bm_id2852983" localize="false"/> + <h2 id="hd_id2850652">COVARIANCE.S</h2> + <paragraph role="paragraph" id="par_id2846875" xml-lang="en-US"><ahelp hid="HID_FUNC_COVARIANCE_S">Returns the covariance of the product of paired deviations, for a sample of the population.</ahelp></paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph role="code" id="par_id2850740" xml-lang="en-US">COVARIANCE.S(Data1; Data2)</paragraph> + <paragraph role="paragraph" id="par_id2845827" xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph> + <paragraph role="paragraph" id="par_id2850465" xml-lang="en-US"><emph>Data2</emph> is the second data set.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph role="paragraph" id="par_id2844748" xml-lang="en-US"><item type="input">=COVARIANCE.S(A1:A30;B1:B30)</item></paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341670873986703" localize="false"><literal>COM.MICROSOFT.COVARIANCE.S</literal></paragraph> +</section> +<section id="critbinom"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3147472"><bookmark_value>CRITBINOM function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KRITBINOM" id="bm_id3154848" localize="false"/> +<h2 id="hd_id3147472">CRITBINOM</h2> +<paragraph role="paragraph" id="par_id3149254" xml-lang="en-US"><ahelp hid="HID_FUNC_KRITBINOM">Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3148586" xml-lang="en-US">CRITBINOM(Trials; SP; Alpha)</paragraph> +<paragraph role="paragraph" id="par_id3145593" xml-lang="en-US"> +<emph>Trials</emph> is the total number of trials.</paragraph> +<paragraph role="paragraph" id="par_id3153084" xml-lang="en-US"> +<emph>SP</emph> is the probability of success for one trial.</paragraph> +<paragraph role="paragraph" id="par_id3149726" xml-lang="en-US"> +<emph>Alpha</emph> is the threshold probability to be reached or exceeded.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3148740" xml-lang="en-US"> +<item type="input">=CRITBINOM(100;0.5;0.1)</item> yields 44.</paragraph> +</section> +<section id="kurt"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3155956"><bookmark_value>KURT function</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KURT" id="bm_id3146847" localize="false"/> +<h2 id="hd_id3155956">KURT</h2> +<paragraph role="paragraph" id="par_id3153108" xml-lang="en-US"><ahelp hid="HID_FUNC_KURT">Returns the kurtosis of a data set (at least 4 values required).</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3154508" xml-lang="en-US">KURT(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> +<embed href="text/scalc/01/ful_func.xhp#number255"/> +<paragraph id="par_id501585152669900" role="paragraph" xml-lang="en-US">The parameters should specify at least four values.</paragraph> +<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US"> +<item type="input">=KURT(A1;A2;A3;A4;A5;A6)</item> +</paragraph> +</section> +<section id="loginv"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150928"><bookmark_value>LOGINV function</bookmark_value> +<bookmark_value>inverse of lognormal distribution</bookmark_value> +</bookmark><comment>mw added one entry</comment> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGINV" id="bm_id3156062" localize="false"/> +<h2 id="hd_id3150928">LOGINV</h2> +<paragraph role="paragraph" id="par_id3145297" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGINV">Returns the inverse of the lognormal distribution.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3153049" xml-lang="en-US">LOGINV(Number [; Mean [; StDev]])</paragraph> +<paragraph role="paragraph" id="par_id3148390" xml-lang="en-US"> +<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> +<paragraph role="paragraph" id="par_id3149538" xml-lang="en-US"> +<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted).</paragraph> +<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US"> +<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted).</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3155623" xml-lang="en-US"> +<item type="input">=LOGINV(0.05;0;1)</item> returns 0.1930408167.</paragraph> +</section> +<section id="lognormdotinv"> +<bookmark xml-lang="en-US" branch="index" id="bm_id2901928"><bookmark_value>LOGNORM.INV function</bookmark_value> +<bookmark_value>inverse of lognormal distribution</bookmark_value> +</bookmark><comment>mw added one entry</comment> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGINV_MS" id="bm_id2901062" localize="false"/> +<h2 id="hd_id2901928">LOGNORM.INV</h2> +<paragraph role="paragraph" id="par_id2901297" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGINV_MS">Returns the inverse of the lognormal distribution.</ahelp></paragraph> +<paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This function is identical to LOGINV and was introduced for interoperability with other office suites.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number ; Mean ; StDev)</paragraph> +<paragraph role="paragraph" id="par_id2901390" xml-lang="en-US"> +<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> +<paragraph role="paragraph" id="par_id2901538" xml-lang="en-US"> +<emph>Mean</emph> (required) is the arithmetic mean of the standard logarithmic distribution.</paragraph> +<paragraph role="paragraph" id="par_id2901355" xml-lang="en-US"> +<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id2901623" xml-lang="en-US"> +<item type="input">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873906703" localize="false"><literal>COM.MICROSOFT.LOGNORM.INV</literal></paragraph> +</section> +<section id="lognormdist"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3158417"><bookmark_value>LOGNORMDIST function</bookmark_value> +<bookmark_value>lognormal distribution</bookmark_value> +</bookmark><comment>mw added one entry</comment> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMVERT" id="bm_id3155366" localize="false"/> +<h2 id="hd_id3158417">LOGNORMDIST</h2> +<paragraph role="paragraph" id="par_id3154953" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGNORMVERT">Returns the values of a lognormal distribution.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id3150686" xml-lang="en-US">LOGNORMDIST(Number [; Mean [; StDev [; Cumulative]]])</paragraph> +<paragraph role="paragraph" id="par_id3154871" xml-lang="en-US"> +<emph>Number</emph> is the probability value for which the standard logarithmic distribution is to be calculated.</paragraph> +<paragraph role="paragraph" id="par_id3155820" xml-lang="en-US"> +<emph>Mean</emph> (optional) is the mean value of the standard logarithmic distribution.</paragraph> +<paragraph role="paragraph" id="par_id3155991" xml-lang="en-US"> +<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution.</paragraph> +<paragraph role="paragraph" id="par_id3155992" xml-lang="en-US"> +<emph>Cumulative</emph> (optional) = 0 calculates the density function, Cumulative = 1 calculates the distribution.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id3149778" xml-lang="en-US"> +<item type="input">=LOGNORMDIST(0.1;0;1)</item> returns 0.01.</paragraph> +</section> +<section id="lognormdotdist"> +<bookmark xml-lang="en-US" branch="index" id="bm_id2901417"><bookmark_value>LOGNORM.DIST function</bookmark_value> +<bookmark_value>lognormal distribution</bookmark_value> +</bookmark><comment>mw added one entry</comment> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMDIST_MS" id="bm_id2901366" localize="false"/> +<h2 id="hd_id2908417">LOGNORM.DIST</h2> +<paragraph role="paragraph" id="par_id2904953" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGNORMDIST_MS">Returns the values of a lognormal distribution.</ahelp></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> +<paragraph role="code" id="par_id2900686" xml-lang="en-US">LOGNORM.DIST(Number; Mean; StDev; Cumulative)</paragraph> +<paragraph role="paragraph" id="par_id2904871" xml-lang="en-US"> +<emph>Number</emph> (required) is the probability value for which the standard logarithmic distribution is to be calculated.</paragraph> +<paragraph role="paragraph" id="par_id2905820" xml-lang="en-US"> +<emph>Mean</emph> (required) is the mean value of the standard logarithmic distribution.</paragraph> +<paragraph role="paragraph" id="par_id2905991" xml-lang="en-US"> +<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph> +<paragraph role="paragraph" id="par_id2905992" xml-lang="en-US"> +<emph>Cumulative</emph> (required) = 0 calculates the density function, Cumulative = 1 calculates the distribution.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> +<paragraph role="paragraph" id="par_id2909778" xml-lang="en-US"> +<item type="input">=LOGNORM.DIST(0.1;0;1;1)</item> returns 0.0106510993.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341670873986703" localize="false"><literal>COM.MICROSOFT.LOGNORM.DIST</literal></paragraph> +</section> +</sort> +<section id="relatedtopics"> +<embed href="text/scalc/01/04060100.xhp#drking"/> +</section> +</body> +</helpdocument> |