summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/01/04060181.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060181.xhp')
-rw-r--r--[-rwxr-xr-x]helpcontent2/source/text/scalc/01/04060181.xhp28
1 files changed, 14 insertions, 14 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060181.xhp b/helpcontent2/source/text/scalc/01/04060181.xhp
index 0aa55460b3..7c6d8ad150 100755..100644
--- a/helpcontent2/source/text/scalc/01/04060181.xhp
+++ b/helpcontent2/source/text/scalc/01/04060181.xhp
@@ -46,7 +46,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ACHSENABSCHNITT" id="bm_id3153018" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3145632" role="heading" level="2" l10n="U" oldref="2">INTERCEPT</paragraph>
<paragraph xml-lang="en-US" id="par_id3146887" role="paragraph" 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 xml-lang="en-US" id="hd_id3150374" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph>
@@ -65,7 +65,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL" id="bm_id3153040" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3148437" role="heading" level="2" l10n="U"
oldref="13">COUNT</paragraph>
<paragraph xml-lang="en-US" id="par_id3150700" role="paragraph" 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>
@@ -84,7 +84,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL2" id="bm_id3148738" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3149729" role="heading" level="2" l10n="U"
oldref="22">COUNTA</paragraph>
<paragraph xml-lang="en-US" id="par_id3150142" role="paragraph" 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>
@@ -103,7 +103,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_B" id="bm_id3153044" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3150267" role="heading" level="2" l10n="U"
oldref="31">B</paragraph>
<paragraph xml-lang="en-US" id="par_id3156061" role="paragraph" l10n="U" oldref="32"><ahelp hid="HID_FUNC_B">Returns the probability of a sample with binomial distribution.</ahelp></paragraph>
@@ -129,7 +129,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BESTIMMTHEITSMASS" id="bm_id3153228" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3158416" role="heading" level="2" l10n="U"
oldref="43">RSQ</paragraph>
<paragraph xml-lang="en-US" id="par_id3154949" role="paragraph" 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>
@@ -149,7 +149,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BETAINV" id="bm_id3146154" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3145620" role="heading" level="2" l10n="U"
oldref="52">BETAINV</paragraph>
<paragraph xml-lang="en-US" id="par_id3149825" role="paragraph" l10n="U" oldref="53"><ahelp hid="HID_FUNC_BETAINV">Returns the inverse of the cumulative beta probability density function.</ahelp></paragraph>
@@ -178,7 +178,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BETAVERT" id="bm_id3153213" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3156096" role="heading" level="2" l10n="U"
oldref="64">BETADIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3150880" role="paragraph" l10n="U" oldref="65"><ahelp hid="HID_FUNC_BETAVERT">Returns the beta function.</ahelp></paragraph>
@@ -208,7 +208,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BINOMVERT" id="bm_id3150146" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3143228" role="heading" level="2" l10n="U"
oldref="76">BINOMDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3146897" role="paragraph" l10n="U" oldref="77"><ahelp hid="HID_FUNC_BINOMVERT">Returns the individual term binomial distribution probability.</ahelp></paragraph>
@@ -231,7 +231,7 @@
<item type="input">=BINOMDIST(A1;12;0.5;1)</item> shows the cumulative probabilities for the same series. For example, if A1 = <item type="input">4</item>, the cumulative probability of the series is 0, 1, 2, 3 or 4 times <emph>Heads</emph> (non-exclusive OR).</paragraph>
</section>
<section id="chisqinv">
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHISQINV" id="bm_id0119200902430717" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQINV" id="bm_id0119200902430717" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id0119200902432928"><bookmark_value>CHISQINV function</bookmark_value>
</bookmark>
<paragraph xml-lang="en-US" id="hd_id0119200902421451" role="heading" level="2" l10n="NEW">CHISQINV</paragraph>
@@ -245,7 +245,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHIINV" id="bm_id3148823" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3148835" role="heading" level="2" l10n="U"
oldref="88">CHIINV</paragraph>
<paragraph xml-lang="en-US" id="par_id3149906" role="paragraph" l10n="U" oldref="89"><ahelp hid="HID_FUNC_CHIINV">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp></paragraph>
@@ -270,7 +270,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHITEST" id="bm_id3155355" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154260" role="heading" level="2" l10n="U"
oldref="97">CHITEST</paragraph>
<paragraph xml-lang="en-US" id="par_id3151052" role="paragraph" 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>
@@ -393,7 +393,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHIVERT" id="bm_id3147521" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3148690" role="heading" level="2" l10n="U"
oldref="106">CHIDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3156338" role="paragraph" 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>
@@ -412,7 +412,7 @@
<paragraph xml-lang="en-US" id="par_id3156141" role="paragraph" l10n="U" oldref="158">If the Chi square value of the random sample is 13.27 and if the experiment has 5 degrees of freedom, then the hypothesis is assured with a probability of error of 2%.</paragraph>
</section>
<section id="chisqdist">
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHISQDIST" id="bm_id0119200902213671" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQDIST" id="bm_id0119200902213671" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id0119200902231887"><bookmark_value>CHISQDIST function</bookmark_value>
<bookmark_value>chi-square distribution</bookmark_value>
</bookmark>
@@ -431,7 +431,7 @@
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXPONVERT" id="bm_id3152962" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3150603" role="heading" level="2" l10n="U"
oldref="115">EXPONDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3149563" role="paragraph" l10n="U" oldref="116"><ahelp hid="HID_FUNC_EXPONVERT">Returns the exponential distribution.</ahelp></paragraph>