diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2021-12-31 14:23:17 -0300 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2022-01-01 03:26:08 +0100 |
| commit | 7ad8f2bbd7b786557b8bcd9b275e0c312a921bf8 (patch) | |
| tree | 04cac653d9634d292e085c1ffa289689cfad5c8b /source | |
| parent | 830ed1f1dd5ad301e635f32f4120297fcb104000 (diff) | |
tdf#94537 COM.MICROSOFT.* namespace information
+ Covered all COM.MICROSOFT namespace of wiki page in the bug report.
+ refactor of other info such as release number availability.
+ Muted l10N in a table and drop duplication.
Change-Id: Id77f9657f164193d5e672e9edf82a2170b5f4040
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127817
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source')
23 files changed, 356 insertions, 205 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 9ddbcf00a7..c05a24580a 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -46,15 +46,15 @@ <bookmark_value>using double quotation marks in formulas</bookmark_value> <bookmark_value>formulas; using double quotation marks</bookmark_value> </bookmark> - -<h2 id="hd_id291624454173529">Using double quotation marks in formulas</h2> + +<h2 id="hd_id291624454173529">Using double quotation marks in formulas</h2> <paragraph role="paragraph" id="par_id891624454058773">To include a text string in a formula, place the text string between two double quotation marks (") and Calc takes the characters in the string without attempting to interpret them. For example, the formula <input>="Hello world!"</input> displays the text string <literal>Hello world!</literal> in the cell, with no surrounding double quotation marks.</paragraph> <paragraph role="paragraph" id="par_id461624454425320">The more complex formula <input>=CONCATENATE("Life is really simple, "; "but we insist on making it complicated "; "(Confucius).")</input> concatenates three individual strings in double quotation marks, outputting <literal>Life is really simple, but we insist on making it complicated (Confucius).</literal></paragraph> <paragraph role="paragraph" id="par_id711624454477483">To place a literal double quotation mark within a string inside a formula, two methods can be used:</paragraph> - + <list type="ordered"> <listitem> <paragraph id="par_id541624454496424" role="listitem">You can "escape" the double quotation mark with an additional double quotation mark, and Calc treats the escaped double quotation mark as a literal value. For example, the formula <input>="My name is ""John Doe""."</input> outputs the string <literal>My name is "John Doe".</literal> Another simple example is the formula <input>=UNICODE("""")</input> which returns <literal>34</literal>, the decimal value of the Unicode quotation mark character (U+0022) — here the first and fourth double quotation marks indicate the beginning and end of the string, while the second double quotation mark escapes the third.</paragraph> @@ -82,9 +82,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id9323709"> <bookmark_value>BAHTTEXT function</bookmark_value> </bookmark> - <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BAHTTEXT" id="bm_id744346" localize="false"/><comment>i66350</comment> - <h2 id="hd_id6695455">BAHTTEXT</h2> <paragraph id="par_id354014" role="paragraph" xml-lang="en-US">Converts a number to Thai text, including the Thai currency names.</paragraph> @@ -94,6 +92,9 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3289284" role="paragraph" xml-lang="en-US"> <item type="input">=BAHTTEXT(12.65)</item> returns a string in Thai characters with the meaning of "Twelve Baht and sixty five Satang".</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.BAHTTEXT</literal></paragraph> </section> <section id="base"> @@ -163,10 +164,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3147472" role="code" xml-lang="en-US">CLEAN("Text")</paragraph> <paragraph id="par_id3150695" role="paragraph" xml-lang="en-US"> <emph>Text</emph> refers to the text from which to remove all non-printable characters.</paragraph> - + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id581621538151600"><input>=LEN(CLEAN(CHAR(7) & "LibreOffice Calc" & CHAR(8)))</input> returns 16, showing that the CLEAN function removes the non-printable Unicode U+0007 ("BEL") and U+0008 ("BS") characters at the beginning and end of the string argument. CLEAN does not remove spaces.</paragraph> - + </section> <section id="code"> @@ -527,7 +528,7 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3148626" role="paragraph" xml-lang="en-US"> <item type="input">=REPT("Good morning";2)</item> returns Good morningGood morning.</paragraph> - + <tip id="par_id381626381556310">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT" name="REPT_Wiki">REPT</link> wiki page for more details about this function.</tip></section> <section id="right"> diff --git a/source/text/scalc/01/04060115.xhp b/source/text/scalc/01/04060115.xhp index 39203961e7..2629e93d02 100644 --- a/source/text/scalc/01/04060115.xhp +++ b/source/text/scalc/01/04060115.xhp @@ -64,7 +64,7 @@ <section id="besselj"> <bookmark xml-lang="en-US" branch="index" id="bm_id161618267677640"> <bookmark_value>BESSELJ function</bookmark_value> -</bookmark> +</bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELJ" id="bm_id3150539" localize="false"/> <h2 id="hd_id3153027">BESSELJ</h2> @@ -84,7 +84,7 @@ <section id="besselk"> <bookmark xml-lang="en-US" branch="index" id="bm_id151618267791726"> <bookmark_value>BESSELK function</bookmark_value> -</bookmark> +</bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELK" id="bm_id3147616" localize="false"/> <h2 id="hd_id3149946">BESSELK</h2> @@ -104,7 +104,7 @@ <section id="bessely"> <bookmark xml-lang="en-US" branch="index" id="bm_id201618267836525"> <bookmark_value>BESSELY function</bookmark_value> -</bookmark> +</bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELY" id="bm_id3150461" localize="false"/> <h2 id="hd_id3145828">BESSELY</h2> @@ -288,13 +288,16 @@ <h2 id="hd_id2983446">ERF.PRECISE</h2> <paragraph id="par_id2950381" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ERF_MS">Returns values of the Gaussian error integral between 0 and the given limit.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2963824" role="code" xml-lang="en-US">ERF.PRECISE(LowerLimit)</paragraph> <paragraph id="par_id2949715" role="paragraph" xml-lang="en-US"><emph>LowerLimit</emph> is the limit of the integral. The calculation takes place between 0 and this limit.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2952974" role="paragraph" xml-lang="en-US"> <item type="input">=ERF.PRECISE(1)</item> returns 0.842701.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id351640873986703" localize="false"><literal>COM.MICROSOFT.ERF.PRECISE</literal></paragraph> </section> <section id="erfc"> @@ -324,13 +327,16 @@ <h2 id="hd_id2945082">ERFC.PRECISE</h2> <paragraph id="par_id2949453" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ERFC_MS">Returns complementary values of the Gaussian error integral between x and infinity.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2953220" role="code" xml-lang="en-US">ERFC.PRECISE(LowerLimit)</paragraph> <paragraph id="par_id2947620" role="paragraph" xml-lang="en-US"> <emph>LowerLimit</emph> is the lower limit of the integral</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2956102" role="paragraph" xml-lang="en-US"> <item type="input">=ERFC.PRECISE(1)</item> returns 0.157299.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640853986703" localize="false"><literal>COM.MICROSOFT.ERFC.PRECISE</literal></paragraph> </section> <section id="gestep"> diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 21bf538dfa..65550ba423 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -221,7 +221,6 @@ <h2 id="hd_id2945620">BETA.INV</h2> <paragraph id="par_id2949825" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BETAINV_MS">Returns the inverse of the cumulative beta probability density function.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2956300" role="code" xml-lang="en-US">BETA.INV(Number; Alpha; Beta [; Start [; End]])</paragraph> <paragraph id="par_id2949266" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value between <emph>Start</emph> and <emph>End</emph> at which to evaluate the function.</paragraph> @@ -233,6 +232,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2946859" role="paragraph" xml-lang="en-US"><item type="input">=BETA.INV(0.5;5;10)</item> returns the value 0.3257511553.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id311640873986703" localize="false"><literal>COM.MICROSOFT.BETA.INV</literal></paragraph> </section> <section id="betadist"> @@ -284,6 +287,9 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2956118" role="paragraph" xml-lang="en-US"><item type="input">=BETA.DIST(2;8;10;1;1;3)</item> returns the value 0.6854706</paragraph> <paragraph id="par_id2956119" role="paragraph" xml-lang="en-US"><item type="input">=BETA.DIST(2;8;10;0;1;3)</item> returns the value 1.4837646</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341645873986703" localize="false"><literal>COM.MICROSOFT.BETA.DIST</literal></paragraph> </section> <section id="binomdist"> @@ -317,7 +323,6 @@ <h2 id="hd_id2943228">BINOM.DIST</h2> <paragraph id="par_id2946897" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BINOM_DIST_MS">Returns the individual term binomial distribution probability.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2956009" role="code" xml-lang="en-US">BINOM.DIST(X; Trials; SP; C)</paragraph> <paragraph id="par_id2954304" role="paragraph" xml-lang="en-US"><emph>X</emph> is the number of successes in a set of trials.</paragraph> @@ -328,6 +333,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id295666" role="paragraph" xml-lang="en-US"><item type="input">=BINOM.DIST(A1;12;0.5;0)</item> shows (if the values <item type="input">0</item> to <item type="input">12</item> are entered in A1) the probabilities for 12 flips of a coin that <emph>Heads</emph> will come up exactly the number of times entered in A1.</paragraph> <paragraph id="par_id290120" role="paragraph" xml-lang="en-US"><item type="input">=BINOM.DIST(A1;12;0.5;1)</item> shows the cumulative probabilities for the same series. For example, if A1 = <item type="input">4</item>, the cumulative probability of the series is 0, 1, 2, 3 or 4 times <emph>Heads</emph> (non-exclusive OR).</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873786703" localize="false"><literal>COM.MICROSOFT.BINOM.DIST</literal></paragraph> </section> <section id="binomdotinv"> @@ -339,7 +348,6 @@ <h2 id="hd_id2843228">BINOM.INV</h2> <paragraph id="par_id2846897" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BINOM_INV_MS">Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2856009" role="code" xml-lang="en-US">BINOM.INV(Trials; SP; Alpha)</paragraph> <paragraph id="par_id2847492" role="paragraph" xml-lang="en-US"><emph>Trials</emph> The total number of trials.</paragraph> @@ -348,6 +356,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id285666" role="paragraph" xml-lang="en-US"><item type="input">=BINOM.INV(8;0.6;0.9)</item> returns 7, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986706" localize="false"><literal>COM.MICROSOFT.BINOM.INV</literal></paragraph> </section> <section id="chisqinv"> @@ -373,7 +385,6 @@ <h2 id="hd_id2919200902421451">CHISQ.INV</h2> <paragraph id="par_id2919200902421449" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHISQINV_MS">Returns the inverse of the left-tailed probability of the chi-square distribution.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id1150504" role="code" xml-lang="en-US">CHISQ.INV(Probability; DegreesFreedom)</paragraph> <paragraph id="par_id2919200902475286" role="paragraph" xml-lang="en-US"><emph>Probability</emph> is the probability value for which the inverse of the chi-square distribution is to be calculated.</paragraph> @@ -381,6 +392,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id275666" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.INV(0,5;1)</item> returns 0.4549364231.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986753" localize="false"><literal>COM.MICROSOFT.CHISQ.INV</literal></paragraph> </section> <section id="chiinv"> @@ -416,7 +431,6 @@ <h2 id="hd_id2948835">CHISQ.INV.RT</h2> <paragraph id="par_id2949906" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHIINV_MS">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2950504" role="code" xml-lang="en-US">CHISQ.INV.RT(Number; DegreesFreedom)</paragraph> <paragraph id="par_id2954898" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value of the error probability.</paragraph> @@ -429,6 +443,10 @@ <paragraph id="par_id2949763" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.INV.RT(0.05;5)</item> returns 11.0704976935.</paragraph> <paragraph id="par_id2959142" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.INV.RT(0.02;5)</item> returns 13.388222599.</paragraph> <paragraph id="par_id2958401" role="paragraph" xml-lang="en-US">If the probability of error is 5%, the die is not true. If the probability of error is 2%, there is no reason to believe it is fixed.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873983703" localize="false"><literal>COM.MICROSOFT.CHISQ.INV.RT</literal></paragraph> </section> <section id="chitest"> @@ -449,84 +467,7 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<table id="tbl_id3153233"> - <tablerow> - <tablecell> - </tablecell> - <tablecell> - <paragraph id="par_id3154096" role="paragraph" xml-lang="en-US">Data_B (observed)</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3152948" role="paragraph" xml-lang="en-US">Data_E (expected)</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id3152876" role="paragraph" xml-lang="en-US">1</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3159279" role="paragraph" xml-lang="en-US"><item type="input">195</item></paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3149105" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id3149922" role="paragraph" xml-lang="en-US">2</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3148621" role="paragraph" xml-lang="en-US"><item type="input">151</item></paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3148987" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id3149417" role="paragraph" xml-lang="en-US">3</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3148661" role="paragraph" xml-lang="en-US"><item type="input">148</item></paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3151128" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id3148467" role="paragraph" xml-lang="en-US">4</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3149237" role="paragraph" xml-lang="en-US"><item type="input">189</item></paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3145304" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id3149927" role="paragraph" xml-lang="en-US">5</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3150630" role="paragraph" xml-lang="en-US"><item type="input">183</item></paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3150423" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id3143275" role="paragraph" xml-lang="en-US">6</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3144750" role="paragraph" xml-lang="en-US"><item type="input">154</item></paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id3153947" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> - </tablecell> - </tablerow> -</table> +<embed href="text/scalc/01/04060181.xhp#data_sample"/> <paragraph id="par_id3149481" role="paragraph" xml-lang="en-US"><item type="input">=CHITEST(A1:A6;B1:B6)</item> equals 0.02. This is the probability which suffices the observed data of the theoretical Chi-square distribution.</paragraph> </section> @@ -541,94 +482,97 @@ <h2 id="hd_id2954260">CHISQ.TEST</h2> <paragraph id="par_id2951052" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHITEST_MS">Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</ahelp> CHISQ.TEST returns the chi-squared distribution of the data.</paragraph> <paragraph id="par_id2948925" role="paragraph" xml-lang="en-US">The probability determined by CHISQ.TEST can also be determined with CHISQ.DIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row.</paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2949162" role="code" xml-lang="en-US">CHISQ.TEST(DataB; DataE)</paragraph> <paragraph id="par_id2958421" role="paragraph" xml-lang="en-US"><emph>DataB</emph> is the array of the observations.</paragraph> <paragraph id="par_id2966453" role="paragraph" xml-lang="en-US"><emph>DataE</emph> is the range of the expected values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - +<section id="data_sample"> <table id="tbl_id2953233"> <tablerow> <tablecell> </tablecell> <tablecell> - <paragraph id="par_id2954096" role="paragraph" xml-lang="en-US">Data_B (observed)</paragraph> + <paragraph id="par_id2954096" role="tablehead" xml-lang="en-US">Data_B (observed)</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2952948" role="paragraph" xml-lang="en-US">Data_E (expected)</paragraph> + <paragraph id="par_id2952948" role="tablehead" xml-lang="en-US">Data_E (expected)</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2952876" role="paragraph" xml-lang="en-US">1</paragraph> + <paragraph id="par_id2952876" role="tablehead" localize="false" xml-lang="en-US">1</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2959279" role="paragraph" xml-lang="en-US"><item type="input">195</item></paragraph> + <paragraph id="par_id2959279" role="tablecontent" localize="false" xml-lang="en-US">195</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2949105" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> + <paragraph id="par_id2949105" role="tablecontent" localize="false" xml-lang="en-US">170</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2949922" role="paragraph" xml-lang="en-US">2</paragraph> + <paragraph id="par_id2949922" role="tablehead" localize="false" xml-lang="en-US">2</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2948621" role="paragraph" xml-lang="en-US"><item type="input">151</item></paragraph> + <paragraph id="par_id2948621" role="tablecontent" localize="false" xml-lang="en-US">151</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2948987" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> + <paragraph id="par_id2948987" role="tablecontent" localize="false" xml-lang="en-US">170</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2949417" role="paragraph" xml-lang="en-US">3</paragraph> + <paragraph id="par_id2949417" role="tablehead" localize="false" xml-lang="en-US">3</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2948661" role="paragraph" xml-lang="en-US"><item type="input">148</item></paragraph> + <paragraph id="par_id2948661" role="tablecontent" localize="false" xml-lang="en-US">148</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2951128" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> + <paragraph id="par_id2951128" role="tablecontent" localize="false" xml-lang="en-US">170</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2948467" role="paragraph" xml-lang="en-US">4</paragraph> + <paragraph id="par_id2948467" role="tablehead" localize="false" xml-lang="en-US">4</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2949237" role="paragraph" xml-lang="en-US"><item type="input">189</item></paragraph> + <paragraph id="par_id2949237" role="tablecontent" localize="false" xml-lang="en-US">189</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2945304" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> + <paragraph id="par_id2945304" role="tablecontent" localize="false" xml-lang="en-US">170</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2949927" role="paragraph" xml-lang="en-US">5</paragraph> + <paragraph id="par_id2949927" role="tablehead" localize="false" xml-lang="en-US">5</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2950630" role="paragraph" xml-lang="en-US"><item type="input">183</item></paragraph> + <paragraph id="par_id2950630" role="tablecontent" localize="false" xml-lang="en-US">183</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2950423" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> + <paragraph id="par_id2950423" role="tablecontent" localize="false" xml-lang="en-US">170</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph id="par_id2943275" role="paragraph" xml-lang="en-US">6</paragraph> + <paragraph id="par_id2943275" role="tablehead" localize="false" xml-lang="en-US">6</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2944750" role="paragraph" xml-lang="en-US"><item type="input">154</item></paragraph> + <paragraph id="par_id2944750" role="tablecontent" localize="false" xml-lang="en-US">154</paragraph> </tablecell> <tablecell> - <paragraph id="par_id2953947" role="paragraph" xml-lang="en-US"><item type="input">170</item></paragraph> + <paragraph id="par_id2953947" role="tablecontent" localize="false" xml-lang="en-US">170</paragraph> </tablecell> </tablerow> </table> - +</section> <paragraph id="par_id2949481" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.TEST(A1:A6;B1:B6)</item> equals 0.0209708029. This is the probability which suffices the observed data of the theoretical Chi-square distribution.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873989703" localize="false"><literal>COM.MICROSOFT.CHISQ.TEST</literal></paragraph> </section> <section id="chidist"> @@ -661,7 +605,6 @@ <h2 id="hd_id2848690">CHISQ.DIST</h2> <paragraph id="par_id2856338" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHISQDIST_MS">Returns the probability density function or the cumulative distribution function for the chi-square distribution.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2858439" role="code" xml-lang="en-US">CHISQ.DIST(Number; DegreesFreedom; Cumulative)</paragraph> <paragraph id="par_id2848675" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the chi-square value of the random sample used to determine the error probability.</paragraph> @@ -671,6 +614,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2845774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST(3; 2; 0) </item>equals 0.1115650801, the probability density function with 2 degrees of freedom, at x = 3.</paragraph> <paragraph id="par_id2745774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST(3; 2; 1) </item>equals 0.7768698399, the cumulative chi-square distribution with 2 degrees of freedom, at the value x = 3.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873984703" localize="false"><literal>COM.MICROSOFT.CHISQ.DIST</literal></paragraph> </section> <section id="chisqdotdistdotrt"> @@ -683,7 +630,6 @@ <h2 id="hd_id2948690">CHISQ.DIST.RT</h2> <paragraph id="par_id2956338" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CHIVERT_MS">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHISQ.DIST.RT compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested.</paragraph> <paragraph id="par_id2951316" role="paragraph" xml-lang="en-US">The probability determined by CHISQ.DIST.RT can also be determined by CHITEST.</paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2958439" role="code" xml-lang="en-US">CHISQ.DIST.RT(Number; DegreesFreedom)</paragraph> <paragraph id="par_id2948675" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the chi-square value of the random sample used to determine the error probability.</paragraph> @@ -692,6 +638,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2945774" role="paragraph" xml-lang="en-US"><item type="input">=CHISQ.DIST.RT(13.27; 5)</item> equals 0.0209757694.</paragraph> <paragraph id="par_id2956141" role="paragraph" xml-lang="en-US">If the Chi square value of the random sample is 13.27 and if the experiment has 5 degrees of freedom, then the hypothesis is assured with a probability of error of 2%.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id343640873986703" localize="false"><literal>COM.MICROSOFT.CHISQ.DIST.RT</literal></paragraph> </section> <section id="chisqdist"> @@ -743,7 +693,6 @@ <h2 id="hd_id2950603">EXPON.DIST</h2> <paragraph id="par_id2949563" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EXP_DIST_MS">Returns the exponential distribution.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2950987" role="code" xml-lang="en-US">EXPON.DIST(Number; Lambda; C)</paragraph> <paragraph id="par_id2954663" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value of the function.</paragraph> @@ -752,6 +701,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2950357" role="paragraph" xml-lang="en-US"><item type="input">=EXPON.DIST(3;0.5;1)</item> returns 0.7768698399.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341660873986703" localize="false"><literal>COM.MICROSOFT.EXPON.DIST</literal></paragraph> </section> </sort> diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp index df82688b33..8591243a9f 100644 --- a/source/text/scalc/01/04060182.xhp +++ b/source/text/scalc/01/04060182.xhp @@ -56,7 +56,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_LT" id="bm_id2946113" localize="false"/> <h2 id="hd_id2945388">F.INV</h2> <paragraph xml-lang="en-US" id="par_id2955089" role="paragraph"><ahelp hid="HID_FUNC_F_INV_LT">Returns the inverse of the cumulative F distribution.</ahelp> The F distribution is used for F tests in order to set the relation between two differing data sets.</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_id2953068" role="code">F.INV(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> <paragraph xml-lang="en-US" id="par_id2946866" role="paragraph"><emph>Number</emph> is probability value for which the inverse F distribution is to be calculated.</paragraph> @@ -64,6 +63,10 @@ <paragraph xml-lang="en-US" id="par_id2948607" role="paragraph"><emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2945073" role="paragraph"><item type="input">=F.INV(0.5;5;10)</item> yields 0.9319331609.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873984703" localize="false"><literal>COM.MICROSOFT.F.INV</literal></paragraph> </section> <section id="fdotinvdotrt"> <bookmark xml-lang="en-US" branch="index" id="bm_id2845388"> @@ -74,7 +77,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_RT" id="bm_id2846113" localize="false"/> <h2 id="hd_id2845388">F.INV.RT</h2> <paragraph xml-lang="en-US" id="par_id2855089" role="paragraph"><ahelp hid="HID_FUNC_F_INV_RT">Returns the inverse right tail of the F 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_id2853068" role="code">F.INV.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> <paragraph xml-lang="en-US" id="par_id2846866" role="paragraph"><emph>Number</emph> is probability value for which the inverse F distribution is to be calculated.</paragraph> @@ -82,6 +84,10 @@ <paragraph xml-lang="en-US" id="par_id2848607" role="paragraph"><emph>DegreesFreedom2</emph> is the number of degrees of freedom in the denominator of the F distribution.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2845073" role="paragraph"><item type="input">=F.INV.RT(0.5;5;10)</item> yields 0.9319331609.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341660873986703" localize="false"><literal>COM.MICROSOFT.F.INV.RT</literal></paragraph> </section> <section id="fisher"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150888"><bookmark_value>FISHER function</bookmark_value> @@ -136,13 +142,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_TEST_MS" id="bm_id2959263" localize="false"/> <h2 id="hd_id2951390">F.TEST</h2> <paragraph xml-lang="en-US" id="par_id2950534" role="paragraph"><ahelp hid="HID_FUNC_F_TEST_MS">Returns the result of an F test.</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_id2953024" role="code">F.TEST(Data1; Data2)</paragraph> <paragraph xml-lang="en-US" id="par_id2950032" role="paragraph"><emph>Data1</emph> is the first record array.</paragraph> <paragraph xml-lang="en-US" id="par_id2953018" role="paragraph"><emph>Data2</emph> is the second record array.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2959126" role="paragraph"><item type="input">=F.TEST(A1:A30;B1:B12)</item> calculates whether the two data sets are different in their variance and returns the probability that both sets could have come from the same total population.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640273986703" localize="false"><literal>COM.MICROSOFT.F.TEST</literal></paragraph> </section> <section id="fdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150372"><bookmark_value>FDIST function</bookmark_value> @@ -169,7 +178,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_LT" id="bm_id2949722" localize="false"/> <h2 id="hd_id2950372">F.DIST</h2> <paragraph xml-lang="en-US" id="par_id2952981" role="paragraph"><ahelp hid="HID_FUNC_F_DIST_LT">Calculates the values of the left tail of the F 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_id2945826" role="code">F.DIST(Number; DegreesFreedom1; DegreesFreedom2 [; Cumulative])</paragraph> <paragraph xml-lang="en-US" id="par_id2950461" role="paragraph"><emph>Number</emph> is the value for which the F distribution is to be calculated.</paragraph> @@ -179,6 +187,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2950696" role="paragraph"><item type="input">=F.DIST(0.8;8;12;0)</item> yields 0.7095282499.</paragraph> <paragraph xml-lang="en-US" id="par_id2950697" role="paragraph"><item type="input">=F.DIST(0.8;8;12;1)</item> yields 0.3856603563.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986707" localize="false"><literal>COM.MICROSOFT.F.DIST</literal></paragraph> </section> <section id="fdotdistdotrt"> <bookmark xml-lang="en-US" branch="index" id="bm_id2850372"> @@ -187,7 +199,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_RT" id="bm_id289722" localize="false"/> <h2 id="hd_id280372">F.DIST.RT</h2> <paragraph xml-lang="en-US" id="par_id2852981" role="paragraph"><ahelp hid="HID_FUNC_F_DIST_RT">Calculates the values of the right tail of the F 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_id2845826" role="code">F.DIST.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph> <paragraph xml-lang="en-US" id="par_id2850461" role="paragraph"><emph>Number</emph> is the value for which the F distribution is to be calculated.</paragraph> @@ -195,6 +206,10 @@ <paragraph xml-lang="en-US" id="par_id2846877" role="paragraph"><emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2850696" role="paragraph"><item type="input">=F.DIST.RT(0.8;8;12)</item> yields 0.6143396437.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986763" localize="false"><literal>COM.MICROSOFT.F.DIST.RT</literal></paragraph> </section> <section id="gamma"> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMA" id="bm_id0119200903221254" localize="false"/> @@ -232,7 +247,6 @@ <h2 id="hd_id2914841">GAMMA.INV</h2> <paragraph xml-lang="en-US" id="par_id2913932" role="paragraph"><ahelp hid="HID_FUNC_GAMMAINV_MS">Returns the inverse of the Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to search for variables with different distribution.</paragraph> <paragraph id="par_id291422405814" role="paragraph" xml-lang="en-US">This function is identical to GAMMAINV and was introduced for interoperability with other office suites.</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_id2915828" role="code">GAMMA.INV(Number; Alpha; Beta)</paragraph> <paragraph xml-lang="en-US" id="par_id2915138" role="paragraph"> @@ -244,6 +258,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2913331" role="paragraph"> <item type="input">=GAMMA.INV(0.8;1;1)</item> yields 1.61.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341630873986703" localize="false"><literal>COM.MICROSOFT.GAMMA.INV</literal></paragraph> </section> <section id="gammaln"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154806"><bookmark_value>GAMMALN function</bookmark_value> @@ -267,7 +285,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMALN_MS" id="bm_id2919511" localize="false"/> <h2 id="hd_id2914806">GAMMALN.PRECISE</h2> <paragraph xml-lang="en-US" id="par_id2918572" role="paragraph"><ahelp hid="HID_FUNC_GAMMALN_MS">Returns the natural logarithm of the Gamma function: G(x).</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_id2913112" role="code">GAMMALN.PRECISE(Number)</paragraph> <paragraph xml-lang="en-US" id="par_id2914502" role="paragraph"> @@ -275,6 +292,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2913730" role="paragraph"> <item type="input">=GAMMALN.PRECISE(2)</item> yields 0.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id541640873986703" localize="false"><literal>COM.MICROSOFT.GAMMALN.PRECISE</literal></paragraph> </section> <section id="gammadist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150132"><bookmark_value>GAMMADIST function</bookmark_value> @@ -306,7 +327,6 @@ <paragraph id="par_id2406201422414690" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GAMMADIST_MS">Returns the values of a Gamma distribution.</ahelp></paragraph> <paragraph id="par_id24061422414690" role="paragraph" xml-lang="en-US">The inverse function is GAMMAINV or GAMMA.INV.</paragraph> <paragraph id="par_id2406201422405814" role="paragraph" xml-lang="en-US">This function is similar to GAMMADIST and was introduced for interoperability with other office suites.</paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id240620142238475" role="code" xml-lang="en-US">GAMMA.DIST(Number; Alpha; Beta; Cumulative)</paragraph> <paragraph id="par_id2406201422385134" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph> @@ -315,6 +335,10 @@ <paragraph id="par_id2406201422391058" role="paragraph" xml-lang="en-US"><emph>Cumulative</emph> = 0 or False calculates the probability density function; <emph>Cumulative</emph> = 1, True, or any other value calculates the cumulative distribution function.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2406201422392251" role="paragraph" xml-lang="en-US"><item type="input">=GAMMA.DIST(2;1;1;1)</item> yields 0.86.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640273086703" localize="false"><literal>COM.MICROSOFT.GAMMA.DIST</literal></paragraph> </section> <section id="gauss"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150272"><bookmark_value>GAUSS function</bookmark_value> @@ -390,7 +414,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_Z_TEST_MS" id="bm_id2947569" localize="false"/> <h2 id="hd_id2953216">Z.TEST</h2> <paragraph xml-lang="en-US" id="par_id2950758" role="paragraph"><ahelp hid="HID_FUNC_Z_TEST_MS">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</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_id2953274" role="code">Z.TEST(Data; mu [; Sigma])</paragraph> <paragraph xml-lang="en-US" id="par_id2956109" role="paragraph"><emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph> @@ -398,6 +421,10 @@ <paragraph xml-lang="en-US" id="par_id2954740" role="paragraph"><emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2948770" role="paragraph"><item type="input">=Z.TEST(A2:A20; 9; 2)</item> returns the result of a z-test on a sample A2:A20 drawn from a population with known mean 9 and known standard deviation 2.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986700" localize="false"><literal>COM.MICROSOFT.Z.TEST</literal></paragraph> </section> <section id="harmean"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value> @@ -446,7 +473,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYP_GEOM_DIST_MS" id="bm_id2953910" localize="false"/> <h2 id="hd_id2952801">HYPGEOM.DIST</h2> <paragraph xml-lang="en-US" id="par_id2959341" role="paragraph"><ahelp hid="HID_FUNC_HYP_GEOM_DIST_MS">Returns the hypergeometric 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_id2955388" role="code">HYPGEOM.DIST(X; NSample; Successes; NPopulation; Cumulative)</paragraph> <paragraph xml-lang="en-US" id="par_id2954933" role="paragraph"><emph>X</emph> is the number of results achieved in the random sample.</paragraph> @@ -457,6 +483,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2954904" role="paragraph"><item type="input">=HYPGEOM.DIST(2;2;90;100;0)</item> yields 0.8090909091. If 90 out of 100 pieces of buttered toast fall from the table and hit the floor with the buttered side first, then if 2 pieces of buttered toast are dropped from the table, the probability is 81%, that both will strike buttered side first.</paragraph> <paragraph xml-lang="en-US" id="par_id2954905" role="paragraph"><item type="input">=HYPGEOM.DIST(2;2;90;100;1)</item> yields 1.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986704" localize="false"><literal>COM.MICROSOFT.HYPGEOM.DIST</literal></paragraph> </section> </sort> <section id="relatedtopics"> diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index a4e5524bd8..5a13443753 100644 --- a/source/text/scalc/01/04060183.xhp +++ b/source/text/scalc/01/04060183.xhp @@ -19,7 +19,6 @@ * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - <meta> <topic id="textscalc0104060183xml" indexer="include"> <title id="tit" xml-lang="en-US">Statistical Functions Part Three</title> @@ -87,7 +86,6 @@ <h2 id="hd_id2953559">CONFIDENCE.T</h2> <paragraph role="paragraph" id="par_id2953814" xml-lang="en-US"> <ahelp hid="HID_FUNC_CONFIDENCE_T">Returns the (1-alpha) confidence interval for a Student's t distribution.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id2947501" xml-lang="en-US">CONFIDENCE.T(Alpha; StDev; Size)</paragraph> <paragraph role="paragraph" id="par_id2949872" xml-lang="en-US"> @@ -99,6 +97,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2953335" xml-lang="en-US"> <item type="input">=CONFIDENCE.T(0.05;1.5;100)</item> gives 0.2976325427.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640973986703" localize="false"><literal>COM.MICROSOFT.CONFIDENCE.T</literal></paragraph> </section> <section id="confidencedotnorm"> <bookmark xml-lang="en-US" branch="index" id="bm_id2853559"><bookmark_value>CONFIDENCE.NORM function</bookmark_value> @@ -107,7 +109,6 @@ <h2 id="hd_id2853559">CONFIDENCE.NORM</h2> <paragraph role="paragraph" id="par_id2853814" xml-lang="en-US"> <ahelp hid="HID_FUNC_CONFIDENCE_N">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id2847501" xml-lang="en-US">CONFIDENCE.NORM(Alpha; StDev; Size)</paragraph> <paragraph role="paragraph" id="par_id2849872" xml-lang="en-US"> @@ -119,6 +120,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2853335" xml-lang="en-US"> <item type="input">=CONFIDENCE.NORM(0.05;1.5;100)</item> gives 0.2939945977.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341340873986703" localize="false"><literal>COM.MICROSOFT.CONFIDENCE.NORM</literal></paragraph> </section> <section id="correl"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148746"><bookmark_value>CORREL function</bookmark_value> @@ -161,13 +166,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_P" id="bm_id2952983" localize="false"/> <h2 id="hd_id2950652">COVARIANCE.P</h2> <paragraph role="paragraph" id="par_id2946875" xml-lang="en-US"><ahelp hid="HID_FUNC_COVARIANCE_P">Returns the covariance of the product of paired deviations, for 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 role="code" id="par_id2950740" xml-lang="en-US">COVARIANCE.P(Data1; Data2)</paragraph> <paragraph role="paragraph" id="par_id2945827" xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph> <paragraph role="paragraph" id="par_id2950465" xml-lang="en-US"><emph>Data2</emph> is the second data set.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2944748" xml-lang="en-US"><item type="input">=COVARIANCE.P(A1:A30;B1:B30)</item></paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id641640873986703" localize="false"><literal>COM.MICROSOFT.COVARIANCE.P</literal></paragraph> </section> <section id="covariancedots"> <bookmark xml-lang="en-US" branch="index" id="bm_id280652"> @@ -176,13 +184,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_S" id="bm_id2852983" localize="false"/> <h2 id="hd_id2850652">COVARIANCE.S</h2> <paragraph role="paragraph" id="par_id2846875" xml-lang="en-US"><ahelp hid="HID_FUNC_COVARIANCE_S">Returns the covariance of the product of paired deviations, for a 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 role="code" id="par_id2850740" xml-lang="en-US">COVARIANCE.S(Data1; Data2)</paragraph> <paragraph role="paragraph" id="par_id2845827" xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph> <paragraph role="paragraph" id="par_id2850465" xml-lang="en-US"><emph>Data2</emph> is the second data set.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2844748" xml-lang="en-US"><item type="input">=COVARIANCE.S(A1:A30;B1:B30)</item></paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341670873986703" localize="false"><literal>COM.MICROSOFT.COVARIANCE.S</literal></paragraph> </section> <section id="critbinom"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147472"><bookmark_value>CRITBINOM function</bookmark_value> @@ -245,7 +256,6 @@ <h2 id="hd_id2901928">LOGNORM.INV</h2> <paragraph role="paragraph" id="par_id2901297" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGINV_MS">Returns the inverse of the lognormal distribution.</ahelp></paragraph> <paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This function is identical to LOGINV and was introduced for interoperability with other office suites.</paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number [; Mean [; StDev]])</paragraph> <paragraph role="paragraph" id="par_id2901390" xml-lang="en-US"> @@ -257,6 +267,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2901623" xml-lang="en-US"> <item type="input">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873906703" localize="false"><literal>COM.MICROSOFT.LOGNORM.INV</literal></paragraph> </section> <section id="lognormdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3158417"><bookmark_value>LOGNORMDIST function</bookmark_value> @@ -286,7 +300,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMDIST_MS" id="bm_id2901366" localize="false"/> <h2 id="hd_id2908417">LOGNORM.DIST</h2> <paragraph role="paragraph" id="par_id2904953" xml-lang="en-US"><ahelp hid="HID_FUNC_LOGNORMDIST_MS">Returns the values of a lognormal distribution.</ahelp></paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id2900686" xml-lang="en-US">LOGNORM.DIST(Number; Mean; StDev; Cumulative)</paragraph> <paragraph role="paragraph" id="par_id2904871" xml-lang="en-US"> @@ -300,6 +313,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2909778" xml-lang="en-US"> <item type="input">=LOGNORM.DIST(0.1;0;1;1)</item> returns 0.0106510993.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341670873986703" localize="false"><literal>COM.MICROSOFT.LOGNORM.DIST</literal></paragraph> </section> </sort> <section id="relatedtopics"> diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index e73b6c04b2..c3fb40e191 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -182,13 +182,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MS" id="bm_id2949253" localize="false"/> <h2 id="hd_id2953933">MODE.SNGL</h2> <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(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> <embed href="text/scalc/01/ful_func.xhp#number255"/> <warning id="par_id2963792">If the data set contains no duplicate data points, MODE.SNGL returns the #VALUE! error value.</warning> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953733" role="paragraph"><item type="input">=MODE.SNGL(A1:A50)</item></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341540873986703" localize="false"><literal>COM.MICROSOFT.MODE.SNGL</literal></paragraph> </section> <section id="modedotmult"> <bookmark xml-lang="en-US" branch="index" id="bm_id2853933"><bookmark_value>MODE.MULT function</bookmark_value> @@ -197,16 +200,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MULTI" id="bm_id2849253" localize="false"/> <h2 id="hd_id2853933">MODE.MULT</h2> <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(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> <embed href="text/scalc/01/ful_func.xhp#number255"/> - - <warning id="par_id2863792">As the MODE.MULT function returns an array of values, it must be entered as an array formula. If the function is not entered as an array formula, only the first mode is returned, which is the same as using the MODE.SNGL function.</warning> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2853733" role="paragraph"><item type="input">=MODE.MULT(A1:A50)</item></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640875986703" localize="false"><literal>COM.MICROSOFT.MODE.MULT</literal></paragraph> </section> <section id="negbinomdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149879"><bookmark_value>NEGBINOMDIST function</bookmark_value> @@ -231,7 +234,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMDIST_MS" id="bm_id2959135" localize="false"/> <h2 id="hd_id2949879">NEGBINOM.DIST</h2> <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> @@ -241,6 +243,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2948770" role="paragraph"><item type="input">=NEGBINOM.DIST(1;1;0.5;0)</item> returns 0.25.</paragraph> <paragraph xml-lang="en-US" id="par_id2948771" role="paragraph"><item type="input">=NEGBINOM.DIST(1;1;0.5;1)</item> returns 0.75.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873985703" localize="false"><literal>COM.MICROSOFT.NEGBINOM.DIST</literal></paragraph> </section> <section id="norminv"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155516"><bookmark_value>NORMINV function</bookmark_value> @@ -265,7 +271,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV_MS" id="bm_id2949396" localize="false"/> <h2 id="hd_id2955516">NORM.INV</h2> <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> @@ -274,6 +279,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2953921" role="paragraph"> <item type="input">=NORM.INV(0.9;63;5)</item> returns 69.4077578277. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41g grams.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873966703" localize="false"><literal>COM.MICROSOFT.NORM.INV</literal></paragraph> </section> <section id="normdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153722"><bookmark_value>NORMDIST function</bookmark_value> @@ -301,7 +310,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMDIST_MS" id="bm_id2917484" localize="false"/> <h2 id="hd_id2913722">NORM.DIST</h2> <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> @@ -313,6 +321,10 @@ <item type="input">=NORM.DIST(70;63;5;0)</item> returns 0.029945493.</paragraph> <paragraph xml-lang="en-US" id="par_id2919448" role="paragraph"> <item type="input">=NORM.DIST(70;63;5;1)</item> returns 0.9192433408.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640373986703" localize="false"><literal>COM.MICROSOFT.NORM.DIST</literal></paragraph> </section> <section id="pearson"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152934"><bookmark_value>PEARSON function</bookmark_value> @@ -372,7 +384,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POISSON_DIST_MS" id="bm_id2956011" localize="false"/> <h2 id="hd_id2953985">POISSON.DIST</h2> <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 ; Cumulative)</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> @@ -380,6 +391,10 @@ <paragraph xml-lang="en-US" id="par_id2949200" role="paragraph"><emph>Cumulative</emph> = 0 or False to calculate the probability mass function; <emph>Cumulative</emph> = 1, True, or any other non-zero value to calculate the cumulative distribution function.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2950113" role="paragraph"><item type="input">=POISSON.DIST(60;50;1)</item> returns 0.9278398202.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341630873986703" localize="false"><literal>COM.MICROSOFT.POISSON.DIST</literal></paragraph> </section> <section id="percentile"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153100"><bookmark_value>PERCENTILE function</bookmark_value> @@ -404,13 +419,16 @@ <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> <warning id="par_id2754940">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.</warning> <note id="par_id2653976">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.</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_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> <paragraph xml-lang="en-US" id="par_id2854212" role="paragraph"><emph>Alpha</emph> represents the percentage of the scale between 0 and 1.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2859147" role="paragraph"><item type="input">=PERCENTILE.EXC(A1:A50;10%)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id342640873986703" localize="false"><literal>COM.MICROSOFT.PERCENTILE.EXC</literal></paragraph> </section> <section id="percentileinc"> <bookmark xml-lang="en-US" branch="index" id="bm_id2953100"><bookmark_value>PERCENTILE.INC function</bookmark_value> @@ -419,13 +437,16 @@ <h2 id="hd_id2953100">PERCENTILE.INC</h2> <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> <note id="par_id2753976">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.</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_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> <paragraph xml-lang="en-US" id="par_id2954212" role="paragraph"><emph>Alpha</emph> represents the percentage of the scale between 0 and 1.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2959147" role="paragraph"><item type="input">=PERCENTILE.INC(A1:A50;0.1)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341340873986703" localize="false"><literal>COM.MICROSOFT.PERCENTILE.INC</literal></paragraph> </section> <section id="percentrank"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148807"><bookmark_value>PERCENTRANK function</bookmark_value> @@ -449,7 +470,6 @@ <h2 id="hd_id2848807">PERCENTRANK.EXC</h2> <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> <note id="par_id2553976">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.</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_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> @@ -457,6 +477,10 @@ <paragraph xml-lang="en-US" id="par_id2748475" role="paragraph"><emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2849163" role="paragraph"><item type="input">=PERCENTRANK.EXC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640878986703" localize="false"><literal>COM.MICROSOFT.PERCENTRANK.EXC</literal></paragraph> </section> <section id="percentrankinc"> <bookmark xml-lang="en-US" branch="index" id="bm_id2948807"><bookmark_value>PERCENTRANK.INC function</bookmark_value></bookmark> @@ -464,7 +488,6 @@ <h2 id="hd_id2948807">PERCENTRANK.INC</h2> <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> <note id="par_id2453976">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.</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_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 +495,10 @@ <paragraph xml-lang="en-US" id="par_id2648475" role="paragraph"><emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2949163" role="paragraph"><item type="input">=PERCENTRANK.INC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873086703" localize="false"><literal>COM.MICROSOFT.PERCENTRANK.INC</literal></paragraph> </section> <section id="quartile"> <bookmark xml-lang="en-US" branch="index" id="bm_id3166442"><bookmark_value>QUARTILE function</bookmark_value> @@ -495,7 +522,6 @@ <h2 id="hd_id2866442">QUARTILE.EXC</h2> <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> <note id="par_id2353976">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.</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_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> @@ -503,6 +529,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2859276" role="paragraph"> <item type="input">=QUARTILE.EXC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986700" localize="false"><literal>COM.MICROSOFT.QUARTILE.EXC</literal></paragraph> </section> <section id="quartileinc"> <bookmark xml-lang="en-US" branch="index" id="bm_id2966442"><bookmark_value>QUARTILE.INC function</bookmark_value> @@ -511,7 +541,6 @@ <h2 id="hd_id2966442">QUARTILE.INC</h2> <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> <note id="par_id2253976">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.</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_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> @@ -519,6 +548,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id2959276" role="paragraph"> <item type="input">=QUARTILE.INC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986707" localize="false"><literal>COM.MICROSOFT.QUARTILE.INC</literal></paragraph> </section> </sort> <section id="relatedtopics"> diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 412625f741..9223f4a2ba 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -61,7 +61,6 @@ <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> <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> <paragraph xml-lang="en-US" id="par_id2954543" role="paragraph"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph> @@ -71,6 +70,10 @@ <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> <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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873886703" localize="false"><literal>COM.MICROSOFT.RANK.AVG</literal></paragraph> </section> <section id="rankeq"> <bookmark xml-lang="en-US" branch="index" id="bm_id2855071"> @@ -81,7 +84,6 @@ <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> <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> <paragraph xml-lang="en-US" id="par_id2854543" role="paragraph"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph> @@ -91,6 +93,10 @@ <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> <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> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341040873966703" localize="false"><literal>COM.MICROSOFT.RANK.EQ</literal></paragraph> </section> <section id="skew"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value> @@ -150,6 +156,9 @@ <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873980703" localize="false"><literal>COM.MICROSOFT.FORECAST.LINEAR</literal></paragraph> </section> <section id="stdev"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149143"><bookmark_value>STDEV function</bookmark_value> @@ -205,7 +214,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_P_MS" id="bm_id2946139" localize="false"/> <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"/> <paragraph xml-lang="en-US" id="par_id2954392" role="code">STDEV.P(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> @@ -213,8 +221,9 @@ <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> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> - <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.STDEV.P</literal></paragraph> + <paragraph role="paragraph" id="par_id341640873986700" localize="false"><literal>COM.MICROSOFT.STDEV.P</literal></paragraph> </section> <section id="stdevdots"> <bookmark xml-lang="en-US" branch="index" id="bm_id2849734"> @@ -224,7 +233,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_S" id="bm_id2846139" localize="false"/> <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"/> <paragraph xml-lang="en-US" id="par_id2854392" role="code">STDEV.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> @@ -232,6 +240,10 @@ <paragraph id="par_id671585163972431" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id301640873986703" localize="false"><literal>COM.MICROSOFT.STDEV.S</literal></paragraph> </section> <section id="stdevpa"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154522"><bookmark_value>STDEVPA function</bookmark_value> @@ -288,7 +300,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMINV_MS" id="bm_id2948389" localize="false"/> <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"/> <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"> @@ -296,6 +307,10 @@ <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341000873986703" localize="false"><literal>COM.MICROSOFT.NORM.S.INV</literal></paragraph> </section> <section id="normsdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147538"><bookmark_value>NORMSDIST function</bookmark_value> @@ -320,7 +335,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMDIST_MS" id="bm_id2945269" localize="false"/> <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"/> <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"> @@ -332,6 +346,10 @@ <item type="input">=NORM.S.DIST(1;0)</item> returns 0.2419707245.</paragraph> <paragraph xml-lang="en-US" id="par_id2955985" role="paragraph"> <item type="input">=NORM.S.DIST(1;1)</item> returns 0.8413447461. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873980003" localize="false"><literal>COM.MICROSOFT.NORM.S.DIST</literal></paragraph> </section> <section id="slope"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value> @@ -409,13 +427,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_MS" id="bm_id2953155" localize="false"/> <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"/> <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> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341000873986703" localize="false"><literal>COM.MICROSOFT.T.INV</literal></paragraph> </section> <section id="tdotinvdot2t"> <bookmark xml-lang="en-US" branch="index" id="bm_id2849579"> @@ -425,13 +446,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_2T" id="bm_id2853155" localize="false"/> <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"/> <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> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986003" localize="false"><literal>COM.MICROSOFT.T.INV.2T</literal></paragraph> </section> <section id="ttest"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value> @@ -461,7 +485,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST_MS" id="bm_id2953981" localize="false"/> <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"/> <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> @@ -470,6 +493,10 @@ <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> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640844986703" localize="false"><literal>COM.MICROSOFT.T.TEST</literal></paragraph> </section> <section id="tdist"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154930"><bookmark_value>TDIST function</bookmark_value> @@ -499,7 +526,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_MS" id="bm_id2953095" localize="false"/> <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"/> <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> @@ -507,6 +533,10 @@ <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> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341330873986703" localize="false"><literal>COM.MICROSOFT.T.DIST</literal></paragraph> </section> <section id="tdotdistdot2t"> <bookmark xml-lang="en-US" branch="index" id="bm_id2854930"> @@ -516,13 +546,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_2T" id="bm_id2853095" localize="false"/> <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"/> <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> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341655873986703" localize="false"><literal>COM.MICROSOFT.T.DIST.2T</literal></paragraph> </section> <section id="tdotdistdotrt"> <bookmark xml-lang="en-US" branch="index" id="bm_id274930"> @@ -532,13 +565,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_RT" id="bm_id273095" localize="false"/> <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"/> <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> <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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873911703" localize="false"><literal>COM.MICROSOFT.T.DIST.RT</literal></paragraph> </section> <section id="var"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153828"><bookmark_value>VAR function</bookmark_value> @@ -566,13 +602,16 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_S" id="bm_id2954898" localize="false"/> <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"/> <paragraph xml-lang="en-US" id="par_id2953054" role="code">VAR.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> <embed href="text/scalc/01/ful_func.xhp#number255"/> <paragraph id="par_id891585215590756" role="paragraph" xml-lang="en-US">The parameters should specify at least two values.</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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id111640873986703" localize="false"><literal>COM.MICROSOFT.VAR.S</literal></paragraph> </section> <section id="vara"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151045"><bookmark_value>VARA function</bookmark_value> @@ -611,12 +650,15 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_P_MS" id="bm_id2952359" localize="false"/> <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"/> <paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(<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_id2953385" role="paragraph"><item type="input">=VAR.P(A1:A50)</item></paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873933703" localize="false"><literal>COM.MICROSOFT.VAR.P</literal></paragraph> </section> <section id="varpa"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value> @@ -722,7 +764,6 @@ <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> <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> @@ -731,7 +772,11 @@ <paragraph xml-lang="en-US" id="par_id2954825" role="paragraph"><emph>C</emph> indicates the type of function.</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> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> <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> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873977703" localize="false"><literal>COM.MICROSOFT.WEIBULL.DIST</literal></paragraph> </section> </sort> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp index 9e899b4d85..c914b00739 100644 --- a/source/text/scalc/01/func_aggregate.xhp +++ b/source/text/scalc/01/func_aggregate.xhp @@ -20,13 +20,11 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id126123001625791"> <bookmark_value>AGGREGATE function</bookmark_value> </bookmark> -<paragraph id="hd_id3154073" role="heading" level="1" xml-lang="en-US"><variable id="aggregate_head"><link href="text/scalc/01/func_aggregate.xhp">AGGREGATE</link></variable> function</paragraph> +<h1 id="hd_id3154073"><variable id="aggregate_head"><link href="text/scalc/01/func_aggregate.xhp">AGGREGATE</link></variable> function</h1> <paragraph id="par_id2209201514174373" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="aggregate_des">This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation.</variable></ahelp></paragraph> </section> -<paragraph id="par_id2209201514174453" role="note" xml-lang="en-US">AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row. </paragraph> -<embed href="text/scalc/00/avail_release.xhp#4.4"/> +<note id="par_id2209201514174453">AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row. </note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph id="par_id200801176228491" role="code" xml-lang="en-US">AGGREGATE(Function; Option; Number 1[; Number 2][; ... ;[Number 253]])</paragraph> <paragraph id="par_id2309201516102726" role="paragraph" xml-lang="en-US">or</paragraph> <paragraph id="par_id30181907128680" role="code" xml-lang="en-US">AGGREGATE(Function; Option; Array[; k])</paragraph> @@ -276,7 +274,7 @@ <paragraph id="par_id220402843321947" role="paragraph" xml-lang="en-US"><emph>Number1</emph> – required argument. The first numeric argument (if the range is set by a list of values inside the function) or a reference to a cell that contains it. </paragraph> <paragraph id="par_id2309201514193338" role="paragraph" xml-lang="en-US"><emph>Number2, 3, ...</emph> – optional. A numeric argument or a reference to a cell (up to 253 arguments), for which you need the aggregate value.</paragraph> <paragraph id="par_id99381371214702" role="paragraph" xml-lang="en-US"><emph>Array</emph> – required argument. The array can be specified by the boundaries of the range, the name of the named range or the column label.</paragraph> -<paragraph id="par_id2309201515555812" role="note" xml-lang="en-US">For using column labels “Automatically find columns and rows labels” function needs to be enabled.</paragraph> +<note id="par_id2309201515555812">For using column labels “Automatically find columns and rows labels” function needs to be enabled.</note> <paragraph id="par_id2209201514174370" role="paragraph" xml-lang="en-US"><emph>k</emph> – required argument for the following functions: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. It is a numeric argument, which must correspond to the second argument of these functions.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> @@ -430,7 +428,10 @@ <paragraph id="par_id2309201520180167" role="paragraph" xml-lang="en-US"><item type="input">=AGGREGATE(13;3;Sheet1.B2:B9:Sheet3.B2:B9)</item><br/>The function returns mode of the values of second columns through sheets 1:3 (that have the same data) = 8.</paragraph> <paragraph id="par_id2309201520395365" role="paragraph" xml-lang="en-US">You can use reference to a cell or a range for every argument in the formula. The following example shows how it works. Besides, it shows that you can use column labels to specify an array.</paragraph> <paragraph id="par_id2309201520395380" role="paragraph" xml-lang="en-US"><item type="input">=AGGREGATE(E3;E5;'ColumnOne')</item><br/>If E3 = 13 and E5 = 5, the function returns mode of the first column = 10.</paragraph> - +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.4"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.AGGREGATE</literal></paragraph> <section id="relatedtopics"> <paragraph id="par_id241712879431120" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060184.xhp#average">AVERAGE</link>, <link href="text/scalc/01/04060181.xhp#count">COUNT</link>, <link href="text/scalc/01/04060181.xhp#counta">COUNTA</link>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link>, <link href="text/scalc/01/04060106.xhp#Section26">PRODUCT</link>, <link href="text/scalc/01/04060185.xhp#stdevdots">STDEV.S</link>, <link href="text/scalc/01/04060185.xhp#stdevdotp">STDEV.P</link>, <link href="text/scalc/01/04060106.xhp#Section16">SUM</link>, <link href="text/scalc/01/04060185.xhp#vardots">VAR.S</link>, <link href="text/scalc/01/04060185.xhp#vardotp">VAR.P</link>, <link href="text/scalc/01/04060184.xhp#median">MEDIAN</link>, <link href="text/scalc/01/04060184.xhp#modedotsngl">MODE.SNGL</link>, <link href="text/scalc/01/04060183.xhp#large">LARGE</link>, <link href="text/scalc/01/04060183.xhp#small">SMALL</link>, <link href="text/scalc/01/04060184.xhp#percentileinc">PERCENTILE.INC</link> , <link href="text/scalc/01/04060184.xhp#quartileinc">QUARTILE.INC</link>, <link href="text/scalc/01/04060184.xhp#percentileexc">PERCENTILE.EXC</link>, <link href="text/scalc/01/04060184.xhp#quartileexc">QUARTILE.EXC</link></paragraph> <paragraph id="par_id125062615028497" role="paragraph" xml-lang="en-US"><link href="text/shared/optionen/01060500.xhp#hd_id3156199">Automatically find column and row labels</link></paragraph> diff --git a/source/text/scalc/01/func_ceiling.xhp b/source/text/scalc/01/func_ceiling.xhp index 6eecc5b92a..deb8eca555 100644 --- a/source/text/scalc/01/func_ceiling.xhp +++ b/source/text/scalc/01/func_ceiling.xhp @@ -54,7 +54,6 @@ <paragraph id="par_id2953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number up to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id151586642494759">For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.</paragraph> <note id="par_id631586642933797">This function calculates identical results to the <link href="#Section312" name="isoceiling">ISO.CEILING</link> function.</note> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2953454" role="code" xml-lang="en-US">CEILING.PRECISE(Number [; Significance])</paragraph> <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/> @@ -62,6 +61,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id201586213398634"><input>=CEILING.PRECISE(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id651586213406243"><input>=CEILING.PRECISE(-45.67; 2)</input> returns -44.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640373986703" localize="false"><literal>COM.MICROSOFT.CEILING.PRECISE</literal></paragraph> <comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> </section> @@ -73,7 +76,6 @@ <h2 id="hd_id91516997330445"><variable id="CEILING.MATHh1"><link href="text/scalc/01/func_ceiling.xhp#ceilingmath" name="CEILING.MATH">CEILING.MATH</link></variable></h2> <paragraph role="paragraph" id="par_id81516997342088" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MATH">Rounds a number to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id911586642319078">For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored.</paragraph> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <warning id="par_id291516998575663">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id841516997669932" xml-lang="en-US">CEILING.MATH(Number [; Significance [; Mode]])</paragraph> @@ -86,6 +88,10 @@ <paragraph role="paragraph" id="par_id641586208600665"><input>=CEILING.MATH(-1.234)</input> returns -1.</paragraph> <paragraph role="paragraph" id="par_id151586208604536"><input>=CEILING.MATH(-45.67; -2; 0)</input> returns -44.</paragraph> <paragraph role="paragraph" id="par_id971586208611345"><input>=CEILING.MATH(-45.67; +2; 1)</input> returns -46.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341646873986703" localize="false"><literal>COM.MICROSOFT.CEILING.MATH</literal></paragraph> </section> <section id="ceilingxcl"> <bookmark xml-lang="en-US" branch="index" id="bm_id921516998608939"> @@ -95,7 +101,6 @@ <h2 id="hd_id411516998838823"><variable id="CEILING.XCLh1"><link href="text/scalc/01/func_ceiling.xhp#ceilingxcl" name="CEILING.XCL">CEILING.XCL</link></variable></h2> <paragraph role="paragraph" id="par_id811516998845826" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id361586213828675">For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from zero). The function returns an error if the number is positive and the significance value is negative.</paragraph> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <warning id="par_id881586213934118">This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function.</warning> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id251516998856873" xml-lang="en-US">CEILING.XCL(Number; Significance)</paragraph> @@ -105,6 +110,10 @@ <paragraph role="paragraph" id="par_id421586214128242"><input>=CEILING.XCL(3.45,2)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id651586214132234"><input>=CEILING.XCL(-45.67; 2)</input> returns -44.</paragraph> <paragraph role="paragraph" id="par_id811586214136666"><input>=CEILING.XCL(-45.67; -2)</input> returns -46.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873786703" localize="false"><literal>COM.MICROSOFT.CEILING</literal></paragraph> </section> <section id="isoceiling"> <bookmark xml-lang="en-US" branch="index" id="bm_id8952518"> @@ -118,7 +127,6 @@ <paragraph id="par_id8953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_ISO">Rounds a number up to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id101586214229587">For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.</paragraph> <note id="par_id821586214265060">This function calculates identical results to the <link href="#Section311" name="ceilingprecise">CEILING.PRECISE</link> function.</note> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id8953454" role="code" xml-lang="en-US">ISO.CEILING(Number [; Significance])</paragraph> <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/> @@ -126,6 +134,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id801586214431463"><input>=ISO.CEILING(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id181586214438808"><input>=ISO.CEILING(-45.67; 2)</input> returns -44.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873989703" localize="false"><literal>COM.MICROSOFT.ISO.CEILING</literal></paragraph> <comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> </section> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_concat.xhp b/source/text/scalc/01/func_concat.xhp index d2beddb891..5063ac92a2 100644 --- a/source/text/scalc/01/func_concat.xhp +++ b/source/text/scalc/01/func_concat.xhp @@ -26,12 +26,15 @@ </section> <paragraph role="paragraph" id="par_id701556226865876">CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M.</paragraph> <paragraph role="paragraph" id="par_id461556226873963">When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate.</paragraph> - <embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id911556226813412">CONCAT( <embedvar href="text/scalc/01/ful_func.xhp#string255_1" markup="keep"/> )</paragraph> <embed href="text/scalc/01/ful_func.xhp#string255"/> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id531556227248228"><input>=CONCAT("Hello ", A1:C3)</input> concatenates the string "Hello" with all strings in range <literal>A1:C3</literal>.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.CONCAT</literal></paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/func_textjoin.xhp#textjoinfunct"/> <paragraph role="paragraph" id="par_id781556244709752"><link href="text/scalc/01/04060110.xhp#concatenate" name="concatenate">CONCATENATE</link></paragraph> diff --git a/source/text/scalc/01/func_floor.xhp b/source/text/scalc/01/func_floor.xhp index 922bad3359..044fee3e2b 100644 --- a/source/text/scalc/01/func_floor.xhp +++ b/source/text/scalc/01/func_floor.xhp @@ -54,7 +54,6 @@ <h2 id="hd_id1001586287279297"><variable id="FLOOR.MATHh1"><link href="text/scalc/01/func_floor.xhp#floormath" name="FLOOR.MATH">FLOOR.MATH</link></variable></h2> <paragraph role="paragraph" id="par_id721586287302689">Rounds a number to the nearest multiple of a significance value.</paragraph> <paragraph role="paragraph" id="par_id311586287323417">For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored.</paragraph> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <warning id="par_id851586287535879">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id161586287421523">FLOOR.MATH(Number[; Significance[; Mode]])</paragraph> @@ -67,6 +66,10 @@ <paragraph role="paragraph" id="par_id981586287632392"><input>=FLOOR.MATH(-1.234)</input> returns -2.</paragraph> <paragraph role="paragraph" id="par_id631586287637256"><input>=FLOOR.MATH(-45.67,-2, 0)</input> returns -46.</paragraph> <paragraph role="paragraph" id="par_id371586287641888"><input>=FLOOR.MATH(-45.67,+2, 1)</input> returns -44.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id541640873986703" localize="false"><literal>COM.MICROSOFT.FLOOR.MATH</literal></paragraph> </section> <section id="floorprecise"> @@ -81,16 +84,19 @@ <h2 id="hd_id2957404"><variable id="FLOOR.PRECISEh1"><link href="text/scalc/01/func_floor.xhp#floorprecise" name="FLOOR.PRECISE">FLOOR.PRECISE</link></variable></h2> <paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id261586641501175">For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored.</paragraph> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/func_floor.xhp#floor_warn"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2957464" role="code" xml-lang="en-US">FLOOR.PRECISE(Number[; Significance])</paragraph> <embed href="text/scalc/01/func_floor.xhp#argnumber"/> <paragraph id="par_id2957497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1.</paragraph> - + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id981586291388900"><input>=FLOOR.PRECISE(3.45)</input> returns 3.</paragraph> <paragraph role="paragraph" id="par_id831586291395477"><input>=FLOOR.PRECISE(-45.67,2)</input> returns -46.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341650873986703" localize="false"><literal>COM.MICROSOFT.FLOOR.PRECISE</literal></paragraph> <comment>see also CEILING, EVEN, ODD, MROUND,INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> </section> @@ -101,7 +107,6 @@ <h2 id="hd_id791586291468176"><variable id="FLOOR.XCLh1"><link href="text/scalc/01/func_floor.xhp#floorxcl" name="FLOOR.XCL">FLOOR.XCL</link></variable></h2> <paragraph role="paragraph" id="par_id521586291476023">Rounds a number to the nearest multiple of a significance value.</paragraph> <paragraph role="paragraph" id="par_id401586291488768">For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative.</paragraph> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <warning id="par_id231586291503319">This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function.</warning> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id491586291532177">FLOOR.XCL(Number; Significance)</paragraph> @@ -111,6 +116,10 @@ <paragraph role="paragraph" id="par_id531586291622306"><input>=FLOOR.XCL(3.45,2)</input> returns 2.</paragraph> <paragraph role="paragraph" id="par_id361586291628003"><input>=FLOOR.XCL(-45.67,2)</input> returns -46.</paragraph> <paragraph role="paragraph" id="par_id801586291641099"><input>=FLOOR.XCL(-45.67,-2)</input> returns -44.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873978703" localize="false"><literal>COM.MICROSOFT.FLOOR</literal></paragraph> </section> <section id="relatedtopics"> <embed href="text/scalc/01/func_ceiling.xhp#CEILINGh1"/> diff --git a/source/text/scalc/01/func_forecastetsadd.xhp b/source/text/scalc/01/func_forecastetsadd.xhp index c2c0ea197d..bc981239e7 100644 --- a/source/text/scalc/01/func_forecastetsadd.xhp +++ b/source/text/scalc/01/func_forecastetsadd.xhp @@ -23,12 +23,11 @@ <bookmark_value>FORECAST.ETS.ADD function</bookmark_value> </bookmark> -<paragraph id="hd_id0603201610022291" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD function</link></paragraph> +<h1 id="hd_id0603201610022291"><link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD function</link></h1> <paragraph id="par_id0603201610023949" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_ADD">Calculates the additive forecast(s) (future values) based on the historical data using ETS or EDS algorithms</ahelp>. EDS is used when argument <emph>period_length</emph> is 0, otherwise ETS is used.</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.ADD calculates with the model</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/> -<embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id0403201618594544" role="code" xml-lang="en-US">FORECAST.ETS.ADD(targets, values, timeline, [period_length], [data_completion], [aggregation]) </paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#target"/> @@ -43,7 +42,10 @@ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 157.166666666667, the additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with one sample per period, no missing data, and AVERAGE as aggregation.</paragraph> <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.ADD(DATE(2014;1;1);Values;Timeline;4;TRUE();7)</paragraph> <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 113.251442038722, the additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with period length of 4, no missing data, and SUM as aggregation.</paragraph> - +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#5.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.FORECAST.ETS</literal></paragraph> </section> <section id="relatedtopics"> <paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also: diff --git a/source/text/scalc/01/func_forecastetspiadd.xhp b/source/text/scalc/01/func_forecastetspiadd.xhp index 17570cad29..4c3b6f0ab2 100644 --- a/source/text/scalc/01/func_forecastetspiadd.xhp +++ b/source/text/scalc/01/func_forecastetspiadd.xhp @@ -23,13 +23,12 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id976559765597655"> <bookmark_value>FORECAST.ETS.PI.ADD function</bookmark_value> </bookmark> -<paragraph id="hd_id0603201617134175" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD function</link></paragraph> +<h1 id="hd_id0603201617134175"><link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD function</link></h1> <paragraph id="par_id0603201617141750" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_PIA">Calculates the prediction interval(s) for additive forecast based on the historical data using ETS or EDS algorithms.</ahelp> EDS is used when argument <emph>period_length</emph> is 0, otherwise ETS is used.</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201610005998" role="paragraph" xml-lang="en-US">FORECAST.ETS.PI.ADD calculates with the model</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/> -<embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id0603201610010044" role="code" xml-lang="en-US">FORECAST.ETS.PI.ADD(target, values, timeline, [confidence_level], [period_length], [data_completion], [aggregation])</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#target"/> @@ -40,7 +39,7 @@ <embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/> <embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/> <paragraph id="par_id0403201618595126" role="paragraph" xml-lang="en-US">For example, with a 90% Confidence level, a 90% prediction interval will be computed (90% of future points are to fall within this radius from forecast). </paragraph> -<paragraph id="par_id0403201618595143" role="note" xml-lang="en-US">Note on prediction intervals: there is no exact mathematical way to calculate this for forecasts, there are various approximations. Prediction intervals tend to be increasingly 'over-optimistic' when increasing distance of the forecast-X from the observation data set.</paragraph> +<note id="par_id0403201618595143">Note on prediction intervals: there is no exact mathematical way to calculate this for forecasts, there are various approximations. Prediction intervals tend to be increasingly 'over-optimistic' when increasing distance of the forecast-X from the observation data set.</note> <paragraph id="par_id0403201618595150" role="paragraph" xml-lang="en-US">For ETS, Calc uses an approximation based on 1000 calculations with random variations within the standard deviation of the observation data set (the historical values).</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/> @@ -48,6 +47,10 @@ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 18.8061295551355, the prediction interval for additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, 90% (=0.9) confidence level, with one sample per period, no missing data, and AVERAGE as aggregation.</paragraph> <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)</paragraph> <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 23.4416821953741, the prediction interval for additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with confidence level of 0.8, period length of 4, no missing data, and SUM as aggregation.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#5.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.FORECAST.ETS.COFINT</literal></paragraph> </section> <section id="relatedtopics"> <paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also: diff --git a/source/text/scalc/01/func_forecastetsseason.xhp b/source/text/scalc/01/func_forecastetsseason.xhp index 9db5f21d0b..6fead6db6c 100644 --- a/source/text/scalc/01/func_forecastetsseason.xhp +++ b/source/text/scalc/01/func_forecastetsseason.xhp @@ -24,12 +24,11 @@ <bookmark_value>FORECAST.ETS.SEASONALITY function</bookmark_value> </bookmark> -<paragraph id="hd_id0603201617435371" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY Function</link></paragraph> +<h1 id="hd_id0603201617435371"><link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY Function</link></h1> <paragraph id="par_id0603201617510446" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_SEA">Returns the number of samples in period as calculated by Calc in case of FORECAST.ETS functions when argument <emph>period_length</emph> equals 1. </ahelp></paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0403201618595132" role="paragraph" xml-lang="en-US">The same result is returned with FORECAST.ETS.STAT functions when argument <emph>stat_type</emph> equals 9 (and <emph>period_length</emph> equals 1).</paragraph> -<embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id0603201618013796" role="code" xml-lang="en-US">FORECAST.ETS.SEASONALITY (values, timeline, [data_completion], [aggregation])</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> @@ -39,6 +38,10 @@ <embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/> <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.SEASONALITY(Values;Timeline;TRUE();1)</paragraph> <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 6, the number of samples in period based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, no missing data, and AVERAGE as aggregation.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#5.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.FORECAST.ETS.SEASONALITY</literal></paragraph> </section> <section id="relatedtopics"> diff --git a/source/text/scalc/01/func_forecastetsstatadd.xhp b/source/text/scalc/01/func_forecastetsstatadd.xhp index a6a22b1ba5..0d7d62bb1e 100644 --- a/source/text/scalc/01/func_forecastetsstatadd.xhp +++ b/source/text/scalc/01/func_forecastetsstatadd.xhp @@ -25,13 +25,12 @@ <bookmark_value>FORECAST.ETS.STAT.ADD function</bookmark_value> </bookmark> -<paragraph id="hd_id0603201615483251" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD Function</link></paragraph> +<h1 id="hd_id0603201615483251"><link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD Function</link></h1> <paragraph id="par_id0603201615485387" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_STA">Returns statistical value(s) that are results of the ETS/EDS algorithms.</ahelp></paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/> <paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.STAT.ADD calculates with the model </paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/> -<embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id0603201610005728" role="code" xml-lang="en-US">FORECAST.ETS.STAT.ADD (values, timeline, stat_type, [period_length], [data_completion], [aggregation])</paragraph> <embed href="text/scalc/01/exponsmooth_embd.xhp#values"/> @@ -46,6 +45,10 @@ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 0.9990234375, the additive statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with beta smoothing, one sample per period, no missing data, and AVERAGE as aggregation.</paragraph> <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.STAT.ADD(Values;Timeline;2;1;TRUE();7)</paragraph> <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 0.0615234375, the additive statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with gamma smoothing, no missing data, and SUM as aggregation.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#5.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.FORECAST.ETS.STAT</literal></paragraph> </section> <section id="relatedtopics"> <paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also: diff --git a/source/text/scalc/01/func_ifs.xhp b/source/text/scalc/01/func_ifs.xhp index ce498d27b4..26cd700930 100644 --- a/source/text/scalc/01/func_ifs.xhp +++ b/source/text/scalc/01/func_ifs.xhp @@ -24,7 +24,6 @@ <h2 id="hd_id271556234923654"><variable id="ifsfunct"><link href="text/scalc/01/func_ifs.xhp" name="function ifs">IFS</link></variable></h2> <paragraph id="par_id171556234923655" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">IFS is a multiple IF-function.</ahelp></variable></paragraph> </section> - <embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id271556235333493">IFS(expression1; result1[; expression2; result2][; ... ; [expression127; result127]])</paragraph> @@ -40,6 +39,10 @@ <paragraph role="paragraph" id="par_id671556235758504">To get a default result should no expression be TRUE, add a last expression that is always TRUE, like TRUE or 1=1 followed by the default result.</paragraph> <paragraph role="paragraph" id="par_id541556235771022">If there is a result missing for an expression or is no expression is TRUE, a #N/A error is returned.</paragraph> <paragraph role="paragraph" id="par_id181556235788473">If expression is neither TRUE or FALSE, a #VALUE error is returned.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.IFS</literal></paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/func_switch.xhp#switchfunct"/> <paragraph role="paragraph" id="par_id781556244709752"><link href="text/scalc/01/04060105.xhp#Section4" name="if">IF</link></paragraph> diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp index 55cdbe15e5..ec778f57de 100644 --- a/source/text/scalc/01/func_maxifs.xhp +++ b/source/text/scalc/01/func_maxifs.xhp @@ -26,7 +26,6 @@ <h1 id="hd_id658866588665886"><variable id="maxifs_head"><link href="text/scalc/01/func_maxifs.xhp">MAXIFS</link></variable> function</h1> <paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="maxifs_des">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MAXIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> @@ -55,6 +54,10 @@ <paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph> <paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "pen", the function returns 65, because the reference to the cell is substituted with its content.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#5.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.MAXIFS</literal></paragraph> <section id="relatedtopics"> <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> <embedvar href="text/scalc/01/04060184.xhp#max_head"/>, diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp index 57f92186b5..c5ddde101d 100644 --- a/source/text/scalc/01/func_minifs.xhp +++ b/source/text/scalc/01/func_minifs.xhp @@ -26,7 +26,6 @@ <h1 id="hd_id658866588665886"><variable id="minifs_head"><link href="text/scalc/01/func_minifs.xhp">MINIFS</link></variable> function</h1> <paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="minifs_des">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MINIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> @@ -55,6 +54,10 @@ <paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;A2:A6;".*"&E2;B2:B6;"<"&MAX(B2:B6))</item></paragraph> <paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "book", the function returns 180, because the reference to the cell is substituted with its content.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#5.2"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.MINIFS</literal></paragraph> <section id="relatedtopics"> <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> <embedvar href="text/scalc/01/04060184.xhp#max_head"/>, diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index 72c2021728..4a5e6d7b6f 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -34,7 +34,6 @@ <h2 id="hd_id231020162211573602"><variable id="networkdaysintl"><link href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></variable></h2> <paragraph id="par_id231020162213393086" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the number of workdays between a start date and an end date. There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days.</ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id231020162249539143" role="code" xml-lang="en-US">NETWORKDAYS.INTL(StartDate; EndDate [; [ Weekend ] [; Holidays ] ])</paragraph> <paragraph id="par_id231020162249533010" role="paragraph" xml-lang="en-US"><emph>StartDate</emph> is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation.</paragraph> @@ -51,6 +50,10 @@ <paragraph id="par_id231020162249553409" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3;“0000001”;F3:J3)</item> returns 24 workdays with Sunday only weekend.</paragraph> <paragraph id="par_id231020162249556946" role="paragraph" xml-lang="en-US">The function can be used without the two optional parameters – weekday and holidays – by leaving them out:</paragraph> <paragraph id="par_id23102016224955931" role="paragraph" xml-lang="en-US"><item type="input">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.NETWORKDAYS.INTL</literal></paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> </section> diff --git a/source/text/scalc/01/func_switch.xhp b/source/text/scalc/01/func_switch.xhp index f337953c94..18a7e65b4e 100644 --- a/source/text/scalc/01/func_switch.xhp +++ b/source/text/scalc/01/func_switch.xhp @@ -24,7 +24,6 @@ <h2 id="hd_id21556242313791"><variable id="switchfunct"><link href="text/scalc/01/func_switch.xhp" name="switch">SWITCH</link></variable></h2> <paragraph id="par_id361556242313793" role="paragraph" xml-lang="en-US"><variable id="functionswitch"><ahelp hid=".">SWITCH compares <emph>expression</emph> with <emph>value1</emph> to <emph>valuen</emph> and returns the result belonging to the first value that equals expression. If there is no match and default_result is given, that will be returned.</ahelp></variable></paragraph> </section> - <embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id521556242803283">SWITCH(expression; value1; result1[; value2; result2][; ... ; [value127; result127][; default_result]])</paragraph> @@ -36,6 +35,10 @@ <paragraph role="paragraph" id="par_id871556243022881">If no <emph>value</emph> equals <emph>expression</emph> and no default result is given, a #N/A error is returned.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id851556243961783"><input>=SWITCH(MONTH(A3),1,"January",2,"February",3,"March","No match")</input> returns "January" when A3 contains a date in January, "February" when A3 contains a date in February , etc...</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.SWITCH</literal></paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/func_ifs.xhp#ifsfunct"/> <paragraph role="paragraph" id="par_id781556244709752"><link href="text/scalc/01/04060105.xhp#Section4" name="if">IF</link></paragraph> diff --git a/source/text/scalc/01/func_textjoin.xhp b/source/text/scalc/01/func_textjoin.xhp index b7f04904d9..a4111c9252 100644 --- a/source/text/scalc/01/func_textjoin.xhp +++ b/source/text/scalc/01/func_textjoin.xhp @@ -24,7 +24,6 @@ <h2 id="hd_id551556227727946"><variable id="textjoinfunct"><link href="text/scalc/01/func_textjoin.xhp" name="textjoinfunction">TEXTJOIN</link></variable></h2> <paragraph id="par_id121556227727948" role="paragraph"><variable id="textjoinfunction"><ahelp hid=".">Concatenates one or more strings, and uses delimiters between them.</ahelp></variable></paragraph> </section> - <embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> <paragraph role="code" id="par_id541556228253979">TEXTJOIN( delimiter, skip_empty, String 1[; String 2][; … ;[String 253]] )</paragraph> <paragraph role="paragraph" id="par_id741556228390897"><emph>delimiter</emph> is a text string and can be a range.</paragraph> @@ -37,6 +36,10 @@ <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <paragraph role="paragraph" id="par_id441556229012536"><input>=TEXTJOIN(" "; 1; "Here"; "comes"; "the"; "sun")</input> returns "Here comes the sun" with space character as delimiter and empty strings are ignored.</paragraph> <paragraph role="paragraph" id="par_id441556239012536">if A1:B2 contains "Here", "comes", "the", "sun" respectively, <input>=TEXTJOIN("-";1;A1:B2)</input> returns "Here-comes-the-sun" with dash character as delimiter and empty strings are ignored.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.TEXTJOIN</literal></paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/func_concat.xhp#concatfunct"/> <paragraph role="paragraph" id="par_id781556244709752"><link href="text/scalc/01/04060110.xhp#concatenate" name="concatenate">CONCATENATE</link></paragraph> diff --git a/source/text/scalc/01/func_webservice.xhp b/source/text/scalc/01/func_webservice.xhp index d2eee3321e..cd1df5c87d 100644 --- a/source/text/scalc/01/func_webservice.xhp +++ b/source/text/scalc/01/func_webservice.xhp @@ -25,13 +25,16 @@ <paragraph role="paragraph" id="par_id3149893" xml-lang="en-US"><ahelp hid="HID_FUNC_WEBSERVICE">Get some web content from a URI.</ahelp></paragraph> </section> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3154844" xml-lang="en-US">WEBSERVICE(URI)</paragraph> <paragraph role="paragraph" id="par_id3147469" xml-lang="en-US"><emph>URI: </emph> URI text of the web service.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3146142" xml-lang="en-US"><item type="input">=WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss")</item></paragraph> <paragraph role="paragraph" id="par_id3146143" xml-lang="en-US">Returns the web page content of "https://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss".</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640870986703" localize="false"><literal>COM.MICROSOFT.WEBSERVICE</literal></paragraph> </section> <section id="filterxml"> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FILTERXML" id="bm_id2950028" localize="false"/> @@ -42,7 +45,6 @@ <h2 id="hd_id2949012"><variable id="filterxmlfuncname"><link href="text/scalc/01/func_webservice.xhp#filterxml" name="filterxml">FILTERXML</link></variable></h2> <paragraph role="paragraph" id="par_id2949893" xml-lang="en-US"><ahelp hid="HID_FUNC_FILTERXML">Apply a XPath expression to a XML document.</ahelp></paragraph> </section> - <embed href="text/scalc/00/avail_release.xhp#4.2"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id2954844" xml-lang="en-US">FILTERXML(XML Document; XPath expression)</paragraph> <paragraph role="paragraph" id="par_id2947469" xml-lang="en-US"><emph>XML Document (required):</emph> String containing a valid XML stream.</paragraph> @@ -50,6 +52,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2946142" xml-lang="en-US"><item type="input">=FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate")</item></paragraph> <paragraph role="paragraph" id="par_id2946143" xml-lang="en-US"> Returns information on the last build date of the wiki.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.2"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341600873986703" localize="false"><literal>COM.MICROSOFT.FILTERXML</literal></paragraph> </section> <section id="encodeurl"> <bookmark id="bm_id121517132649769" xml-lang="en-US" branch="hid/SC_HID_FUNC_ENCODEURL" localize="false"/> @@ -61,13 +67,16 @@ <paragraph id="par_id51517132649769" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ENCODEURL">Returns a URL-encoded string.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id721517134647880" xml-lang="en-US">Use this function to transform text with symbols of national alphabets (for example accented characters, non-ASCII alphabets or Asian words) to a string of URL-standard symbols.</paragraph> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id351517132879400" xml-lang="en-US">ENCODEURL(Text)</paragraph> <paragraph role="paragraph" id="par_id921517132924079" xml-lang="en-US"><emph>Text</emph>: String to encode to a sequence of URL-standard symbols.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id651517132994921" xml-lang="en-US">If cell A1 contains the Cyrillic text "автомобиль", <item type="input">=ENCODEURL(A1)</item> returns %D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%BE%D0%B1%D0%B8%D0%BB%D1%8C (the word "автомобиль" means car in Russian).</paragraph> <paragraph role="paragraph" id="par_id991517133057478" xml-lang="en-US">If cell B1 contains the text "車", <item type="input">=ENCODEURL(B1)</item> returns %E8%BB%8A ("車" means car in Japanese).</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id301640873986703" localize="false"><literal>COM.MICROSOFT.ENCODEURL</literal></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/01/func_workday.intl.xhp b/source/text/scalc/01/func_workday.intl.xhp index e79d023af6..f41a62d870 100644 --- a/source/text/scalc/01/func_workday.intl.xhp +++ b/source/text/scalc/01/func_workday.intl.xhp @@ -35,7 +35,6 @@ <h2 id="hd_id231020162348002143"><variable id="workdaysintl"><link href="text/scalc/01/func_workday.intl.xhp">WORKDAY.INTL</link></variable></h2> <paragraph id="par_id23102016234837285" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the date calculated from a start date with a specific number of work days, before or after the start date. The calculation can include week-ends and holidays as non-working days.</ahelp></paragraph> </section> -<embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id241020160008306838" role="code" xml-lang="en-US">WORKDAY.INTL(StartDate; Days [; Weekend [; Holidays]])</paragraph> <paragraph id="par_id241020160008308885" role="paragraph" xml-lang="en-US"><emph>StartDate</emph>: is the date from when the calculation is carried out.</paragraph> @@ -56,6 +55,10 @@ <paragraph id="par_id241020160012183680" role="paragraph" xml-lang="en-US"><item type="input">=WORKDAY.INTL(C3;D3;"0000001";F3:J3)</item> returns January 9, 2017.</paragraph> <paragraph id="par_id241020160012181870" role="paragraph" xml-lang="en-US">The function can be used without the two optional parameters – Weekday and Holidays – by leaving them out:</paragraph> <paragraph id="par_id241020160012182048" role="paragraph" xml-lang="en-US"><item type="input">=WORKDAY.INTL(C3;D3)</item> gives the result: January 10, 2017.</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> +<embed href="text/scalc/00/avail_release.xhp#4.3"/> +<embed href="text/scalc/01/common_func.xhp#notODFF"/> +<paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.WORKDAY.INTL</literal></paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/04060102.xhp#datetimefunctions"/> </section> |