diff options
Diffstat (limited to 'source/text/scalc/01/04060184.xhp')
| -rw-r--r-- | source/text/scalc/01/04060184.xhp | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index 6b03223313..9f7e210a05 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -180,6 +180,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MS" id="bm_id2949253" localize="false"/> <paragraph xml-lang="en-US" id="hd_id2953933" role="heading" level="2">MODE.SNGL</paragraph> <paragraph xml-lang="en-US" id="par_id2953085" role="paragraph"><ahelp hid="HID_FUNC_MODAL_VALUE_MS">Returns the most frequently occurring, or repetitive, value in an array or range of data.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</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_id2955950" role="code">MODE.SNGL(Number1; Number2; ...; Number30)</paragraph> <paragraph xml-lang="en-US" id="par_id2950337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph> @@ -194,6 +195,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MULTI" id="bm_id2849253" localize="false"/> <paragraph xml-lang="en-US" id="hd_id2853933" role="heading" level="2">MODE.MULT</paragraph> <paragraph xml-lang="en-US" id="par_id2853085" role="paragraph"><ahelp hid="HID_FUNC_MODAL_VALUE_MULTI">Returns a vertical array of the statistical modes (the most frequently occurring values) within a list of supplied numbers.</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_id2855950" role="code">MODE.MULT(Number1; Number2; ...; Number30)</paragraph> <paragraph xml-lang="en-US" id="par_id2850337" role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges.</paragraph> @@ -224,6 +226,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMDIST_MS" id="bm_id2959135" localize="false"/> <paragraph xml-lang="en-US" id="hd_id2949879" role="heading" level="2">NEGBINOM.DIST</paragraph> <paragraph xml-lang="en-US" id="par_id2955437" role="paragraph"><ahelp hid="HID_FUNC_NEGBINOMDIST_MS">Returns the negative binomial density or distribution function.</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_id2950935" role="code">NEGBINOM.DIST(X; R; SP; Cumulative)</paragraph> <paragraph xml-lang="en-US" id="par_id2953044" role="paragraph"><emph>X</emph> represents the value returned for unsuccessful tests.</paragraph> @@ -257,6 +260,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV_MS" id="bm_id2949396" localize="false"/> <paragraph xml-lang="en-US" id="hd_id2955516" role="heading" level="2">NORM.INV</paragraph> <paragraph xml-lang="en-US" id="par_id2954634" role="paragraph"><ahelp hid="HID_FUNC_NORMINV_MS">Returns the inverse of the 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_id2947534" role="code">NORM.INV(Number; Mean; StDev)</paragraph> <paragraph xml-lang="en-US" id="par_id2954950" role="paragraph"><emph>Number</emph> represents the probability value used to determine the inverse normal distribution.</paragraph> @@ -292,6 +296,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMDIST_MS" id="bm_id2917484" localize="false"/> <paragraph xml-lang="en-US" id="hd_id2913722" role="heading" level="2">NORM.DIST</paragraph> <paragraph xml-lang="en-US" id="par_id2910386" role="paragraph"><ahelp hid="HID_FUNC_NORMDIST_MS">Returns the density function or the 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_id2910613" role="code">NORM.DIST(Number; Mean; StDev; C)</paragraph> <paragraph xml-lang="en-US" id="par_id2919820" role="paragraph"><emph>Number</emph> is the value of the distribution based on which the normal distribution is to be calculated.</paragraph> @@ -357,6 +362,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POISSON_DIST_MS" id="bm_id2956011" localize="false"/> <paragraph xml-lang="en-US" id="hd_id2953985" role="heading" level="2">POISSON.DIST</paragraph> <paragraph xml-lang="en-US" id="par_id2954298" role="paragraph"><ahelp hid="HID_FUNC_POISSON_DIST_MS">Returns the Poisson distribution.</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_id2946093" role="code">POISSON.DIST(Number; Mean; C)</paragraph> <paragraph xml-lang="en-US" id="par_id2947253" role="paragraph"><emph>Number</emph> represents the value based on which the Poisson distribution is calculated.</paragraph> @@ -387,6 +393,7 @@ <paragraph xml-lang="en-US" id="par_id2854940" role="paragraph"><ahelp hid="HID_FUNC_PERCENTILE_EXC">Returns the <item type="literal">Alpha</item>'th percentile of a supplied range of values for a given value of <item type="literal">Alpha</item>, within the range 0 to 1 (exclusive).</ahelp> A percentile returns the scale value for a data series which goes from the smallest (<item type="literal">Alpha=0</item>) to the largest value (<item type="literal">Alpha=1</item>) of a data series. For <item type="literal">Alpha</item> = 25%, the percentile means the first quartile; <item type="literal">Alpha</item> = 50% is the MEDIAN.</paragraph> <paragraph xml-lang="en-US" id="par_id2754940" role="warning">If <item type="literal">Alpha</item> is not a multiple of <item type="literal">1/(n+1)</item>, (where n is the number of values in the supplied array), the function interpolates between the values in the supplied array, to calculate the percentile value. However, if <item type="literal">Alpha</item> is less than <item type="literal">1/(n+1)</item> or <item type="literal">Alpha</item> is greater than <item type="literal">n/(n+1)</item>, the function is unable to interpolate, and so returns an error.</paragraph> <paragraph xml-lang="en-US" id="par_id2653976" role="note">The difference between <item type="input">PERCENTILE.INC</item> and <item type="input">PERCENTILE.EXC</item> is that, in the <item type="input">PERCENTILE.INC</item> function the value of alpha is within the range 0 to 1 inclusive, and in the <item type="input">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive.</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_id2848813" role="code">PERCENTILE.EXC(Data; Alpha)</paragraph> <paragraph xml-lang="en-US" id="par_id2853054" role="paragraph"><emph>Data</emph> represents the array of data.</paragraph> @@ -401,6 +408,7 @@ <paragraph xml-lang="en-US" id="hd_id2953100" role="heading" level="2">PERCENTILE.INC</paragraph> <paragraph xml-lang="en-US" id="par_id2954940" role="paragraph"><ahelp hid="HID_FUNC_PERCENTILE_INC">Returns the alpha-percentile of data values in an array.</ahelp> A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For <item type="literal">Alpha</item> = 25%, the percentile means the first quartile; <item type="literal">Alpha</item> = 50% is the MEDIAN.</paragraph> <paragraph xml-lang="en-US" id="par_id2753976" role="note">The difference between <item type="input">PERCENTILE.INC</item> and <item type="input">PERCENTILE.EXC</item> is that, in the <item type="input">PERCENTILE.INC</item> function the value of alpha is within the range 0 to 1 inclusive, and in the <item type="input">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive.</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_id2948813" role="code">PERCENTILE.INC(Data; Alpha)</paragraph> <paragraph xml-lang="en-US" id="par_id2953054" role="paragraph"><emph>Data</emph> represents the array of data.</paragraph> @@ -429,6 +437,7 @@ <paragraph xml-lang="en-US" id="hd_id2848807" role="heading" level="2">PERCENTRANK.EXC</paragraph> <paragraph xml-lang="en-US" id="par_id2853573" role="paragraph"><ahelp hid="HID_FUNC_PERCENTRANK_EXC"> Returns the relative position, between 0 and 1 (exclusive), of a specified value within a supplied array.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id2553976" role="note">The difference between <item type="input">PERCENTRANK.INC</item> and <item type="input">PERCENTRANK.EXC</item> is that <item type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive.</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_id2847238" role="code">PERCENTRANK.EXC(Data; Value; Significance)</paragraph> <paragraph xml-lang="en-US" id="par_id2854266" role="paragraph"><emph>Data</emph> represents the array of data in the sample.</paragraph> @@ -443,6 +452,7 @@ <paragraph xml-lang="en-US" id="hd_id2948807" role="heading" level="2">PERCENTRANK.INC</paragraph> <paragraph xml-lang="en-US" id="par_id2953573" role="paragraph"><ahelp hid="HID_FUNC_PERCENTRANK_INC">Returns the relative position, between 0 and 1 (inclusive), of a specified value within a supplied array.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id2453976" role="note">The difference between <item type="input">PERCENTRANK.INC</item> and <item type="input">PERCENTRANK.EXC</item> is that <item type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive.</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_id2947238" role="code">PERCENTRANK.INC(Data; Value; Significance)</paragraph> <paragraph xml-lang="en-US" id="par_id2954266" role="paragraph"><emph>Data</emph> represents the array of data in the sample.</paragraph> @@ -472,6 +482,7 @@ <paragraph xml-lang="en-US" id="hd_id2866442" role="heading" level="2">QUARTILE.EXC</paragraph> <paragraph xml-lang="en-US" id="par_id2846958" role="paragraph"><ahelp hid="HID_FUNC_QUARTILE_EXC">Returns a requested quartile of a supplied range of values, based on a percentile range of 0 to 1 exclusive.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id2353976" role="note">The difference between <item type="input">QUARTILE.INC</item> and <item type="input">QUARTILE.EXC</item> is that the <item type="input">QUARTILE.INC</item> function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the <item type="input">QUARTILE.EXC</item> function bases its calculation on a percentile range of 0 to 1 exclusive.</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_id2853684" role="code">QUARTILE.EXC(Data; Type)</paragraph> <paragraph xml-lang="en-US" id="par_id2853387" role="paragraph"><emph>Data</emph> represents the range of data values for which you want to calculate the specified quartile.</paragraph> @@ -487,6 +498,7 @@ <paragraph xml-lang="en-US" id="hd_id2966442" role="heading" level="2">QUARTILE.INC</paragraph> <paragraph xml-lang="en-US" id="par_id2946958" role="paragraph"><ahelp hid="HID_FUNC_QUARTILE_INC">Returns the quartile of a data set.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id2253976" role="note">The difference between <item type="input">QUARTILE.INC</item> and <item type="input">QUARTILE.EXC</item> is that the <item type="input">QUARTILE.INC</item> function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the <item type="input">QUARTILE.EXC</item> function bases its calculation on a percentile range of 0 to 1 exclusive.</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_id2953684" role="code">QUARTILE.INC(Data; Type)</paragraph> <paragraph xml-lang="en-US" id="par_id2953387" role="paragraph"><emph>Data</emph> represents the array of data in the sample.</paragraph> |