summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/01/04060185.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060185.xhp')
-rw-r--r--[-rwxr-xr-x]helpcontent2/source/text/scalc/01/04060185.xhp48
1 files changed, 24 insertions, 24 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060185.xhp b/helpcontent2/source/text/scalc/01/04060185.xhp
index 501c0f2ac1..53907a2e87 100755..100644
--- a/helpcontent2/source/text/scalc/01/04060185.xhp
+++ b/helpcontent2/source/text/scalc/01/04060185.xhp
@@ -45,7 +45,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3155071"><bookmark_value>RANK function</bookmark_value>
<bookmark_value>numbers;determining ranks</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_RANG" id="bm_id3146778" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANG" id="bm_id3146778" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3155071" role="heading" level="2" l10n="U" oldref="2">RANK</paragraph>
<paragraph xml-lang="en-US" id="par_id3153976" role="paragraph" l10n="U" oldref="3"><ahelp hid="HID_FUNC_RANG">Returns the rank of a number in a sample.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3159206" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph>
@@ -65,7 +65,7 @@
<section id="skew">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SCHIEFE" id="bm_id3153801" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SCHIEFE" id="bm_id3153801" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153556" role="heading" level="2" l10n="U"
oldref="12">SKEW</paragraph>
<paragraph xml-lang="en-US" id="par_id3153485" role="paragraph" l10n="U" oldref="13"><ahelp hid="HID_FUNC_SCHIEFE">Returns the skewness of a distribution.</ahelp></paragraph>
@@ -84,7 +84,7 @@
<bookmark_value>extrapolations</bookmark_value>
<bookmark_value>FORECAST function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SCHAETZER" id="bm_id3146102" localize="false"/><comment>mw made "regression lines" a two level entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SCHAETZER" id="bm_id3146102" localize="false"/><comment>mw made "regression lines" a two level entry</comment>
<paragraph xml-lang="en-US" id="hd_id3149051" role="heading" level="2" l10n="U"
oldref="20">FORECAST</paragraph>
<paragraph xml-lang="en-US" id="par_id3153290" role="paragraph" l10n="U" oldref="21"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values based on existing x and y values.</ahelp></paragraph>
@@ -106,7 +106,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3149143"><bookmark_value>STDEV function</bookmark_value>
<bookmark_value>standard deviations in statistics;based on a sample</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STABW" id="bm_id3153121" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABW" id="bm_id3153121" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="2" l10n="U"
oldref="30">STDEV</paragraph>
<paragraph xml-lang="en-US" id="par_id3146888" role="paragraph" l10n="U" oldref="31"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation based on a sample.</ahelp></paragraph>
@@ -123,7 +123,7 @@
<section id="stdeva">
<bookmark xml-lang="en-US" branch="index" id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STABWA" id="bm_id3154846" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWA" id="bm_id3154846" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3144745" role="heading" level="2" l10n="U"
oldref="186">STDEVA</paragraph>
<paragraph xml-lang="en-US" id="par_id3151234" role="paragraph" l10n="U" oldref="187"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation of an estimation based on a sample.</ahelp></paragraph>
@@ -141,7 +141,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3149734"><bookmark_value>STDEVP function</bookmark_value>
<bookmark_value>standard deviations in statistics;based on a population</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STABWN" id="bm_id3146139" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWN" id="bm_id3146139" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3149734" role="heading" level="2" l10n="U"
oldref="38">STDEVP</paragraph>
<paragraph xml-lang="en-US" id="par_id3149187" role="paragraph" l10n="U" oldref="39"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire population.</ahelp></paragraph>
@@ -158,7 +158,7 @@
<section id="stdevpa">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154522"><bookmark_value>STDEVPA function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STABWNA" id="bm_id3150902" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWNA" id="bm_id3150902" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154522" role="heading" level="2" l10n="U"
oldref="194">STDEVPA</paragraph>
<paragraph xml-lang="en-US" id="par_id3149549" role="paragraph" l10n="U" oldref="195"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard deviation based on the entire population.</ahelp></paragraph>
@@ -176,7 +176,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3155928"><bookmark_value>STANDARDIZE function</bookmark_value>
<bookmark_value>converting;random variables, into normalized values</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STANDARDISIERUNG" id="bm_id3148764" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDARDISIERUNG" id="bm_id3148764" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3155928" role="heading" level="2" l10n="U"
oldref="46">STANDARDIZE</paragraph>
<paragraph xml-lang="en-US" id="par_id3149883" role="paragraph" l10n="U" oldref="47"><ahelp hid="HID_FUNC_STANDARDISIERUNG">Converts a random variable to a normalized value.</ahelp></paragraph>
@@ -198,7 +198,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3157986"><bookmark_value>NORMSINV function</bookmark_value>
<bookmark_value>normal distribution;inverse of standard</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STANDNORMINV" id="bm_id3148389" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMINV" id="bm_id3148389" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3157986" role="heading" level="2" l10n="U"
oldref="56">NORMSINV</paragraph>
<paragraph xml-lang="en-US" id="par_id3151282" role="paragraph" l10n="U" oldref="57"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph>
@@ -216,7 +216,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3147538"><bookmark_value>NORMSDIST function</bookmark_value>
<bookmark_value>normal distribution;statistics</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STANDNORMVERT" id="bm_id3145269" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMVERT" id="bm_id3145269" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3147538" role="heading" level="2" l10n="U"
oldref="64">NORMSDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3150474" role="paragraph" l10n="CHG" oldref="65"><ahelp hid="HID_FUNC_STANDNORMVERT">Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.</ahelp></paragraph>
@@ -234,7 +234,7 @@
<section id="slope">
<bookmark xml-lang="en-US" branch="index" id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STEIGUNG" id="bm_id3153716" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STEIGUNG" id="bm_id3153716" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3152592" role="heading" level="2" l10n="U"
oldref="72">SLOPE</paragraph>
<paragraph xml-lang="en-US" id="par_id3150386" role="paragraph" l10n="U" oldref="73"><ahelp hid="HID_FUNC_STEIGUNG">Returns the slope of the linear regression line.</ahelp> The slope is adapted to the data points set in the y and x values.</paragraph>
@@ -255,7 +255,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3155836"><bookmark_value>STEYX function</bookmark_value>
<bookmark_value>standard errors;statistical functions</bookmark_value>
</bookmark><comment>mw changed "standard errors"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_STFEHLERYX" id="bm_id3150964" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STFEHLERYX" id="bm_id3150964" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3155836" role="heading" level="2" l10n="U"
oldref="81">STEYX</paragraph>
<paragraph xml-lang="en-US" id="par_id3149446" role="paragraph" l10n="U" oldref="82"><ahelp hid="HID_FUNC_STFEHLERYX">Returns the standard error of the predicted y value for each x in the regression.</ahelp></paragraph>
@@ -276,7 +276,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3150873"><bookmark_value>DEVSQ function</bookmark_value>
<bookmark_value>sums;of squares of deviations</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SUMQUADABW" id="bm_id3156317" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMQUADABW" id="bm_id3156317" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3150873" role="heading" level="2" l10n="U"
oldref="90">DEVSQ</paragraph>
<paragraph xml-lang="en-US" id="par_id3154748" role="paragraph" l10n="U" oldref="91"><ahelp hid="HID_FUNC_SUMQUADABW">Returns the sum of squares of deviations based on a sample mean.</ahelp></paragraph>
@@ -295,7 +295,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3149579"><bookmark_value>TINV function</bookmark_value>
<bookmark_value>inverse of t-distribution</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TINV" id="bm_id3153155" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV" id="bm_id3153155" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3149579" role="heading" level="2" l10n="U"
oldref="98">TINV</paragraph>
<paragraph xml-lang="en-US" id="par_id3143232" role="paragraph" l10n="U" oldref="99"><ahelp hid="HID_FUNC_TINV">Returns the inverse of the t-distribution.</ahelp></paragraph>
@@ -314,7 +314,7 @@
<section id="ttest">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TTEST" id="bm_id3153981" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST" id="bm_id3153981" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154129" role="heading" level="2" l10n="U"
oldref="107">TTEST</paragraph>
<paragraph xml-lang="en-US" id="par_id3159184" role="paragraph" l10n="U" oldref="108"><ahelp hid="HID_FUNC_TTEST">Returns the probability associated with a Student's t-Test.</ahelp></paragraph>
@@ -339,7 +339,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3154930"><bookmark_value>TDIST function</bookmark_value>
<bookmark_value>t-distribution</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TVERT" id="bm_id3153095" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TVERT" id="bm_id3153095" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154930" role="heading" level="2" l10n="U"
oldref="118">TDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3153372" role="paragraph" l10n="U" oldref="119"><ahelp hid="HID_FUNC_TVERT">Returns the t-distribution.</ahelp></paragraph>
@@ -362,7 +362,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3153828"><bookmark_value>VAR function</bookmark_value>
<bookmark_value>variances</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VARIANZ" id="bm_id3154898" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZ" id="bm_id3154898" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153828" role="heading" level="2" l10n="U"
oldref="128">VAR</paragraph>
<paragraph xml-lang="en-US" id="par_id3159165" role="paragraph" l10n="U" oldref="129"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></paragraph>
@@ -380,7 +380,7 @@
<section id="vara">
<bookmark xml-lang="en-US" branch="index" id="bm_id3151045"><bookmark_value>VARA function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VARIANZA" id="bm_id3148473" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZA" id="bm_id3148473" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3151045" role="heading" level="2" l10n="U"
oldref="202">VARA</paragraph>
<paragraph xml-lang="en-US" id="par_id3155122" role="paragraph" l10n="U" oldref="203"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a sample. The value of text is 0.</ahelp></paragraph>
@@ -398,7 +398,7 @@
<section id="varp">
<bookmark xml-lang="en-US" branch="index" id="bm_id3166441"><bookmark_value>VARP function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VARIANZEN" id="bm_id3152359" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZEN" id="bm_id3152359" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3166441" role="heading" level="2" l10n="U"
oldref="136">VARP</paragraph>
<paragraph xml-lang="en-US" id="par_id3159199" role="paragraph" l10n="U" oldref="137"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire population.</ahelp></paragraph>
@@ -416,7 +416,7 @@
<section id="varpa">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VARIANZENA" id="bm_id3159276" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZENA" id="bm_id3159276" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153688" role="heading" level="2" l10n="U"
oldref="210">VARPA</paragraph>
<paragraph xml-lang="en-US" id="par_id3149109" role="paragraph" l10n="U" oldref="211"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based on the entire population. The value of text is 0.</ahelp></paragraph>
@@ -435,7 +435,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3154599"><bookmark_value>PERMUT function</bookmark_value>
<bookmark_value>number of permutations</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VARIATIONEN" id="bm_id3154610" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN" id="bm_id3154610" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154599" role="heading" level="2" l10n="U"
oldref="144">PERMUT</paragraph>
<paragraph xml-lang="en-US" id="par_id3154334" role="paragraph" l10n="U" oldref="145"><ahelp hid="HID_FUNC_VARIATIONEN">Returns the number of permutations for a given number of objects.</ahelp></paragraph>
@@ -454,7 +454,7 @@
<section id="permutationa">
<bookmark xml-lang="en-US" branch="index" id="bm_id3143276"><bookmark_value>PERMUTATIONA function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VARIATIONEN2" id="bm_id3153531" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN2" id="bm_id3153531" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3143276" role="heading" level="2" l10n="U"
oldref="153">PERMUTATIONA</paragraph>
<paragraph xml-lang="en-US" id="par_id3144759" role="paragraph" l10n="U" oldref="154"><ahelp hid="HID_FUNC_VARIATIONEN2">Returns the number of permutations for a given number of objects (repetition allowed).</ahelp></paragraph>
@@ -476,7 +476,7 @@
<section id="prob">
<bookmark xml-lang="en-US" branch="index" id="bm_id3152952"><bookmark_value>PROB function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WAHRSCHBEREICH" id="bm_id3152963" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHRSCHBEREICH" id="bm_id3152963" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3152952" role="heading" level="2" l10n="U"
oldref="164">PROB</paragraph>
<paragraph xml-lang="en-US" id="par_id3154110" role="paragraph" l10n="U" oldref="165"><ahelp hid="HID_FUNC_WAHRSCHBEREICH">Returns the probability that values in a range are between two limits.</ahelp> If there is no <item type="literal">End</item> value, this function calculates the probability based on the principle that the Data values are equal to the value of <item type="literal">Start</item>.</paragraph>
@@ -499,7 +499,7 @@
<section id="weibull">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150941"><bookmark_value>WEIBULL function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WEIBULL" id="bm_id3150405" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEIBULL" id="bm_id3150405" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3150941" role="heading" level="2" l10n="U"
oldref="175">WEIBULL</paragraph>
<paragraph xml-lang="en-US" id="par_id3154916" role="paragraph" l10n="U" oldref="176"><ahelp hid="HID_FUNC_WEIBULL">Returns the values of the Weibull distribution.</ahelp></paragraph>
generated by cgit v1.2.3 (git 2.39.1) at 2024-04-24 16:43:05 +0000