[Libreoffice-commits] help.git: 2 commits - source/text
Olivier Hallot
olivier.hallot at edx.srv.br
Sun Jul 27 01:16:11 PDT 2014
source/text/scalc/01/04060181.xhp | 158 ++++++++++++++++++++++++++++++++++++++
source/text/scalc/01/04060185.xhp | 27 ++++++
2 files changed, 185 insertions(+)
New commits:
commit 7f0032fe6975853065f593830c82ff37a9f61cd5
Author: Olivier Hallot <olivier.hallot at edx.srv.br>
Date: Sat Jul 26 22:53:26 2014 -0300
Fix fdo#80452, New CHISQ functions
help entry for CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT,CHISQ.TEST
Change-Id: I19bc7ed2b50aeb70df8126df7900192e5903e0cb
Reviewed-on: https://gerrit.libreoffice.org/10566
Reviewed-by: David Tardon <dtardon at redhat.com>
Tested-by: David Tardon <dtardon at redhat.com>
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index 04994d1..6505696 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -300,6 +300,20 @@
<paragraph xml-lang="en-US" id="par_id0119200902475282" role="paragraph" l10n="NEW">
<emph>Degrees Of Freedom</emph> is the degrees of freedom for the chi-square function.</paragraph>
</section>
+<section id="chisqdotinv">
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQINV_MS" id="bm_id2919200902430717" localize="false"/>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2919200902432928">
+ <bookmark_value>CHISQ.INV function</bookmark_value>
+ </bookmark>
+ <paragraph xml-lang="en-US" id="hd_id2919200902421451" role="heading" level="2" l10n="NEW">CHISQ.INV</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2919200902421449" role="paragraph" l10n="NEW"><ahelp hid="HID_FUNC_CHISQINV_MS">Returns the inverse of the left-tailed probability of the chi-square distribution.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2919200902475241" role="heading" level="3" l10n="NEW">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id1150504" role="code" l10n="U" oldref="91">CHISQ.INV(Probability; DegreesFreedom)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2919200902475286" role="paragraph" l10n="NEW"><emph>Probability</emph> is the probability value for which the inverse of the chi-square distribution is to be calculated.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2919200902475282" role="paragraph" l10n="NEW"><emph>Degrees Of Freedom</emph> is the degrees of freedom for the chi-square function.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id271171" role="heading" level="3" l10n="U" oldref="84">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id275666" role="paragraph" l10n="U" oldref="85"><item type="input">=CHISQ.INV(0,5;1)</item> returns 0.4549364231.</paragraph>
+ </section>
<section id="chiinv">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148835"><bookmark_value>CHIINV function</bookmark_value>
</bookmark>
@@ -325,6 +339,25 @@
<item type="input">=CHIINV(0.02;5)</item> returns 13.39.</paragraph>
<paragraph xml-lang="en-US" id="par_id3158401" role="paragraph" l10n="U" oldref="134">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>
</section>
+<section id="chisqdotinvdotrt">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2948835">
+ <bookmark_value>CHISQ.INV.RT function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQINV_MS" id="bm_id2948823" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2948835" role="heading" level="2" l10n="U" oldref="88">CHISQ.INV.RT</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949906" role="paragraph" l10n="U" oldref="89"><ahelp hid="HID_FUNC_CHISQINV_MS">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2959157" role="heading" level="3" l10n="U" oldref="90">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2950504" role="code" l10n="U" oldref="91">CHISQ.INV.RT(Number; DegreesFreedom)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954898" role="paragraph" l10n="U" oldref="92"><emph>Number</emph> is the value of the error probability.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954294" role="paragraph" l10n="U" oldref="93"><emph>DegreesFreedom</emph> is the degrees of freedom of the experiment.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2954208" role="heading" level="3" l10n="U" oldref="94">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2950777" role="paragraph" l10n="U" oldref="130">A die is thrown 1020 times. The numbers on the die 1 through 6 come up 195, 151, 148, 189, 183 and 154 times (observation values). The hypothesis that the die is not fixed is to be tested.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953062" role="paragraph" l10n="U" oldref="131">The Chi square distribution of the random sample is determined by the formula given above. Since the expected value for a given number on the die for n throws is n times 1/6, thus 1020/6 = 170, the formula returns a Chi square value of 13.27.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948806" role="paragraph" l10n="U" oldref="132">If the (observed) Chi square is greater than or equal to the (theoretical) Chi square CHIINV, the hypothesis will be discarded, since the deviation between theory and experiment is too great. If the observed Chi square is less that CHIINV, the hypothesis is confirmed with the indicated probability of error.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949763" role="paragraph" l10n="U" oldref="95"><item type="input">=CHISQ.INV.RT(0.05;5)</item> returns 11.0704976935.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2959142" role="paragraph" l10n="U" oldref="133"><item type="input">=CHISQ.INV.RT(0.02;5)</item> returns 13.388222599.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2958401" role="paragraph" l10n="U" oldref="134">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>
+</section>
<section id="chitest">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154260"><bookmark_value>CHITEST function</bookmark_value>
</bookmark>
@@ -448,6 +481,99 @@
<paragraph xml-lang="en-US" id="par_id3149481" role="paragraph" l10n="U" oldref="104">
<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>
+<section id="chidottest">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2954260">
+ <bookmark_value>CHISQ.TEST function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHITEST_MS" id="bm_id2955355" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2954260" role="heading" level="2" l10n="U" oldref="97">CHISQ.TEST</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2951052" role="paragraph" l10n="U" oldref="98"><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> CHI.TEST returns the chi-squared distribution of the data.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948925" role="paragraph" l10n="U" oldref="135">The probability determined by CHI.TEST can also be determined with CHI.DIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2954280" role="heading" level="3" l10n="U" oldref="99">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949162" role="code" l10n="U" oldref="100">CHISQ.TEST(DataB; DataE)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2958421" role="paragraph" l10n="U" oldref="101"><emph>DataB</emph> is the array of the observations.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2966453" role="paragraph" l10n="U" oldref="102"><emph>DataE</emph> is the range of the expected values.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2946946" role="heading" level="3" l10n="U" oldref="103">Example</paragraph>
+ <table id="tbl_id2953233">
+ <tablerow>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2954096" role="paragraph" l10n="U" oldref="136">Data_B (observed)</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2952948" role="paragraph" l10n="U" oldref="137">Data_E (expected)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2952876" role="paragraph" l10n="U" oldref="138">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2959279" role="paragraph" l10n="U" oldref="139"><item type="input">195</item></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2949105" role="paragraph" l10n="U" oldref="140"><item type="input">170</item></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2949922" role="paragraph" l10n="U" oldref="141">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2948621" role="paragraph" l10n="U" oldref="142"><item type="input">151</item></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2948987" role="paragraph" l10n="U" oldref="143"><item type="input">170</item></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2949417" role="paragraph" l10n="U" oldref="144">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2948661" role="paragraph" l10n="U" oldref="145"><item type="input">148</item></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2951128" role="paragraph" l10n="U" oldref="146"><item type="input">170</item></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2948467" role="paragraph" l10n="U" oldref="147">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2949237" role="paragraph" l10n="U" oldref="148"><item type="input">189</item></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2945304" role="paragraph" l10n="U" oldref="149"><item type="input">170</item></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2949927" role="paragraph" l10n="U" oldref="150">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2950630" role="paragraph" l10n="U" oldref="151"><item type="input">183</item></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2950423" role="paragraph" l10n="U" oldref="152"><item type="input">170</item></paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2943275" role="paragraph" l10n="U" oldref="153">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2944750" role="paragraph" l10n="U" oldref="154"><item type="input">154</item></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id2953947" role="paragraph" l10n="U" oldref="155"><item type="input">170</item></paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <paragraph xml-lang="en-US" id="par_id2949481" role="paragraph" l10n="U" oldref="104"><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>
+</section>
<section id="chidist">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148690"><bookmark_value>CHIDIST function</bookmark_value>
</bookmark>
@@ -469,6 +595,38 @@
<item type="input">=CHIDIST(13.27; 5)</item> equals 0.02.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156141" role="paragraph" l10n="U" oldref="158">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>
</section>
+<section id="chisqdotdist">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2848690">
+ <bookmark_value>CHISQ.DIST function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQDIST_MS" id="bm_id2947521" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2848690" role="heading" level="2" l10n="U" oldref="106">CHISQ.DIST</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2856338" role="paragraph" l10n="U" oldref="156"><ahelp hid="HID_FUNC_CHISQDIST_MS">Returns the probability density function or the cumulative distribution function for the chi-square distribution.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2855123" role="heading" level="3" l10n="U" oldref="108">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2858439" role="code" l10n="U" oldref="109">CHISQ.DIST(Number; DegreesFreedom; Cumulative)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2848675" role="paragraph" l10n="U" oldref="110"><emph>Number</emph> is the chi-square value of the random sample used to determine the error probability.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2855615" role="paragraph" l10n="U" oldref="111"><emph>DegreesFreedom</emph> are the degrees of freedom of the experiment.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id282020091254453" role="paragraph" l10n="NEW"><emph>Cumulative</emph> can be 0 or False to calculate the probability density function. It can be any other value or True or omitted to calculate the cumulative distribution function.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2846787" role="heading" level="3" l10n="U" oldref="112">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2845774" role="paragraph" l10n="U" oldref="113"><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 xml-lang="en-US" id="par_id2745774" role="paragraph" l10n="U" oldref="113"><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>
+</section>
+<section id="chisqdotdistdotrt">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2948690">
+ <bookmark_value>CHISQ.DIST.RT function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQDIST_MS" id="bm_id2947521" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2948690" role="heading" level="2" l10n="U" oldref="106">CHISQ.DIST.RT</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956338" role="paragraph" l10n="U" oldref="156"><ahelp hid="HID_FUNC_CHISQDIST_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 xml-lang="en-US" id="par_id2951316" role="paragraph" l10n="U" oldref="157">The probability determined by CHISQ.DIST.RT can also be determined by CHITEST.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2955123" role="heading" level="3" l10n="U" oldref="108">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2958439" role="code" l10n="U" oldref="109">CHISQ.DIST.RT(Number; DegreesFreedom)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948675" role="paragraph" l10n="U" oldref="110"><emph>Number</emph> is the chi-square value of the random sample used to determine the error probability.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2955615" role="paragraph" l10n="U" oldref="111"><emph>DegreesFreedom</emph> are the degrees of freedom of the experiment.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2946787" role="heading" level="3" l10n="U" oldref="112">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2945774" role="paragraph" l10n="U" oldref="113"><item type="input">=CHISQ.DIST.RT(13.27; 5)</item> equals 0.0209757694.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956141" role="paragraph" l10n="U" oldref="158">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>
+</section>
<section id="chisqdist">
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CHISQDIST" id="bm_id0119200902213671" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id0119200902231887"><bookmark_value>CHISQDIST function</bookmark_value>
commit 119c3b054da571974cb9d37acc908b9bd216fc4a
Author: Olivier Hallot <olivier.hallot at edx.srv.br>
Date: Sat Jul 26 17:33:33 2014 -0300
Fix fdo#80445, help pages for VAR functions
VAR.P and VAR.S
Change-Id: I6c7204c425678810b6383c59f3c6d2e791c26977
Reviewed-on: https://gerrit.libreoffice.org/10560
Reviewed-by: David Tardon <dtardon at redhat.com>
Tested-by: David Tardon <dtardon at redhat.com>
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 1c0db0c..e7f19b6 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -492,6 +492,20 @@
<item type="input">=VAR(A1:A50)</item>
</paragraph>
</section>
+<section id="vardots">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2953828">
+ <bookmark_value>VAR.S function</bookmark_value>
+ <bookmark_value>variances</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_S" id="bm_id2954898" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2953828" role="heading" level="2" l10n="U" oldref="128">VAR.S</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2959165" role="paragraph" l10n="U" oldref="129"><ahelp hid="HID_FUNC_VAR_S">Estimates the variance based on a sample.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2954286" role="heading" level="3" l10n="U" oldref="130">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953054" role="code" l10n="U" oldref="131">VAR.S(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948938" role="paragraph" l10n="CHG" oldref="132"><emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2947233" role="heading" level="3" l10n="U" oldref="133">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953575" role="paragraph" l10n="U" oldref="134"><item type="input">=VAR.S(A1:A50)</item></paragraph>
+</section>
<section id="vara">
<bookmark xml-lang="en-US" branch="index" id="bm_id3151045"><bookmark_value>VARA function</bookmark_value>
</bookmark>
@@ -528,6 +542,19 @@
<item type="input">=VARP(A1:A50)</item>
</paragraph>
</section>
+<section id="vardotp">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2966441">
+ <bookmark_value>VAR.P function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_P_MS" id="bm_id2952359" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2966441" role="heading" level="2" l10n="U" oldref="136">VAR.P</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2959199" role="paragraph" l10n="U" oldref="137"><ahelp hid="HID_FUNC_VAR_P_MS">Calculates a variance based on the entire population.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2950706" role="heading" level="3" l10n="U" oldref="138">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2947282" role="code" l10n="U" oldref="139">VAR.P(Number1; Number2; ...Number30)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949793" role="paragraph" l10n="CHG" oldref="140"><emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2952939" role="heading" level="3" l10n="U" oldref="141">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953385" role="paragraph" l10n="U" oldref="142"><item type="input">=VAR.P(A1:A50)</item></paragraph>
+</section>
<section id="varpa">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value>
</bookmark>
More information about the Libreoffice-commits
mailing list