diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2017-05-09 16:11:32 +0200 |
|---|---|---|
| committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2017-05-09 16:37:41 +0200 |
| commit | eb9ec1c794a0d3b8522375c7a87ac3ee999c8a66 (patch) | |
| tree | 4729b5cc168353458cda5d1b9ea3174a476c2b4b /source/text/scalc/01/04060183.xhp | |
| parent | 7897a9174b6b4a91134398359f3f1e690c774b69 (diff) | |
remove obsolete oldref attribute (removes one context line in pot)
also remove obsolete l10n attribute (doesn't affect translations/pot)
Change-Id: I809866ea7b16cb1cacad9efacb6fdeebae38ea9f
Diffstat (limited to 'source/text/scalc/01/04060183.xhp')
| -rw-r--r-- | source/text/scalc/01/04060183.xhp | 260 |
1 files changed, 130 insertions, 130 deletions
diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index 84be734981..73ce3af89d 100644 --- a/source/text/scalc/01/04060183.xhp +++ b/source/text/scalc/01/04060183.xhp @@ -27,95 +27,95 @@ </topic> </meta> <body> -<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> +<paragraph role="heading" id="hd_id3166425" xml-lang="en-US" level="1"><variable id="kl"><link href="text/scalc/01/04060183.xhp" name="Statistical Functions Part Three">Statistical Functions Part Three</link> </variable></paragraph> <sort order="asc"> <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"/> -<paragraph role="heading" id="hd_id3149530" xml-lang="en-US" level="2" l10n="U" oldref="2">LARGE</paragraph> -<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> -<paragraph role="heading" id="hd_id3152990" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph> -<paragraph role="code" id="par_id3154372" xml-lang="en-US" l10n="U" oldref="5">LARGE(Data; RankC)</paragraph> -<paragraph role="paragraph" id="par_id3152986" xml-lang="en-US" l10n="U" oldref="6"> +<paragraph role="heading" id="hd_id3149530" xml-lang="en-US" level="2">LARGE</paragraph> +<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> +<paragraph role="heading" id="hd_id3152990" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="7"> +<paragraph role="paragraph" id="par_id3156448" xml-lang="en-US"> <emph>RankC</emph> is the ranking of the value.</paragraph> -<paragraph role="heading" id="hd_id3152889" xml-lang="en-US" level="3" l10n="U" oldref="8">Example</paragraph> -<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US" l10n="U" oldref="9"> +<paragraph role="heading" id="hd_id3152889" xml-lang="en-US" level="3">Example</paragraph> +<paragraph role="paragraph" id="par_id3148702" xml-lang="en-US"> <item type="input">=LARGE(A1:C50;2)</item> gives the second largest value in A1:C50.</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"/> -<paragraph role="heading" id="hd_id3154532" xml-lang="en-US" level="2" l10n="U" oldref="11">SMALL</paragraph> -<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> -<paragraph role="heading" id="hd_id3154957" xml-lang="en-US" level="3" l10n="U" oldref="13">Syntax</paragraph> -<paragraph role="code" id="par_id3153974" xml-lang="en-US" l10n="U" oldref="14">SMALL(Data; RankC)</paragraph> -<paragraph role="paragraph" id="par_id3154540" xml-lang="en-US" l10n="U" oldref="15"> +<paragraph role="heading" id="hd_id3154532" xml-lang="en-US" level="2">SMALL</paragraph> +<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> +<paragraph role="heading" id="hd_id3154957" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="16"> +<paragraph role="paragraph" id="par_id3155094" xml-lang="en-US"> <emph>RankC</emph> is the rank of the value.</paragraph> -<paragraph role="heading" id="hd_id3153247" xml-lang="en-US" level="3" l10n="U" oldref="17">Example</paragraph> -<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US" l10n="U" oldref="18"> +<paragraph role="heading" id="hd_id3153247" xml-lang="en-US" level="3">Example</paragraph> +<paragraph role="paragraph" id="par_id3149897" xml-lang="en-US"> <item type="input">=SMALL(A1:C50;2)</item> gives the second smallest value in A1:C50.</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"/> -<paragraph role="heading" id="hd_id3153559" xml-lang="en-US" level="2" l10n="U" oldref="20">CONFIDENCE</paragraph> -<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> -<paragraph role="heading" id="hd_id3149315" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph> -<paragraph role="code" id="par_id3147501" xml-lang="en-US" l10n="U" oldref="23">CONFIDENCE(Alpha; StDev; Size)</paragraph> -<paragraph role="paragraph" id="par_id3149872" xml-lang="en-US" l10n="U" oldref="24"> +<paragraph role="heading" id="hd_id3153559" xml-lang="en-US" level="2">CONFIDENCE</paragraph> +<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> +<paragraph role="heading" id="hd_id3149315" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="25"> +<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" l10n="U" oldref="26"> +<paragraph role="paragraph" id="par_id3153075" xml-lang="en-US"> <emph>Size</emph> is the size of the total population.</paragraph> -<paragraph role="heading" id="hd_id3150435" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph> -<paragraph role="paragraph" id="par_id3153335" xml-lang="en-US" l10n="U" oldref="28"> +<paragraph role="heading" id="hd_id3150435" xml-lang="en-US" level="3">Example</paragraph> +<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"/> -<paragraph role="heading" id="hd_id2953559" xml-lang="en-US" level="2" l10n="U" oldref="20">CONFIDENCE.T</paragraph> -<paragraph role="paragraph" id="par_id2953814" xml-lang="en-US" l10n="U" oldref="21"> +<paragraph role="heading" id="hd_id2953559" xml-lang="en-US" level="2">CONFIDENCE.T</paragraph> +<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> -<paragraph role="heading" id="hd_id2949315" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph> -<paragraph role="code" id="par_id2947501" xml-lang="en-US" l10n="U" oldref="23">CONFIDENCE.T(Alpha; StDev; Size)</paragraph> -<paragraph role="paragraph" id="par_id2949872" xml-lang="en-US" l10n="U" oldref="24"> +<paragraph role="heading" id="hd_id2949315" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="25"> +<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" l10n="U" oldref="26"> +<paragraph role="paragraph" id="par_id2953075" xml-lang="en-US"> <emph>Size</emph> is the size of the total population.</paragraph> -<paragraph role="heading" id="hd_id2950435" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph> -<paragraph role="paragraph" id="par_id2953335" xml-lang="en-US" l10n="U" oldref="28"> +<paragraph role="heading" id="hd_id2950435" xml-lang="en-US" level="3">Example</paragraph> +<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> </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"/> -<paragraph role="heading" id="hd_id2853559" xml-lang="en-US" level="2" l10n="U" oldref="20">CONFIDENCE.NORM</paragraph> -<paragraph role="paragraph" id="par_id2853814" xml-lang="en-US" l10n="U" oldref="21"> +<paragraph role="heading" id="hd_id2853559" xml-lang="en-US" level="2">CONFIDENCE.NORM</paragraph> +<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> -<paragraph role="heading" id="hd_id2849315" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph> -<paragraph role="code" id="par_id2847501" xml-lang="en-US" l10n="U" oldref="23">CONFIDENCE.NORM(Alpha; StDev; Size)</paragraph> -<paragraph role="paragraph" id="par_id2849872" xml-lang="en-US" l10n="U" oldref="24"> +<paragraph role="heading" id="hd_id2849315" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="25"> +<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" l10n="U" oldref="26"> +<paragraph role="paragraph" id="par_id2853075" xml-lang="en-US"> <emph>Size</emph> is the size of the total population.</paragraph> -<paragraph role="heading" id="hd_id2850435" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph> -<paragraph role="paragraph" id="par_id2853335" xml-lang="en-US" l10n="U" oldref="28"> +<paragraph role="heading" id="hd_id2850435" xml-lang="en-US" level="3">Example</paragraph> +<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> </section> <section id="correl"> @@ -123,32 +123,32 @@ <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"/> -<paragraph role="heading" id="hd_id3148746" xml-lang="en-US" level="2" l10n="U" oldref="30">CORREL</paragraph> -<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> -<paragraph role="heading" id="hd_id3156397" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph> -<paragraph role="code" id="par_id3153023" xml-lang="en-US" l10n="U" oldref="33">CORREL(Data1; Data2)</paragraph> -<paragraph role="paragraph" id="par_id3150036" xml-lang="en-US" l10n="U" oldref="34"> +<paragraph role="heading" id="hd_id3148746" xml-lang="en-US" level="2">CORREL</paragraph> +<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> +<paragraph role="heading" id="hd_id3156397" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="35"> +<paragraph role="paragraph" id="par_id3153021" xml-lang="en-US"> <emph>Data2</emph> is the second data set.</paragraph> -<paragraph role="heading" id="hd_id3149720" xml-lang="en-US" level="3" l10n="U" oldref="36">Example</paragraph> -<paragraph role="paragraph" id="par_id3149941" xml-lang="en-US" l10n="U" oldref="37"> +<paragraph role="heading" id="hd_id3149720" xml-lang="en-US" level="3">Example</paragraph> +<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"/> -<paragraph role="heading" id="hd_id3150652" xml-lang="en-US" level="2" l10n="U" oldref="39">COVAR</paragraph> -<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> -<paragraph role="heading" id="hd_id3149013" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph> -<paragraph role="code" id="par_id3150740" xml-lang="en-US" l10n="U" oldref="42">COVAR(Data1; Data2)</paragraph> -<paragraph role="paragraph" id="par_id3145827" xml-lang="en-US" l10n="U" oldref="43"> +<paragraph role="heading" id="hd_id3150652" xml-lang="en-US" level="2">COVAR</paragraph> +<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> +<paragraph role="heading" id="hd_id3149013" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="44"> +<paragraph role="paragraph" id="par_id3150465" xml-lang="en-US"> <emph>Data2</emph> is the second data set.</paragraph> -<paragraph role="heading" id="hd_id3154677" xml-lang="en-US" level="3" l10n="U" oldref="45">Example</paragraph> -<paragraph role="paragraph" id="par_id3144748" xml-lang="en-US" l10n="U" oldref="46"> +<paragraph role="heading" id="hd_id3154677" xml-lang="en-US" level="3">Example</paragraph> +<paragraph role="paragraph" id="par_id3144748" xml-lang="en-US"> <item type="input">=COVAR(A1:A30;B1:B30)</item> </paragraph> </section> @@ -157,59 +157,59 @@ <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"/> - <paragraph role="heading" id="hd_id2950652" xml-lang="en-US" level="2" l10n="U" oldref="39">COVARIANCE.P</paragraph> - <paragraph role="paragraph" id="par_id2946875" xml-lang="en-US" l10n="U" oldref="40"><ahelp hid="HID_FUNC_COVARIANCE_P">Returns the covariance of the product of paired deviations, for the entire population.</ahelp></paragraph> - <paragraph role="heading" id="hd_id2949013" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph> - <paragraph role="code" id="par_id2950740" xml-lang="en-US" l10n="U" oldref="42">COVARIANCE.P(Data1; Data2)</paragraph> - <paragraph role="paragraph" id="par_id2945827" xml-lang="en-US" l10n="U" oldref="43"><emph>Data1</emph> is the first data set.</paragraph> - <paragraph role="paragraph" id="par_id2950465" xml-lang="en-US" l10n="U" oldref="44"><emph>Data2</emph> is the second data set.</paragraph> - <paragraph role="heading" id="hd_id2954677" xml-lang="en-US" level="3" l10n="U" oldref="45">Example</paragraph> - <paragraph role="paragraph" id="par_id2944748" xml-lang="en-US" l10n="U" oldref="46"><item type="input">=COVARIANCE.P(A1:A30;B1:B30)</item></paragraph> + <paragraph role="heading" id="hd_id2950652" xml-lang="en-US" level="2">COVARIANCE.P</paragraph> + <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> + <paragraph role="heading" id="hd_id2949013" xml-lang="en-US" level="3">Syntax</paragraph> + <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> + <paragraph role="heading" id="hd_id2954677" xml-lang="en-US" level="3">Example</paragraph> + <paragraph role="paragraph" id="par_id2944748" xml-lang="en-US"><item type="input">=COVARIANCE.P(A1:A30;B1:B30)</item></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"/> - <paragraph role="heading" id="hd_id2850652" xml-lang="en-US" level="2" l10n="U" oldref="39">COVARIANCE.S</paragraph> - <paragraph role="paragraph" id="par_id2846875" xml-lang="en-US" l10n="U" oldref="40"><ahelp hid="HID_FUNC_COVARIANCE_S">Returns the covariance of the product of paired deviations, for a sample of the population.</ahelp></paragraph> - <paragraph role="heading" id="hd_id2849013" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph> - <paragraph role="code" id="par_id2850740" xml-lang="en-US" l10n="U" oldref="42">COVARIANCE.S(Data1; Data2)</paragraph> - <paragraph role="paragraph" id="par_id2845827" xml-lang="en-US" l10n="U" oldref="43"><emph>Data1</emph> is the first data set.</paragraph> - <paragraph role="paragraph" id="par_id2850465" xml-lang="en-US" l10n="U" oldref="44"><emph>Data2</emph> is the second data set.</paragraph> - <paragraph role="heading" id="hd_id284677" xml-lang="en-US" level="3" l10n="U" oldref="45">Example</paragraph> - <paragraph role="paragraph" id="par_id2844748" xml-lang="en-US" l10n="U" oldref="46"><item type="input">=COVARIANCE.S(A1:A30;B1:B30)</item></paragraph> + <paragraph role="heading" id="hd_id2850652" xml-lang="en-US" level="2">COVARIANCE.S</paragraph> + <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> + <paragraph role="heading" id="hd_id2849013" xml-lang="en-US" level="3">Syntax</paragraph> + <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> + <paragraph role="heading" id="hd_id284677" xml-lang="en-US" level="3">Example</paragraph> + <paragraph role="paragraph" id="par_id2844748" xml-lang="en-US"><item type="input">=COVARIANCE.S(A1:A30;B1:B30)</item></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"/> -<paragraph role="heading" id="hd_id3147472" xml-lang="en-US" level="2" l10n="U" oldref="48">CRITBINOM</paragraph> -<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 greater than or equal to a criterion value.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3153930" xml-lang="en-US" level="3" l10n="U" oldref="50">Syntax</paragraph> -<paragraph role="code" id="par_id3148586" xml-lang="en-US" l10n="U" oldref="51">CRITBINOM(Trials; SP; Alpha)</paragraph> -<paragraph role="paragraph" id="par_id3145593" xml-lang="en-US" l10n="U" oldref="52"> +<paragraph role="heading" id="hd_id3147472" xml-lang="en-US" level="2">CRITBINOM</paragraph> +<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> +<paragraph role="heading" id="hd_id3153930" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="53"> +<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" l10n="U" oldref="54"> +<paragraph role="paragraph" id="par_id3149726" xml-lang="en-US"> <emph>Alpha</emph> is the threshold probability to be reached or exceeded.</paragraph> -<paragraph role="heading" id="hd_id3148752" xml-lang="en-US" level="3" l10n="U" oldref="55">Example</paragraph> -<paragraph role="paragraph" id="par_id3148740" xml-lang="en-US" l10n="U" oldref="56"> +<paragraph role="heading" id="hd_id3148752" xml-lang="en-US" level="3">Example</paragraph> +<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"/> -<paragraph role="heading" id="hd_id3155956" xml-lang="en-US" level="2" l10n="U" oldref="58">KURT</paragraph> -<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> -<paragraph role="heading" id="hd_id3150334" xml-lang="en-US" level="3" l10n="U" oldref="60">Syntax</paragraph> -<paragraph role="code" id="par_id3154508" xml-lang="en-US" l10n="U" oldref="61">KURT(Number1; Number2; ...Number30)</paragraph> -<paragraph role="paragraph" id="par_id3145167" xml-lang="en-US" l10n="CHG" oldref="62"> +<paragraph role="heading" id="hd_id3155956" xml-lang="en-US" level="2">KURT</paragraph> +<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> +<paragraph role="heading" id="hd_id3150334" xml-lang="en-US" level="3">Syntax</paragraph> +<paragraph role="code" id="par_id3154508" xml-lang="en-US">KURT(Number1; Number2; ...Number30)</paragraph> +<paragraph role="paragraph" id="par_id3145167" xml-lang="en-US"> <emph>Number1,Number2,...Number30</emph> are numeric arguments or ranges representing a random sample of distribution.</paragraph> -<paragraph role="heading" id="hd_id3158000" xml-lang="en-US" level="3" l10n="U" oldref="63">Example</paragraph> -<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US" l10n="U" oldref="64"> +<paragraph role="heading" id="hd_id3158000" xml-lang="en-US" level="3">Example</paragraph> +<paragraph role="paragraph" id="par_id3150016" xml-lang="en-US"> <item type="input">=KURT(A1;A2;A3;A4;A5;A6)</item> </paragraph> </section> @@ -218,18 +218,18 @@ <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"/> -<paragraph role="heading" id="hd_id3150928" xml-lang="en-US" level="2" l10n="U" oldref="66">LOGINV</paragraph> -<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> -<paragraph role="heading" id="hd_id3151016" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph> -<paragraph role="code" id="par_id3153049" xml-lang="en-US" l10n="U" oldref="69">LOGINV(Number; Mean; StDev)</paragraph> -<paragraph role="paragraph" id="par_id3148390" xml-lang="en-US" l10n="U" oldref="70"> +<paragraph role="heading" id="hd_id3150928" xml-lang="en-US" level="2">LOGINV</paragraph> +<paragraph role="paragraph" id="par_id3145297" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGINV">Returns the inverse of the lognormal distribution.</ahelp></paragraph> +<paragraph role="heading" id="hd_id3151016" xml-lang="en-US" level="3">Syntax</paragraph> +<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> 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" l10n="U" oldref="71"> +<paragraph role="paragraph" id="par_id3149538" xml-lang="en-US"> <emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution.</paragraph> -<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" l10n="U" oldref="72"> +<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US"> <emph>StDev</emph> is the standard deviation of the standard logarithmic distribution.</paragraph> -<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph> -<paragraph role="paragraph" id="par_id3155623" xml-lang="en-US" l10n="U" oldref="74"> +<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3">Example</paragraph> +<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"> @@ -237,19 +237,19 @@ <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"/> -<paragraph role="heading" id="hd_id2901928" xml-lang="en-US" level="2" l10n="U" oldref="66">LOGNORM.INV</paragraph> -<paragraph role="paragraph" id="par_id2901297" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_FUNC_LOGINV_MS">Returns the inverse of the lognormal distribution.</ahelp></paragraph> +<paragraph role="heading" id="hd_id2901928" xml-lang="en-US" level="2">LOGNORM.INV</paragraph> +<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> -<paragraph role="heading" id="hd_id2901016" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph> -<paragraph role="code" id="par_id2901049" xml-lang="en-US" l10n="U" oldref="69">LOGNORM.INV(Number; Mean; StDev)</paragraph> -<paragraph role="paragraph" id="par_id2901390" xml-lang="en-US" l10n="U" oldref="70"> +<paragraph role="heading" id="hd_id2901016" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="71"> +<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" l10n="U" oldref="72"> +<paragraph role="paragraph" id="par_id2901355" xml-lang="en-US"> <emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph> -<paragraph role="heading" id="hd_id2901768" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph> -<paragraph role="paragraph" id="par_id2901623" xml-lang="en-US" l10n="U" oldref="74"> +<paragraph role="heading" id="hd_id2901768" xml-lang="en-US" level="3">Example</paragraph> +<paragraph role="paragraph" id="par_id2901623" xml-lang="en-US"> <item type="input">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167.</paragraph> </section> <section id="lognormdist"> @@ -257,20 +257,20 @@ <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"/> -<paragraph role="heading" id="hd_id3158417" xml-lang="en-US" level="2" l10n="U" oldref="76">LOGNORMDIST</paragraph> -<paragraph role="paragraph" id="par_id3154953" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_LOGNORMVERT">Returns the values of a lognormal distribution.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3150474" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph> -<paragraph role="code" id="par_id3150686" xml-lang="en-US" l10n="U" oldref="79">LOGNORMDIST(Number; Mean; StDev; Cumulative)</paragraph> -<paragraph role="paragraph" id="par_id3154871" xml-lang="en-US" l10n="U" oldref="80"> +<paragraph role="heading" id="hd_id3158417" xml-lang="en-US" level="2">LOGNORMDIST</paragraph> +<paragraph role="paragraph" id="par_id3154953" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGNORMVERT">Returns the values of a lognormal distribution.</ahelp></paragraph> +<paragraph role="heading" id="hd_id3150474" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="81"> +<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" l10n="U" oldref="82"> +<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" l10n="NEW"> +<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> -<paragraph role="heading" id="hd_id3153178" xml-lang="en-US" level="3" l10n="U" oldref="83">Example</paragraph> -<paragraph role="paragraph" id="par_id3149778" xml-lang="en-US" l10n="U" oldref="84"> +<paragraph role="heading" id="hd_id3153178" xml-lang="en-US" level="3">Example</paragraph> +<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"> @@ -278,20 +278,20 @@ <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"/> -<paragraph role="heading" id="hd_id2908417" xml-lang="en-US" level="2" l10n="U" oldref="76">LOGNORM.DIST</paragraph> -<paragraph role="paragraph" id="par_id2904953" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_LOGNORMDIST_MS">Returns the values of a lognormal distribution.</ahelp></paragraph> -<paragraph role="heading" id="hd_id2900474" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph> -<paragraph role="code" id="par_id2900686" xml-lang="en-US" l10n="U" oldref="79">LOGNORM.DIST(Number; Mean; StDev; Cumulative)</paragraph> -<paragraph role="paragraph" id="par_id2904871" xml-lang="en-US" l10n="U" oldref="80"> +<paragraph role="heading" id="hd_id2908417" xml-lang="en-US" level="2">LOGNORM.DIST</paragraph> +<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> +<paragraph role="heading" id="hd_id2900474" xml-lang="en-US" level="3">Syntax</paragraph> +<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" l10n="U" oldref="81"> +<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" l10n="U" oldref="82"> +<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" l10n="NEW"> +<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> -<paragraph role="heading" id="hd_id2903178" xml-lang="en-US" level="3" l10n="U" oldref="83">Example</paragraph> -<paragraph role="paragraph" id="par_id2909778" xml-lang="en-US" l10n="U" oldref="84"> +<paragraph role="heading" id="hd_id2903178" xml-lang="en-US" level="3">Example</paragraph> +<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> </section> </sort> |