diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060181.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/04060181.xhp | 108 |
1 files changed, 63 insertions, 45 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060181.xhp b/helpcontent2/source/text/scalc/01/04060181.xhp index 314ff5f6cb..ccf07edf3a 100755 --- a/helpcontent2/source/text/scalc/01/04060181.xhp +++ b/helpcontent2/source/text/scalc/01/04060181.xhp @@ -1,9 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -12,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: 04060181.xhp,v $ - * $Revision: 1.9 $ + * $Revision: 1.9.4.1 $ * * This file is part of OpenOffice.org. * @@ -33,11 +32,10 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalc0104060181xml" indexer="include" status="PUBLISH"> +<topic id="textscalc0104060181xml" indexer="include"> <title id="tit" xml-lang="en-US">Statistical Functions Part One</title> <filename>/text/scalc/01/04060181.xhp</filename> </topic> @@ -45,12 +43,14 @@ <body> <paragraph role="heading" id="hd_id3146320" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="ae"><link href="text/scalc/01/04060181.xhp">Statistical Functions Part One</link> </variable></paragraph> -<sort order="asc"><section id="intercept"> +<sort order="asc"> +<section id="intercept"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145632"><bookmark_value>INTERCEPT function</bookmark_value> <bookmark_value>points of intersection</bookmark_value> <bookmark_value>intersections</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ACHSENABSCHNITT" id="bm_id3153018" localize="false"/><paragraph role="heading" id="hd_id3145632" xml-lang="en-US" level="2" l10n="U" oldref="2">INTERCEPT</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ACHSENABSCHNITT" id="bm_id3153018" localize="false"/> +<paragraph role="heading" id="hd_id3145632" xml-lang="en-US" level="2" l10n="U" oldref="2">INTERCEPT</paragraph> <paragraph role="paragraph" id="par_id3146887" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_FUNC_ACHSENABSCHNITT">Calculates the point at which a line will intersect the y-values by using known x-values and y-values.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150374" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph> <paragraph role="code" id="par_id3149718" xml-lang="en-US" l10n="U" oldref="5">INTERCEPT(DataY; DataX)</paragraph> @@ -68,7 +68,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148437"><bookmark_value>COUNT function</bookmark_value> <bookmark_value>numbers;counting</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ANZAHL" id="bm_id3153040" localize="false"/><paragraph role="heading" id="hd_id3148437" xml-lang="en-US" level="2" l10n="U" oldref="13">COUNT</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ANZAHL" id="bm_id3153040" localize="false"/> +<paragraph role="heading" id="hd_id3148437" xml-lang="en-US" level="2" l10n="U" oldref="13">COUNT</paragraph> <paragraph role="paragraph" id="par_id3150700" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid="HID_FUNC_ANZAHL">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored.</paragraph> <paragraph role="heading" id="hd_id3153930" xml-lang="en-US" level="3" l10n="U" oldref="15">Syntax</paragraph> <paragraph role="code" id="par_id3148585" xml-lang="en-US" l10n="U" oldref="16">COUNT(Value1; Value2; ... Value30)</paragraph> @@ -83,7 +84,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3149729"><bookmark_value>COUNTA function</bookmark_value> <bookmark_value>number of entries</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ANZAHL2" id="bm_id3148738" localize="false"/><paragraph role="heading" id="hd_id3149729" xml-lang="en-US" level="2" l10n="U" oldref="22">COUNTA</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ANZAHL2" id="bm_id3148738" localize="false"/> +<paragraph role="heading" id="hd_id3149729" xml-lang="en-US" level="2" l10n="U" oldref="22">COUNTA</paragraph> <paragraph role="paragraph" id="par_id3150142" xml-lang="en-US" l10n="CHG" oldref="23"><ahelp hid="HID_FUNC_ANZAHL2">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.<comment>UFI: fix to #i35888#</comment></paragraph> <paragraph role="heading" id="hd_id3148573" xml-lang="en-US" level="3" l10n="U" oldref="24">Syntax</paragraph> <paragraph role="code" id="par_id3153111" xml-lang="en-US" l10n="U" oldref="25">COUNTA(Value1; Value2; ... Value30)</paragraph> @@ -98,7 +100,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150267"><bookmark_value>B function</bookmark_value> <bookmark_value>probabilities of samples with binomial distribution</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_B" id="bm_id3153044" localize="false"/><paragraph role="heading" id="hd_id3150267" xml-lang="en-US" level="2" l10n="U" oldref="31">B</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_B" id="bm_id3153044" localize="false"/> +<paragraph role="heading" id="hd_id3150267" xml-lang="en-US" level="2" l10n="U" oldref="31">B</paragraph> <paragraph role="paragraph" id="par_id3156061" xml-lang="en-US" l10n="U" oldref="32"><ahelp hid="HID_FUNC_B">Returns the probability of a sample with binomial distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150659" xml-lang="en-US" level="3" l10n="U" oldref="33">Syntax</paragraph> <paragraph role="code" id="par_id3148392" xml-lang="en-US" l10n="U" oldref="34">B(Trials; SP; T1; T2)</paragraph> @@ -120,7 +123,8 @@ <bookmark_value>determination coefficients</bookmark_value> <bookmark_value>regression analysis</bookmark_value> </bookmark><comment>mw added regression analysis</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BESTIMMTHEITSMASS" id="bm_id3153228" localize="false"/><paragraph role="heading" id="hd_id3158416" xml-lang="en-US" level="2" l10n="U" oldref="43">RSQ</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BESTIMMTHEITSMASS" id="bm_id3153228" localize="false"/> +<paragraph role="heading" id="hd_id3158416" xml-lang="en-US" level="2" l10n="U" oldref="43">RSQ</paragraph> <paragraph role="paragraph" id="par_id3154949" xml-lang="en-US" l10n="U" oldref="44"><ahelp hid="HID_FUNC_BESTIMMTHEITSMASS">Returns the square of the Pearson correlation coefficient based on the given values.</ahelp> RSQ (also called determination coefficient) is a measure for the accuracy of an adjustment and can be used to produce a regression analysis.</paragraph> <paragraph role="heading" id="hd_id3152820" xml-lang="en-US" level="3" l10n="U" oldref="45">Syntax</paragraph> <paragraph role="code" id="par_id3155822" xml-lang="en-US" l10n="U" oldref="46">RSQ(DataY; DataX)</paragraph> @@ -136,7 +140,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3145620"><bookmark_value>BETAINV function</bookmark_value> <bookmark_value>cumulative probability density function;inverse of</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BETAINV" id="bm_id3146154" localize="false"/><paragraph role="heading" id="hd_id3145620" xml-lang="en-US" level="2" l10n="U" oldref="52">BETAINV</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BETAINV" id="bm_id3146154" localize="false"/> +<paragraph role="heading" id="hd_id3145620" xml-lang="en-US" level="2" l10n="U" oldref="52">BETAINV</paragraph> <paragraph role="paragraph" id="par_id3149825" xml-lang="en-US" l10n="U" oldref="53"><ahelp hid="HID_FUNC_BETAINV">Returns the inverse of the cumulative beta probability density function.</ahelp></paragraph> <paragraph role="heading" id="hd_id3152479" xml-lang="en-US" level="3" l10n="U" oldref="54">Syntax</paragraph> <paragraph role="code" id="par_id3156300" xml-lang="en-US" l10n="U" oldref="55">BETAINV(Number; Alpha; Beta; Start; End)</paragraph> @@ -161,7 +166,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3156096"><bookmark_value>BETADIST function</bookmark_value> <bookmark_value>cumulative probability density function;calculating</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BETAVERT" id="bm_id3153213" localize="false"/><paragraph role="heading" id="hd_id3156096" xml-lang="en-US" level="2" l10n="U" oldref="64">BETADIST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BETAVERT" id="bm_id3153213" localize="false"/> +<paragraph role="heading" id="hd_id3156096" xml-lang="en-US" level="2" l10n="U" oldref="64">BETADIST</paragraph> <paragraph role="paragraph" id="par_id3150880" xml-lang="en-US" l10n="U" oldref="65"><ahelp hid="HID_FUNC_BETAVERT">Returns the cumulative beta probability density function.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150762" xml-lang="en-US" level="3" l10n="U" oldref="66">Syntax</paragraph> <paragraph role="code" id="par_id3147571" xml-lang="en-US" l10n="U" oldref="67">BETADIST(Number; Alpha; Beta; Start; End)</paragraph> @@ -185,7 +191,8 @@ <section id="binomdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3143228"><bookmark_value>BINOMDIST function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BINOMVERT" id="bm_id3150146" localize="false"/><paragraph role="heading" id="hd_id3143228" xml-lang="en-US" level="2" l10n="U" oldref="76">BINOMDIST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BINOMVERT" id="bm_id3150146" localize="false"/> +<paragraph role="heading" id="hd_id3143228" xml-lang="en-US" level="2" l10n="U" oldref="76">BINOMDIST</paragraph> <paragraph role="paragraph" id="par_id3146897" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_BINOMVERT">Returns the individual term binomial distribution probability.</ahelp></paragraph> <paragraph role="heading" id="hd_id3149289" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph> <paragraph role="code" id="par_id3156009" xml-lang="en-US" l10n="U" oldref="79">BINOMDIST(X; Trials; SP; C)</paragraph> @@ -206,7 +213,8 @@ <section id="chiinv"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148835"><bookmark_value>CHIINV function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHIINV" id="bm_id3148823" localize="false"/><paragraph role="heading" id="hd_id3148835" xml-lang="en-US" level="2" l10n="U" oldref="88">CHIINV</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHIINV" id="bm_id3148823" localize="false"/> +<paragraph role="heading" id="hd_id3148835" xml-lang="en-US" level="2" l10n="U" oldref="88">CHIINV</paragraph> <paragraph role="paragraph" id="par_id3149906" xml-lang="en-US" l10n="U" oldref="89"><ahelp hid="HID_FUNC_CHIINV">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3159157" xml-lang="en-US" level="3" l10n="U" oldref="90">Syntax</paragraph> <paragraph role="code" id="par_id3150504" xml-lang="en-US" l10n="U" oldref="91">CHIINV(Number; DegreesFreedom)</paragraph> @@ -227,7 +235,8 @@ <section id="chitest"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154260"><bookmark_value>CHITEST function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHITEST" id="bm_id3155355" localize="false"/><paragraph role="heading" id="hd_id3154260" xml-lang="en-US" level="2" l10n="U" oldref="97">CHITEST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHITEST" id="bm_id3155355" localize="false"/> +<paragraph role="heading" id="hd_id3154260" xml-lang="en-US" level="2" l10n="U" oldref="97">CHITEST</paragraph> <paragraph role="paragraph" id="par_id3151052" xml-lang="en-US" l10n="U" oldref="98"><ahelp hid="HID_FUNC_CHITEST">Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</ahelp> CHITEST returns the chi-squared distribution of the data.</paragraph> <paragraph role="paragraph" id="par_id3148925" xml-lang="en-US" l10n="U" oldref="135">The probability determined by CHITEST can also be determined with CHIDIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row.</paragraph> <paragraph role="heading" id="hd_id3154280" xml-lang="en-US" level="3" l10n="U" oldref="99">Syntax</paragraph> @@ -239,112 +248,115 @@ <paragraph role="heading" id="hd_id3146946" xml-lang="en-US" level="3" l10n="U" oldref="103">Example</paragraph> <table id="tbl_id3153233"> <tablerow> -<tablecell colspan="" rowspan=""/> -<tablecell colspan="" rowspan=""> +<tablecell> +</tablecell> +<tablecell> <paragraph role="paragraph" id="par_id3154096" xml-lang="en-US" l10n="U" oldref="136">Data_B (observed)</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3152948" xml-lang="en-US" l10n="U" oldref="137">Data_E (expected)</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3152876" xml-lang="en-US" l10n="U" oldref="138">1</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3159279" xml-lang="en-US" l10n="U" oldref="139"> <item type="input">195</item> </paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3149105" xml-lang="en-US" l10n="U" oldref="140"> <item type="input">170</item> </paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3149922" xml-lang="en-US" l10n="U" oldref="141">2</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3148621" xml-lang="en-US" l10n="U" oldref="142"> <item type="input">151</item> </paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3148987" xml-lang="en-US" l10n="U" oldref="143"> <item type="input">170</item> </paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3149417" xml-lang="en-US" l10n="U" oldref="144">3</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3148661" xml-lang="en-US" l10n="U" oldref="145"> <item type="input">148</item> </paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3151128" xml-lang="en-US" l10n="U" oldref="146"> <item type="input">170</item> </paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3148467" xml-lang="en-US" l10n="U" oldref="147">4</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3149237" xml-lang="en-US" l10n="U" oldref="148"> <item type="input">189</item> </paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3145304" xml-lang="en-US" l10n="U" oldref="149"> <item type="input">170</item> </paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3149927" xml-lang="en-US" l10n="U" oldref="150">5</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3150630" xml-lang="en-US" l10n="U" oldref="151"> <item type="input">183</item> </paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3150423" xml-lang="en-US" l10n="U" oldref="152"> <item type="input">170</item> </paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3143275" xml-lang="en-US" l10n="U" oldref="153">6</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3144750" xml-lang="en-US" l10n="U" oldref="154"> <item type="input">154</item> </paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="paragraph" id="par_id3153947" xml-lang="en-US" l10n="U" oldref="155"> <item type="input">170</item> </paragraph> </tablecell> </tablerow> </table> + <paragraph role="paragraph" id="par_id3149481" xml-lang="en-US" l10n="U" oldref="104"> <item type="input">=CHITEST(A1:A6;B1:B6)</item> equals 0.02. This is the probability which suffices the observed data of the theoretical Chi-square distribution.</paragraph> </section> <section id="chidist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148690"><bookmark_value>CHIDIST function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHIVERT" id="bm_id3147521" localize="false"/><paragraph role="heading" id="hd_id3148690" xml-lang="en-US" level="2" l10n="U" oldref="106">CHIDIST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHIVERT" id="bm_id3147521" localize="false"/> +<paragraph role="heading" id="hd_id3148690" xml-lang="en-US" level="2" l10n="U" oldref="106">CHIDIST</paragraph> <paragraph role="paragraph" id="par_id3156338" xml-lang="en-US" l10n="U" oldref="156"><ahelp hid="HID_FUNC_CHIVERT">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHIDIST compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested.</paragraph> <paragraph role="paragraph" id="par_id3151316" xml-lang="en-US" l10n="U" oldref="157">The probability determined by CHIDIST can also be determined by CHITEST.</paragraph> <paragraph role="heading" id="hd_id3155123" xml-lang="en-US" level="3" l10n="U" oldref="108">Syntax</paragraph> @@ -362,18 +374,24 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150603"><bookmark_value>EXPONDIST function</bookmark_value> <bookmark_value>exponential distributions</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_EXPONVERT" id="bm_id3152962" localize="false"/><paragraph role="heading" id="hd_id3150603" xml-lang="en-US" level="2" l10n="U" oldref="115">EXPONDIST</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_FUNC_EXPONVERT" id="bm_id3152962" localize="false"/> +<paragraph role="heading" id="hd_id3150603" xml-lang="en-US" level="2" l10n="U" oldref="115">EXPONDIST</paragraph> <paragraph role="paragraph" id="par_id3149563" xml-lang="en-US" l10n="U" oldref="116"><ahelp hid="HID_FUNC_EXPONVERT">Returns the exponential distribution.</ahelp></paragraph> <paragraph role="heading" id="hd_id3153789" xml-lang="en-US" level="3" l10n="U" oldref="117">Syntax</paragraph> <paragraph role="code" id="par_id3150987" xml-lang="en-US" l10n="U" oldref="118">EXPONDIST(Number; Lambda; C)</paragraph> <paragraph role="paragraph" id="par_id3154663" xml-lang="en-US" l10n="U" oldref="119"> <emph>Number</emph> is the value of the function.</paragraph> <paragraph role="paragraph" id="par_id3154569" xml-lang="en-US" l10n="U" oldref="120"> -<emph>Lambda</emph> is the parameter value.</paragraph><comment>UFI removed a double bookmark</comment><paragraph role="paragraph" id="par_id3147332" xml-lang="en-US" l10n="U" oldref="121"> +<emph>Lambda</emph> is the parameter value.</paragraph><comment>UFI removed a double bookmark</comment> +<paragraph role="paragraph" id="par_id3147332" xml-lang="en-US" l10n="U" oldref="121"> <emph>C</emph> is a logical value that determines the form of the function. <emph>C = 0</emph> calculates the density function, and <emph>C = 1</emph> calculates the distribution.</paragraph> <paragraph role="heading" id="hd_id3146133" xml-lang="en-US" level="3" l10n="U" oldref="122">Example</paragraph> <paragraph role="paragraph" id="par_id3150357" xml-lang="en-US" l10n="U" oldref="123"> <item type="input">=EXPONDIST(3;0.5;1)</item> returns 0.78.</paragraph> </section> -</sort></body> +</sort> +<section id="relatedtopics"> +<embed href="text/scalc/01/04060100.xhp#drking"/> +</section> +</body> </helpdocument> |