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@redhat.com>
Tested-by: David Tardon <dtardon@redhat.com>

1 files changed, 158 insertions, 0 deletions

diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index 04994d133a..6505696b67 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>