summaryrefslogtreecommitdiffstats
path: root/source/text/scalc/01/04060185.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2019-04-25 17:53:14 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-04-27 13:59:57 +0200
commit0a874cee4a5d694b6c055b896d4dc64f7151b001 (patch)
tree271886a28c592a2bdb2ab6f024de974bb2e29cfd /source/text/scalc/01/04060185.xhp
parenttdf#124198 Impress & Draw ImageMap menu entry was moved to Tools (diff)
downloadhelp-0a874cee4a5d694b6c055b896d4dc64f7151b001.tar.gz
help-0a874cee4a5d694b6c055b896d4dc64f7151b001.zip
tdf#123803 Add release info in Calc functions
Change-Id: I0476c79fe5407c3e7252ef16da4110a026b29fa8 Note: some Calc functions still lack help pages. Reviewed-on: https://gerrit.libreoffice.org/71331 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.xhp15
1 files changed, 15 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 901aa10bd7..9d5c12c764 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -60,6 +60,7 @@
<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>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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>
@@ -79,6 +80,7 @@
<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>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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>
@@ -199,6 +201,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<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>
@@ -213,6 +216,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<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>
@@ -274,6 +278,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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">
@@ -305,6 +310,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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">
@@ -393,6 +399,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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>
@@ -408,6 +415,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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>
@@ -443,6 +451,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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>
@@ -480,6 +489,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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>
@@ -496,6 +506,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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>
@@ -511,6 +522,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<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>
@@ -542,6 +554,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<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>
@@ -585,6 +598,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<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>
@@ -696,6 +710,7 @@
<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>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<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>