diff options
| author | Steve Fanning <stevemfanning.wh@gmail.com> | 2020-03-24 20:04:52 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-25 22:27:29 +0100 |
| commit | dac90072fecdfa76352153616f102d3229b5512e (patch) | |
| tree | 0f87523364419d523af7a79ac2d52930b73a553b /source/text/scalc/01/04060185.xhp | |
| parent | Correct arguments for TEXTJOIN (diff) | |
| download | help-dac90072fecdfa76352153616f102d3229b5512e.tar.gz help-dac90072fecdfa76352153616f102d3229b5512e.zip | |
tdf#131361 Adjust number of function parameters
Fixes for SUM, SUMSQ, NPV, AVEDEV, AVERAGE, AVERAGEA
COUNT, COUNTA, DEVSQ, KURT
Change-Id: I1227064ed343ccccd5a339cce7425b5143072537
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91013
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.xhp | 95 |
1 files changed, 47 insertions, 48 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 9d5c12c764..92117446e4 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -27,15 +27,15 @@ </topic> </meta> <body> - <paragraph xml-lang="en-US" id="hd_id3147072" role="heading" level="1"><variable id="rz"><link href="text/scalc/01/04060185.xhp" name="Statistical Functions Part Five">Statistical Functions Part Five</link> -</variable></paragraph> + <h1 id="hd_id3147072"><variable id="rz"><link href="text/scalc/01/04060185.xhp" name="Statistical Functions Part Five">Statistical Functions Part Five</link> +</variable></h1> <sort order="asc"> <section id="rank"> <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/SC_HID_FUNC_RANG" id="bm_id3146778" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3155071" role="heading" level="2">RANK</paragraph> +<h2 id="hd_id3155071">RANK</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3153250" role="code">RANK(Value; Data; Type)</paragraph> @@ -57,9 +57,9 @@ <bookmark_value>numbers;determining ranks</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANK_AVG" id="bm_id2946778" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id2955071" role="heading" level="2">RANK.AVG</paragraph> +<h2 id="hd_id2955071">RANK.AVG</h2> <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> +<note id="par_id2653976">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.</note> <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> @@ -77,9 +77,9 @@ <bookmark_value>numbers;determining ranks</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANK_EQ" id="bm_id2846778" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id2855071" role="heading" level="2">RANK.EQ</paragraph> +<h2 id="hd_id2855071">RANK.EQ</h2> <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> +<note id="par_id2753976">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.</note> <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> @@ -95,7 +95,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3153556">SKEW</h2> <paragraph xml-lang="en-US" id="par_id3153485" role="paragraph"><ahelp hid="HID_FUNC_SCHIEFE">Returns the skewness of a distribution.</ahelp></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> @@ -106,7 +106,7 @@ <item type="input">=SKEW(A1:A50)</item> calculates the value of skew for the data referenced.</paragraph> </section> <section id="skewp"> - <paragraph id="hd_id72921349523046" role="heading" level="2" localize="false" xml-lang="en-US"></paragraph> + <h2 id="hd_id72921349523046"/> <embed href="text/scalc/01/func_skewp.xhp#skewp_function"/> </section> <section id="forecast"> @@ -115,7 +115,7 @@ <bookmark_value>FORECAST function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3149051">FORECAST</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3147404" role="code">FORECAST(Value; DataY; DataX)</paragraph> @@ -135,7 +135,7 @@ <bookmark_value>FORECAST.LINEAR function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3149052">FORECAST.LINEAR</h2> <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> <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> @@ -154,7 +154,7 @@ <bookmark_value>standard deviations in statistics;based on a sample</bookmark_value> </bookmark> <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> +<h2 id="hd_id3149143">STDEV</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3149946" role="code">STDEV(Number1; Number2; ...; Number30)</paragraph> @@ -168,7 +168,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3144745">STDEVA</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3147422" role="code">STDEVA(Value1; Value2; ...; Value30)</paragraph> @@ -183,7 +183,7 @@ <bookmark_value>standard deviations in statistics;based on a population</bookmark_value> </bookmark> <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> +<h2 id="hd_id3149734">STDEVP</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3154392" role="code">STDEVP(Number1; Number2; ...; Number30)</paragraph> @@ -199,7 +199,7 @@ <bookmark_value>standard deviations in statistics;based on a population</bookmark_value> </bookmark> <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> + <h2 id="hd_id2949734">STDEV.P</h2> <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"/> @@ -214,7 +214,7 @@ <bookmark_value>standard deviations in statistics;based on a sample</bookmark_value> </bookmark> <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> + <h2 id="hd_id2849734">STDEV.S</h2> <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"/> @@ -227,7 +227,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3154522"><bookmark_value>STDEVPA function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3154522">STDEVPA</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3146851" role="code">STDEVPA(Value1; Value2; ...; Value30)</paragraph> @@ -242,7 +242,7 @@ <bookmark_value>converting;random variables, into normalized values</bookmark_value> </bookmark> <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> +<h2 id="hd_id3155928">STANDARDIZE</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3150132" role="code">STANDARDIZE(Number; Mean; StDev)</paragraph> @@ -261,7 +261,7 @@ <bookmark_value>normal distribution;inverse of standard</bookmark_value> </bookmark> <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> +<h2 id="hd_id3157986">NORMSINV</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3154195" role="code">NORMSINV(Number)</paragraph> @@ -276,7 +276,7 @@ <bookmark_value>normal distribution;inverse of standard</bookmark_value> </bookmark> <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> +<h2 id="hd_id2957986">NORM.S.INV</h2> <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"/> @@ -292,7 +292,7 @@ <bookmark_value>normal distribution;statistics</bookmark_value> </bookmark> <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">NORMSDIST</paragraph> +<h2 id="hd_id3147538">NORMSDIST</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> @@ -308,7 +308,7 @@ <bookmark_value>normal distribution;statistics</bookmark_value> </bookmark> <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> +<h2 id="hd_id2947538">NORM.S.DIST</h2> <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"/> @@ -327,7 +327,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3152592">SLOPE</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3149819" role="code">SLOPE(DataY; DataX)</paragraph> @@ -345,7 +345,7 @@ <bookmark_value>standard errors;statistical functions</bookmark_value> </bookmark><comment>mw changed "standard errors"</comment> <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> +<h2 id="hd_id3155836">STEYX</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3151267" role="code">STEYX(DataY; DataX)</paragraph> @@ -363,12 +363,11 @@ <bookmark_value>sums;of squares of deviations</bookmark_value> </bookmark> <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> +<h2 id="hd_id3150873">DEVSQ</h2> <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> <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="par_id3146790" role="code">DEVSQ(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> + <embed href="text/scalc/01/ful_func.xhp#number255"/> <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> @@ -379,7 +378,7 @@ <bookmark_value>inverse of t-distribution</bookmark_value> </bookmark> <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> +<h2 id="hd_id3149579">TINV</h2> <paragraph xml-lang="en-US" id="par_id3143232" role="paragraph"><ahelp hid="HID_FUNC_TINV">Returns the inverse of the t-distribution.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3149289" role="code">TINV(Number; DegreesFreedom)</paragraph> @@ -397,7 +396,7 @@ <bookmark_value>one tailed inverse of t-distribution</bookmark_value> </bookmark> <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> + <h2 id="hd_id2949579">T.INV</h2> <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"/> @@ -413,7 +412,7 @@ <bookmark_value>inverse of two tailed t-distribution</bookmark_value> </bookmark> <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> + <h2 id="hd_id2849579">T.INV.2T</h2> <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"/> @@ -427,7 +426,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3154129">TTEST</h2> <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> <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> @@ -449,7 +448,7 @@ <bookmark_value>T.TEST function</bookmark_value> </bookmark> <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> + <h2 id="hd_id2954129">T.TEST</h2> <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"/> @@ -466,7 +465,7 @@ <bookmark_value>t-distribution</bookmark_value> </bookmark> <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> +<h2 id="hd_id3154930">TDIST</h2> <paragraph xml-lang="en-US" id="par_id3153372" role="paragraph"><ahelp hid="HID_FUNC_TVERT">Returns the t-distribution.</ahelp></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> @@ -487,7 +486,7 @@ <bookmark_value>t-distribution</bookmark_value> </bookmark> <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> + <h2 id="hd_id2954930">T.DIST</h2> <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"/> @@ -504,7 +503,7 @@ <bookmark_value>two tailed t-distribution</bookmark_value> </bookmark> <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> + <h2 id="hd_id2854930">T.DIST.2T</h2> <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"/> @@ -520,7 +519,7 @@ <bookmark_value>right tailed t-distribution</bookmark_value> </bookmark> <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> + <h2 id="hd_id274930">T.DIST.RT</h2> <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"/> @@ -535,7 +534,7 @@ <bookmark_value>variances</bookmark_value> </bookmark> <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> +<h2 id="hd_id3153828">VAR</h2> <paragraph xml-lang="en-US" id="par_id3159165" role="paragraph"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></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> @@ -552,7 +551,7 @@ <bookmark_value>variances</bookmark_value> </bookmark> <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> + <h2 id="hd_id2953828">VAR.S</h2> <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"/> @@ -565,7 +564,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3151045"><bookmark_value>VARA function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3151045">VARA</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3149999" role="code">VARA(Value1; Value2; ...; Value30)</paragraph> @@ -580,7 +579,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3166441"><bookmark_value>VARP function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3166441">VARP</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3147282" role="code">VARP(Number1; Number2; ...; Number30)</paragraph> @@ -596,7 +595,7 @@ <bookmark_value>VAR.P function</bookmark_value> </bookmark> <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> + <h2 id="hd_id2966441">VAR.P</h2> <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"/> @@ -609,7 +608,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3153688">VARPA</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3149967" role="code">VARPA(Value1; Value2; ...; Value30)</paragraph> @@ -625,7 +624,7 @@ <bookmark_value>number of permutations</bookmark_value> </bookmark> <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> +<h2 id="hd_id3154599">PERMUT</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3148466" role="code">PERMUT(Count1; Count2)</paragraph> @@ -641,7 +640,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3143276"><bookmark_value>PERMUTATIONA function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3143276">PERMUTATIONA</h2> <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3149298" role="code">PERMUTATIONA(Count1; Count2)</paragraph> @@ -660,7 +659,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3152952"><bookmark_value>PROB function</bookmark_value> </bookmark> <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> +<h2 id="hd_id3152952">PROB</h2> <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> <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> @@ -680,7 +679,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150941"><bookmark_value>WEIBULL function</bookmark_value> </bookmark> <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">WEIBULL</paragraph> +<h2 id="hd_id3150941">WEIBULL</h2> <paragraph xml-lang="en-US" id="par_id3154916" role="paragraph"><ahelp hid="HID_FUNC_WEIBULL">Returns the values of the Weibull distribution.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph">The Weibull distribution is a continuous probability distribution, with parameters Alpha > 0 (shape) and Beta > 0 (scale).</paragraph> <paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph">If C is 0, WEIBULL calculates the probability density function.</paragraph> @@ -705,7 +704,7 @@ <bookmark_value>WEIBULL.DIST function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEIBULL_DIST_MS" id="bm_id3150406" localize="false"/> - <paragraph xml-lang="en-US" id="hd_id2950941" role="heading" level="2">WEIBULL.DIST</paragraph> + <h2 id="hd_id2950941">WEIBULL.DIST</h2> <paragraph xml-lang="en-US" id="par_id2954916" role="paragraph"><ahelp hid="HID_FUNC_WEIBULL_DIST_MS">Returns the values of the Weibull distribution.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id2905200911372767" role="paragraph">The Weibull distribution is a continuous probability distribution, with parameters Alpha > 0 (shape) and Beta > 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> |