summaryrefslogtreecommitdiffstats
path: root/source/text/scalc/01/04060185.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2018-09-29 15:26:04 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2018-10-02 08:54:16 +0200
commitb358fb9b95915743d8666b238acb8e117c8751ce (patch)
tree7913b29b55f56ffa83d7a7e57f96340db7536410 /source/text/scalc/01/04060185.xhp
parenttdf#103527 Remove Colors from Options help (diff)
downloadhelp-b358fb9b95915743d8666b238acb8e117c8751ce.tar.gz
help-b358fb9b95915743d8666b238acb8e117c8751ce.zip
Reduce L10N workload for repetitive strings
Change 'Syntax' and 'Examples' heading into an embedded string translated only once. Change-Id: Iac2eef8fedbaa4461aa2f941af7f065a3b16fb2d Reviewed-on: https://gerrit.libreoffice.org/61143 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060185.xhp')
-rw-r--r--source/text/scalc/01/04060185.xhp160
1 files changed, 80 insertions, 80 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index b838f45cc2..901aa10bd7 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -37,7 +37,7 @@
<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">RANK</paragraph>
<paragraph xml-lang="en-US" id="par_id3153976" role="paragraph"><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">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153250" role="code">RANK(Value; Data; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id3154543" role="paragraph">
<emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
@@ -47,7 +47,7 @@
<emph>Type</emph> (optional) is the sequence order.</paragraph>
<paragraph xml-lang="en-US" id="par_id9305398" role="paragraph">Type = 0 means descending from the last item of the array to the first (this is the default),</paragraph>
<paragraph xml-lang="en-US" id="par_id9996948" role="paragraph">Type = 1 means ascending from the first item of the range to the last.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3143223" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3155919" role="paragraph">
<item type="input">=RANK(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph>
</section>
@@ -60,14 +60,14 @@
<paragraph xml-lang="en-US" id="hd_id2955071" role="heading" level="2">RANK.AVG</paragraph>
<paragraph xml-lang="en-US" id="par_id2953976" role="paragraph"><ahelp hid="HID_FUNC_RANK_AVG">Returns the statistical rank of a given value, within a supplied array of values.</ahelp> If there are duplicate values in the list, the average rank is returned.</paragraph>
<paragraph xml-lang="en-US" id="par_id2653976" role="note">The difference between <item type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type="input">RANK.EQ</item> function returns the lower rank, whereas the <item type="input">RANK.AVG</item> function returns the average rank.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id2959206" role="heading" level="3">Syntax</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953250" role="code">RANK.AVG(Value; Data; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954543" role="paragraph"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
<paragraph xml-lang="en-US" id="par_id2949130" role="paragraph"><emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id2950215" role="paragraph"><emph>Type</emph> (optional) is the sequence order.</paragraph>
<paragraph xml-lang="en-US" id="par_id0305398" role="paragraph">Type = 0 means descending from the last item of the array to the first (this is the default),</paragraph>
<paragraph xml-lang="en-US" id="par_id0996948" role="paragraph">Type = 1 means ascending from the first item of the range to the last.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id2943223" role="heading" level="3">Example</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2955919" role="paragraph"><item type="input">=RANK.AVG(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph>
</section>
<section id="rankeq">
@@ -79,14 +79,14 @@
<paragraph xml-lang="en-US" id="hd_id2855071" role="heading" level="2">RANK.EQ</paragraph>
<paragraph xml-lang="en-US" id="par_id2853976" role="paragraph"><ahelp hid="HID_FUNC_RANK_EQ">Returns the statistical rank of a given value, within a supplied array of values.</ahelp> If there are duplicate values in the list, these are given the same rank.</paragraph>
<paragraph xml-lang="en-US" id="par_id2753976" role="note">The difference between <item type="input">RANK.AVG</item> and <item type="input">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type="input">RANK.EQ</item> function returns the lower rank, whereas the <item type="input">RANK.AVG</item> function returns the average rank.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id2859206" role="heading" level="3">Syntax</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853250" role="code">RANK.EQ(Value; Data; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2854543" role="paragraph"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
<paragraph xml-lang="en-US" id="par_id2849130" role="paragraph"><emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id2850215" role="paragraph"><emph>Type</emph> (optional) is the sequence order.</paragraph>
<paragraph xml-lang="en-US" id="par_id89305398" role="paragraph">Type = 0 means descending from the last item of the array to the first (this is the default),</paragraph>
<paragraph xml-lang="en-US" id="par_id89996948" role="paragraph">Type = 1 means ascending from the first item of the range to the last.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id2843223" role="heading" level="3">Example</paragraph>
+<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2855919" role="paragraph"><item type="input">=RANK.EQ(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph>
</section>
<section id="skew">
@@ -95,11 +95,11 @@
<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">SKEW</paragraph>
<paragraph xml-lang="en-US" id="par_id3153485" role="paragraph"><ahelp hid="HID_FUNC_SCHIEFE">Returns the skewness of a distribution.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3154733" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3151191" role="code">SKEW(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155757" role="paragraph">
<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153297" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3145118" role="paragraph">
<item type="input">=SKEW(A1:A50)</item> calculates the value of skew for the data referenced.</paragraph>
</section>
@@ -115,7 +115,7 @@
<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">FORECAST</paragraph>
<paragraph xml-lang="en-US" id="par_id3153290" role="paragraph"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values based on existing x and y values.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3151343" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147404" role="code">FORECAST(Value; DataY; DataX)</paragraph>
<paragraph xml-lang="en-US" id="par_id3148743" role="paragraph">
<emph>Value</emph> is the x value, for which the y value on the linear regression is to be returned.</paragraph>
@@ -123,7 +123,7 @@
<emph>DataY</emph> is the array or range of known y's.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150536" role="paragraph">
<emph>DataX</emph> is the array or range of known x's.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147416" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3157874" role="paragraph">
<item type="input">=FORECAST(50;A1:A50;B1;B50)</item> returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.</paragraph>
</section>
@@ -135,7 +135,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_LIN" id="bm_id3146102" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3149052" role="heading" level="2">FORECAST.LINEAR</paragraph>
<paragraph xml-lang="en-US" id="par_id3153291" role="paragraph"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values based on existing x and y values.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3151344" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147405" role="code">FORECAST.LINEAR(Value; DataY; DataX)</paragraph>
<paragraph xml-lang="en-US" id="par_id3148744" role="paragraph">
<emph>Value</emph> is the x value, for which the y value on the linear regression is to be returned.</paragraph>
@@ -143,7 +143,7 @@
<emph>DataY</emph> is the array or range of known y's.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150537" role="paragraph">
<emph>DataX</emph> is the array or range of known x's.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147417" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3157875" role="paragraph">
<item type="input">=FORECAST.LINEAR(50;A1:A50;B1;B50)</item> returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.</paragraph>
</section>
@@ -154,11 +154,11 @@
<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">STDEV</paragraph>
<paragraph xml-lang="en-US" id="par_id3146888" role="paragraph"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation based on a sample.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3146815" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149946" role="code">STDEV(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3157904" role="paragraph">
<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150650" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3149434" role="paragraph">
<item type="input">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph>
</section>
@@ -168,11 +168,11 @@
<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">STDEVA</paragraph>
<paragraph xml-lang="en-US" id="par_id3151234" role="paragraph"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation of an estimation based on a sample.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3148884" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147422" role="code">STDEVA(Value1; Value2; ...; Value30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3154547" role="paragraph">
<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155829" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3148581" role="paragraph">
<item type="input">=STDEVA(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph>
</section>
@@ -183,11 +183,11 @@
<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">STDEVP</paragraph>
<paragraph xml-lang="en-US" id="par_id3149187" role="paragraph"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire population.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3154387" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154392" role="code">STDEVP(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155261" role="paragraph">
<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3145591" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153933" role="paragraph">
<item type="input">=STDEVP(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph>
</section>
@@ -199,10 +199,10 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_P_MS" id="bm_id2946139" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2949734" role="heading" level="2">STDEV.P</paragraph>
<paragraph xml-lang="en-US" id="par_id2949187" role="paragraph"><ahelp hid="HID_FUNC_ST_DEV_P_MS">Calculates the standard deviation based on the entire population.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2954387" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2954392" role="code">STDEV.P(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2955261" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2945591" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953933" role="paragraph"><item type="input">=STDEV.P(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph>
</section>
<section id="stdevdots">
@@ -213,10 +213,10 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_S" id="bm_id2846139" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2849734" role="heading" level="2">STDEV.S</paragraph>
<paragraph xml-lang="en-US" id="par_id2849187" role="paragraph"><ahelp hid="HID_FUNC_ST_DEV_S">Calculates the standard deviation based on sample of the population.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2854387" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2854392" role="code">STDEV.S(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2855261" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample of the population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2845591" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2853933" role="paragraph"><item type="input">=STDEV.S(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph>
</section>
<section id="stdevpa">
@@ -225,11 +225,11 @@
<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">STDEVPA</paragraph>
<paragraph xml-lang="en-US" id="par_id3149549" role="paragraph"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard deviation based on the entire population.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155950" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3146851" role="code">STDEVPA(Value1; Value2; ...; Value30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3153109" role="paragraph">
<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population. Text has the value 0.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3154506" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3145163" role="paragraph">
<item type="input">=STDEVPA(A1:A50)</item> returns the standard deviation of the data referenced.</paragraph>
</section>
@@ -240,7 +240,7 @@
<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">STANDARDIZE</paragraph>
<paragraph xml-lang="en-US" id="par_id3149883" role="paragraph"><ahelp hid="HID_FUNC_STANDARDISIERUNG">Converts a random variable to a normalized value.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3154330" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150132" role="code">STANDARDIZE(Number; Mean; StDev)</paragraph>
<paragraph xml-lang="en-US" id="par_id3159139" role="paragraph">
<emph>Number</emph> is the value to be standardized.</paragraph>
@@ -248,7 +248,7 @@
<emph>Mean</emph> is the arithmetic mean of the distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148874" role="paragraph">
<emph>StDev</emph> is the standard deviation of the distribution.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3145351" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3156067" role="paragraph">
<item type="input">=STANDARDIZE(11;10;1)</item> returns 1. The value 11 in a normal distribution with a mean of 10 and a standard deviation of 1 is as much above the mean of 10, as the value 1 is above the mean of the standard normal distribution.</paragraph>
</section>
@@ -259,11 +259,11 @@
<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">NORMSINV</paragraph>
<paragraph xml-lang="en-US" id="par_id3151282" role="paragraph"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153261" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154195" role="code">NORMSINV(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id3148772" role="paragraph">
<emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150934" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3149030" role="paragraph">
<item type="input">=NORMSINV(0.908789)</item> returns 1.3333.</paragraph>
</section>
@@ -274,11 +274,11 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMINV_MS" id="bm_id2948389" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2957986" role="heading" level="2">NORM.S.INV</paragraph>
<paragraph xml-lang="en-US" id="par_id2951282" role="paragraph"><ahelp hid="HID_FUNC_STD_NORMINV_MS">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2953261" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2954195" role="code">NORM.S.INV(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id2948772" role="paragraph">
<emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2950934" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2949030" role="paragraph">
<item type="input">=NORM.S.INV(0.908789)</item> returns 1.333334673.</paragraph>
</section>
@@ -290,11 +290,11 @@
<paragraph xml-lang="en-US" id="hd_id3147538" role="heading" level="2">NORMSDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3150474" role="paragraph"><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>
<paragraph xml-lang="en-US" id="par_id8652302" role="paragraph">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155083" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3158411" role="code">NORMSDIST(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id3154950" role="paragraph">
<emph>Number</emph> is the value to which the standard normal cumulative distribution is calculated.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3155984" role="paragraph">
<item type="input">=NORMSDIST(1)</item> returns 0.84. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area.</paragraph>
</section>
@@ -305,13 +305,13 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMDIST_MS" id="bm_id2945269" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2947538" role="heading" level="2">NORM.S.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2950474" role="paragraph"><ahelp hid="HID_FUNC_STD_NORMDIST_MS">Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2955083" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2958411" role="code">NORM.S.DIST(Number; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954950" role="paragraph">
<emph>Number</emph> is the value to which the standard normal cumulative distribution is calculated.</paragraph>
<paragraph xml-lang="en-US" id="par_id2954951" role="paragraph">
<emph>Cumulative</emph> 0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2993228" role="heading" level="3">Examples</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2955984" role="paragraph">
<item type="input">=NORM.S.DIST(1;0)</item> returns 0.2419707245.</paragraph>
<paragraph xml-lang="en-US" id="par_id2955985" role="paragraph">
@@ -323,13 +323,13 @@
<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">SLOPE</paragraph>
<paragraph xml-lang="en-US" id="par_id3150386" role="paragraph"><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>
- <paragraph xml-lang="en-US" id="hd_id3154315" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149819" role="code">SLOPE(DataY; DataX)</paragraph>
<paragraph xml-lang="en-US" id="par_id3083446" role="paragraph">
<emph>DataY</emph> is the array or matrix of Y data.</paragraph>
<paragraph xml-lang="en-US" id="par_id3152375" role="paragraph">
<emph>DataX</emph> is the array or matrix of X data.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3146061" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3152480" role="paragraph">
<item type="input">=SLOPE(A1:A50;B1:B50)</item>
</paragraph>
@@ -341,13 +341,13 @@
<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">STEYX</paragraph>
<paragraph xml-lang="en-US" id="par_id3149446" role="paragraph"><ahelp hid="HID_FUNC_STFEHLERYX">Returns the standard error of the predicted y value for each x in the regression.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147562" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3151267" role="code">STEYX(DataY; DataX)</paragraph>
<paragraph xml-lang="en-US" id="par_id3147313" role="paragraph">
<emph>DataY</emph> is the array or matrix of Y data.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156097" role="paragraph">
<emph>DataX</emph> is the array or matrix of X data.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3145204" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3156131" role="paragraph">
<item type="input">=STEYX(A1:A50;B1:B50)</item>
</paragraph>
@@ -359,11 +359,11 @@
<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">DEVSQ</paragraph>
<paragraph xml-lang="en-US" id="par_id3154748" role="paragraph"><ahelp hid="HID_FUNC_SUMQUADABW">Returns the sum of squares of deviations based on a sample mean.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3156121" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3146790" role="code">DEVSQ(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155995" role="paragraph">
<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150254" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3149136" role="paragraph">
<item type="input">=DEVSQ(A1:A50)</item>
</paragraph>
@@ -375,13 +375,13 @@
<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">TINV</paragraph>
<paragraph xml-lang="en-US" id="par_id3143232" role="paragraph"><ahelp hid="HID_FUNC_TINV">Returns the inverse of the t-distribution.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155101" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149289" role="code">TINV(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id3154070" role="paragraph">
<emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155315" role="paragraph">
<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153885" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3156010" role="paragraph">
<item type="input">=TINV(0.1;6)</item> returns 1.94</paragraph>
</section>
@@ -393,11 +393,11 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_MS" id="bm_id2953155" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2949579" role="heading" level="2">T.INV</paragraph>
<paragraph xml-lang="en-US" id="par_id2943232" role="paragraph"><ahelp hid="HID_FUNC_TINV_MS">Returns the one tailed inverse of the t-distribution.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2955101" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2949289" role="code">T.INV(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954070" role="paragraph"><emph>Number</emph> is the probability associated with the one-tailed t-distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2955315" role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2953885" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2956010" role="paragraph"><item type="input">=T.INV(0.1;6)</item> returns -1.4397557473.</paragraph>
</section>
<section id="tdotinvdot2t">
@@ -408,11 +408,11 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_2T" id="bm_id2853155" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2849579" role="heading" level="2">T.INV.2T</paragraph>
<paragraph xml-lang="en-US" id="par_id2843232" role="paragraph"><ahelp hid="HID_FUNC_TINV_2T">Calculates the inverse of the two-tailed Student's T Distribution </ahelp>, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2855101" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2849289" role="code">T.INV.2T(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2854070" role="paragraph"><emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2855315" role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2853885" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2856010" role="paragraph"><item type="input">=T.INV.2T(0.25; 10)</item> returns 1.221255395.</paragraph>
</section>
<section id="ttest">
@@ -421,7 +421,7 @@
<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">TTEST</paragraph>
<paragraph xml-lang="en-US" id="par_id3159184" role="paragraph"><ahelp hid="HID_FUNC_TTEST">Returns the probability associated with a Student's t-Test.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147257" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3151175" role="code">TTEST(Data1; Data2; Mode; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id3149202" role="paragraph">
<emph>Data1</emph> is the dependent array or range of data for the first record.</paragraph>
@@ -431,7 +431,7 @@
<emph>Mode</emph> = 1 calculates the one-tailed test, <emph>Mode</emph> = 2 the two- tailed test.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155327" role="paragraph">
<emph>Type</emph> is the kind of t-test to perform. Type 1 means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3 means two samples, unequal variance (heteroscedastic).</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3159342" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3150119" role="paragraph">
<item type="input">=TTEST(A1:A50;B1:B50;2;2)</item>
</paragraph>
@@ -443,13 +443,13 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST_MS" id="bm_id2953981" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2954129" role="heading" level="2">T.TEST</paragraph>
<paragraph xml-lang="en-US" id="par_id2959184" role="paragraph"><ahelp hid="HID_FUNC_TTEST_MS">Returns the probability associated with a Student's t-Test.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2947257" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2951175" role="code">T.TEST(Data1; Data2; Mode; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2949202" role="paragraph"><emph>Data1</emph> is the dependent array or range of data for the first record.</paragraph>
<paragraph xml-lang="en-US" id="par_id2945666" role="paragraph"><emph>Data2</emph> is the dependent array or range of data for the second record.</paragraph>
<paragraph xml-lang="en-US" id="par_id2953903" role="paragraph"><emph>Mode</emph> = 1 calculates the one-tailed test, <emph>Mode</emph> = 2 the two- tailed test.</paragraph>
<paragraph xml-lang="en-US" id="par_id2955327" role="paragraph"><emph>Type</emph> is the kind of t-test to perform. Type 1 means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3 means two samples, unequal variance (heteroscedastic).</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2959342" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2950119" role="paragraph"><item type="input">=T.TEST(A1:A50;B1:B50;2;2)</item></paragraph>
</section>
<section id="tdist">
@@ -459,7 +459,7 @@
<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">TDIST</paragraph>
<paragraph xml-lang="en-US" id="par_id3153372" role="paragraph"><ahelp hid="HID_FUNC_TVERT">Returns the t-distribution.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149911" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150521" role="code">TDIST(Number; DegreesFreedom; Mode)</paragraph>
<paragraph xml-lang="en-US" id="par_id3146991" role="paragraph">
<emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph>
@@ -467,7 +467,7 @@
<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149340" role="paragraph">
<emph>Mode</emph> = 1 returns the one-tailed test, <emph>Mode</emph> = 2 returns the two-tailed test.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3159150" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3149773" role="paragraph">
<item type="input">=TDIST(12;5;1)</item>
</paragraph>
@@ -480,12 +480,12 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_MS" id="bm_id2953095" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2954930" role="heading" level="2">T.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2953372" role="paragraph"><ahelp hid="HID_FUNC_TDIST_MS">Returns the t-distribution.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2949911" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2950521" role="code">T.DIST(Number; DegreesFreedom; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2946991" role="paragraph"><emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph>
<paragraph xml-lang="en-US" id="par_id2948824" role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2949340" role="paragraph"><emph>Cumulative</emph> = 0 or FALSE returns the probability density function, 1 or TRUE returns the cumulative distribution function.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2959150" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2949773" role="paragraph"><item type="input">=T.DIST(1; 10; TRUE)</item> returns 0.8295534338</paragraph>
</section>
<section id="tdotdistdot2t">
@@ -496,11 +496,11 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_2T" id="bm_id2853095" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2854930" role="heading" level="2">T.DIST.2T</paragraph>
<paragraph xml-lang="en-US" id="par_id2853372" role="paragraph"><ahelp hid="HID_FUNC_TDIST_2T">Calculates the two-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2849911" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2850521" role="code">T.DIST.2T(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2846991" role="paragraph"><emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph>
<paragraph xml-lang="en-US" id="par_id2848824" role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2859150" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2849773" role="paragraph"><item type="input">=T.DIST.2T(1; 10)</item> returns 0.3408931323.</paragraph>
</section>
<section id="tdotdistdotrt">
@@ -511,11 +511,11 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_RT" id="bm_id273095" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id274930" role="heading" level="2">T.DIST.RT</paragraph>
<paragraph xml-lang="en-US" id="par_id2753372" role="paragraph"><ahelp hid="HID_FUNC_TDIST_RT">Calculates the right-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2749911" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2750521" role="code">T.DIST.RT(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2746991" role="paragraph"><emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph>
<paragraph xml-lang="en-US" id="par_id2748824" role="paragraph"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2759150" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2749773" role="paragraph"><item type="input">=T.DIST.RT(1; 10)</item> returns 0.1704465662.</paragraph>
</section>
<section id="var">
@@ -525,11 +525,11 @@
<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">VAR</paragraph>
<paragraph xml-lang="en-US" id="par_id3159165" role="paragraph"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3154286" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153054" role="code">VAR(Number1 ; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3148938" role="paragraph">
<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147233" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153575" role="paragraph">
<item type="input">=VAR(A1:A50)</item>
</paragraph>
@@ -542,10 +542,10 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_S" id="bm_id2954898" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2953828" role="heading" level="2">VAR.S</paragraph>
<paragraph xml-lang="en-US" id="par_id2959165" role="paragraph"><ahelp hid="HID_FUNC_VAR_S">Estimates the variance based on a sample.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2954286" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953054" role="code">VAR.S(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2948938" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2947233" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953575" role="paragraph"><item type="input">=VAR.S(A1:A50)</item></paragraph>
</section>
<section id="vara">
@@ -554,11 +554,11 @@
<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">VARA</paragraph>
<paragraph xml-lang="en-US" id="par_id3155122" role="paragraph"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a sample. The value of text is 0.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149176" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149999" role="code">VARA(Value1; Value2; ...; Value30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3158421" role="paragraph">
<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149160" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3154279" role="paragraph">
<item type="input">=VARA(A1:A50)</item>
</paragraph>
@@ -569,11 +569,11 @@
<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">VARP</paragraph>
<paragraph xml-lang="en-US" id="par_id3159199" role="paragraph"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire population.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150706" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147282" role="code">VARP(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3149793" role="paragraph">
<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3152939" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153385" role="paragraph">
<item type="input">=VARP(A1:A50)</item>
</paragraph>
@@ -585,10 +585,10 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_P_MS" id="bm_id2952359" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2966441" role="heading" level="2">VAR.P</paragraph>
<paragraph xml-lang="en-US" id="par_id2959199" role="paragraph"><ahelp hid="HID_FUNC_VAR_P_MS">Calculates a variance based on the entire population.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2950706" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2949793" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2952939" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953385" role="paragraph"><item type="input">=VAR.P(A1:A50)</item></paragraph>
</section>
<section id="varpa">
@@ -597,11 +597,11 @@
<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">VARPA</paragraph>
<paragraph xml-lang="en-US" id="par_id3149109" role="paragraph"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based on the entire population. The value of text is 0.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3152880" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149967" role="code">VARPA(Value1; Value2; ...; Value30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3149920" role="paragraph">
<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3154862" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3156203" role="paragraph">
<item type="input">=VARPA(A1:A50)</item>
</paragraph>
@@ -613,13 +613,13 @@
<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">PERMUT</paragraph>
<paragraph xml-lang="en-US" id="par_id3154334" role="paragraph"><ahelp hid="HID_FUNC_VARIATIONEN">Returns the number of permutations for a given number of objects.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149422" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3148466" role="code">PERMUT(Count1; Count2)</paragraph>
<paragraph xml-lang="en-US" id="par_id3148656" role="paragraph">
<emph>Count1</emph> is the total number of objects.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150826" role="paragraph">
<emph>Count2</emph> is the number of objects in each permutation.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153351" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3150424" role="paragraph">
<item type="input">=PERMUT(6;3)</item> returns 120. There are 120 different possibilities, to pick a sequence of 3 playing cards out of 6 playing cards.</paragraph>
</section>
@@ -629,13 +629,13 @@
<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">PERMUTATIONA</paragraph>
<paragraph xml-lang="en-US" id="par_id3144759" role="paragraph"><ahelp hid="HID_FUNC_VARIATIONEN2">Returns the number of permutations for a given number of objects (repetition allowed).</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3145598" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149298" role="code">PERMUTATIONA(Count1; Count2)</paragraph>
<paragraph xml-lang="en-US" id="par_id3156139" role="paragraph">
<emph>Count1</emph> is the total number of objects.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149519" role="paragraph">
<emph>Count2</emph> is the number of objects in each permutation.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3151382" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153949" role="paragraph">How often can 2 objects be selected from a total of 11 objects?</paragraph>
<paragraph xml-lang="en-US" id="par_id3149233" role="paragraph">
<item type="input">=PERMUTATIONA(11;2)</item> returns 121.</paragraph>
@@ -648,7 +648,7 @@
<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">PROB</paragraph>
<paragraph xml-lang="en-US" id="par_id3154110" role="paragraph"><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>
- <paragraph xml-lang="en-US" id="hd_id3146810" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147330" role="code">PROB(Data; Probability; Start; End)</paragraph>
<paragraph xml-lang="en-US" id="par_id3154573" role="paragraph">
<emph>Data</emph> is the array or range of data in the sample.</paragraph>
@@ -658,7 +658,7 @@
<emph>Start</emph> is the start value of the interval whose probabilities are to be summed.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153694" role="paragraph">
<emph>End</emph> (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the <emph>Start</emph> value is calculated.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147574" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153666" role="paragraph">
<item type="input">=PROB(A1:A50;B1:B50;50;60)</item> returns the probability with which a value within the range of A1:A50 is also within the limits between 50 and 60. Every value within the range of A1:A50 has a probability within the range of B1:B50.</paragraph>
</section>
@@ -671,7 +671,7 @@
<paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph">The Weibull distribution is a continuous probability distribution, with parameters Alpha &gt; 0 (shape) and Beta &gt; 0 (scale).</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph">If C is 0, WEIBULL calculates the probability density function.</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372743" role="paragraph">If C is 1, WEIBULL calculates the cumulative distribution function.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3159393" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154478" role="code">WEIBULL(Number; Alpha; Beta; C)</paragraph>
<paragraph xml-lang="en-US" id="par_id3151317" role="paragraph">
<emph>Number</emph> is the value at which to calculate the Weibull distribution.</paragraph>
@@ -681,7 +681,7 @@
<emph>Beta</emph> is the scale parameter of the Weibull distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3154825" role="paragraph">
<emph>C</emph> indicates the type of function.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153794" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3146077" role="paragraph">
<item type="input">=WEIBULL(2;1;1;1)</item> returns 0.86.</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372899" role="paragraph">See also the <link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function" name="wiki.documentfoundation.org Documentation/HowTo/Calc/WEIBULL function">Wiki page</link>.</paragraph>
@@ -696,13 +696,13 @@
<paragraph xml-lang="en-US" id="par_id2905200911372767" role="paragraph">The Weibull distribution is a continuous probability distribution, with parameters Alpha &gt; 0 (shape) and Beta &gt; 0 (scale). </paragraph>
<paragraph xml-lang="en-US" id="par_id2905200911372777" role="paragraph">If C is 0, WEIBULL.DIST calculates the probability density function.</paragraph>
<paragraph xml-lang="en-US" id="par_id2905200911372743" role="paragraph">If C is 1, WEIBULL.DIST calculates the cumulative distribution function.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2959393" role="heading" level="3">Syntax</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2954478" role="code">WEIBULL.DIST(Number; Alpha; Beta; C)</paragraph>
<paragraph xml-lang="en-US" id="par_id2951317" role="paragraph"><emph>Number</emph> is the value at which to calculate the Weibull distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2958436" role="paragraph"><emph>Alpha </emph>is the shape parameter of the Weibull distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2954668" role="paragraph"><emph>Beta</emph> is the scale parameter of the Weibull distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id2954825" role="paragraph"><emph>C</emph> indicates the type of function.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2953794" role="heading" level="3">Example</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2946077" role="paragraph"><item type="input">=WEIBULL.DIST(2;1;1;1)</item> returns 0.8646647168.</paragraph>
<paragraph xml-lang="en-US" id="par_id2905200911372899" role="paragraph">See also the <link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function" name="wiki.documentfoundation.org Documentation/HowTo/Calc/WEIBULL function">Wiki page</link>.</paragraph>
</section>