sal/rtl/math.cxx | 3
sc/qa/unit/data/functions/mathematical/fods/round.fods | 45 +++-
sc/qa/unit/data/functions/statistical/fods/chisq.test.fods | 50 ++---
sc/qa/unit/data/functions/statistical/fods/chisqdist.fods | 40 ++--
sc/qa/unit/data/functions/statistical/fods/chisqinv.fods | 118 ++++++-------
sc/qa/unit/data/functions/statistical/fods/chitest.fods | 50 ++---
sc/qa/unit/data/functions/statistical/fods/stdevpa.fods | 28 +--
sc/qa/unit/data/functions/statistical/fods/t.dist.rt.fods | 66 +++----
sc/qa/unit/data/functions/statistical/fods/tinv.fods | 60 +++---
9 files changed, 243 insertions(+), 217 deletions(-)
New commits:
commit b97a0df0f3234b4c1140ba1418d4b96a592afa4a
Author: Winfried Donkers <winfrieddonk...@libreoffice.org>
Date: Sat Dec 30 18:25:02 2017 +0100
tdf#96821 fix corner cases for Calc function ROUND.
For very large integer numbers, e.g. 2^52+1, ROUND produced incorrect
results because rtl::math::round uses
floor( number + 0.5 + small_correction_value ), which reduces the maximum
possible mantissa resolution.a
Correction of several unit test documents (Calc functions) with rounding
errors that only became apparent with this fix.
Change-Id: I1769c9939a3d6118d3bfbfdf8e41dd4619997232
Reviewed-on: https://gerrit.libreoffice.org/47179
Tested-by: Jenkins <c...@libreoffice.org>
Reviewed-by: Eike Rathke <er...@redhat.com>
diff --git a/sal/rtl/math.cxx b/sal/rtl/math.cxx
index 4b149b9f99dd..387ae3b2b4aa 100644
--- a/sal/rtl/math.cxx
+++ b/sal/rtl/math.cxx
@@ -1076,6 +1076,9 @@ double SAL_CALL rtl_math_round(double fValue, int
nDecPlaces,
if (fValue == 0.0)
return fValue;
+ if ( nDecPlaces == 0 && eMode == rtl_math_RoundingMode_Corrected )
+ return std::round( fValue );
+
// sign adjustment
bool bSign = rtl::math::isSignBitSet( fValue );
if (bSign)
diff --git a/sc/qa/unit/data/functions/mathematical/fods/round.fods
b/sc/qa/unit/data/functions/mathematical/fods/round.fods
index 0f0a5b9026c3..d75968c17bbe 100644
--- a/sc/qa/unit/data/functions/mathematical/fods/round.fods
+++ b/sc/qa/unit/data/functions/mathematical/fods/round.fods
@@ -2117,20 +2117,43 @@
<table:table-cell table:number-columns-repeated="11"/>
</table:table-row>
<table:table-row table:style-name="ro2">
- <table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce14"/>
- <table:table-cell/>
- <table:table-cell table:style-name="ce26"/>
- <table:table-cell table:style-name="ce11"
table:content-validation-name="val1"/>
+ <table:table-cell table:formula="of:=ROUND(2^52+1;0)"
office:value-type="float" office:value="4503599627370497"
calcext:value-type="float">
+ <text:p>4503599627370497</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="float"
office:value="4503599627370497" calcext:value-type="float">
+ <text:p>4503599627370497</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce44"
table:formula="of:=[.A17]=[.B17]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce21"
table:formula="of:=FORMULA([.A17])" office:value-type="string"
office:string-value="=ROUND(2^52+1;0)" calcext:value-type="string">
+ <text:p>=ROUND(2^52+1,0)</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce26" office:value-type="string"
calcext:value-type="string">
+ <text:p>limit of resolution</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce42"
table:content-validation-name="val1"/>
<table:table-cell table:number-columns-repeated="3"/>
<table:table-cell table:style-name="ce32"/>
<table:table-cell table:number-columns-repeated="5"/>
</table:table-row>
- <table:table-row table:style-name="ro5">
- <table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce14"/>
- <table:table-cell table:style-name="ce22"/>
- <table:table-cell table:number-columns-repeated="6"/>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:formula="of:=ROUND(2^52+1)"
office:value-type="float" office:value="4503599627370497"
calcext:value-type="float">
+ <text:p>4503599627370497</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="float"
office:value="4503599627370497" calcext:value-type="float">
+ <text:p>4503599627370497</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce44"
table:formula="of:=[.A18]=[.B18]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce21"
table:formula="of:=FORMULA([.A18])" office:value-type="string"
office:string-value="=ROUND(2^52+1)" calcext:value-type="string">
+ <text:p>=ROUND(2^52+1)</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce26" office:value-type="string"
calcext:value-type="string">
+ <text:p>limit of resolution</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="5"/>
<table:table-cell table:style-name="ce32"
table:number-columns-repeated="4"/>
<table:table-cell/>
</table:table-row>
@@ -2380,4 +2403,4 @@
</table:named-expressions>
</office:spreadsheet>
</office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/chisq.test.fods
b/sc/qa/unit/data/functions/statistical/fods/chisq.test.fods
index 9eac30114eb7..648f8b864679 100644
--- a/sc/qa/unit/data/functions/statistical/fods/chisq.test.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/chisq.test.fods
@@ -3803,7 +3803,7 @@
<table:table-cell table:style-name="ce19" office:value-type="float"
office:value="1.16440189336067E-029" calcext:value-type="float">
<text:p>1.16440189336067E-29</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A2];14)=ORG.LIBREOFFICE.ROUNDSIG([.B2];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A2];15)=ORG.LIBREOFFICE.ROUNDSIG([.B2];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A2])" office:value-type="string"
office:string-value="=CHISQ.TEST(F1:F11,G1:G11)" calcext:value-type="string">
@@ -3866,7 +3866,7 @@
<table:table-cell table:style-name="ce19" office:value-type="float"
office:value="0.000000000903490480352966" calcext:value-type="float">
<text:p>9.03490480352966E-10</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A3];14)=ORG.LIBREOFFICE.ROUNDSIG([.B3];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A3];15)=ORG.LIBREOFFICE.ROUNDSIG([.B3];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A3])" office:value-type="string"
office:string-value="=CHISQ.TEST(F1:F11,H1:H11)" calcext:value-type="string">
@@ -3934,7 +3934,7 @@
<table:table-cell office:value-type="float"
office:value="0.00000000134423459890025" calcext:value-type="float">
<text:p>1.34423459890025E-09</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A4];14)=ORG.LIBREOFFICE.ROUNDSIG([.B4];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A4];15)=ORG.LIBREOFFICE.ROUNDSIG([.B4];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A4])" office:value-type="string"
office:string-value="=CHISQ.TEST(H1:H11,G1:G11)" calcext:value-type="string">
@@ -4000,7 +4000,7 @@
<table:table-cell office:value-type="float" office:value="0"
calcext:value-type="float">
<text:p>0</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A5];14)=ORG.LIBREOFFICE.ROUNDSIG([.B5];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A5];15)=ORG.LIBREOFFICE.ROUNDSIG([.B5];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A5])" office:value-type="string"
office:string-value="=CHISQ.TEST(H1:H11,F1:F11)" calcext:value-type="string">
@@ -4058,7 +4058,7 @@
<table:table-cell office:value-type="float"
office:value="0.0000000000112896923737676" calcext:value-type="float">
<text:p>1.12896923737676E-11</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A6];14)=ORG.LIBREOFFICE.ROUNDSIG([.B6];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A6];15)=ORG.LIBREOFFICE.ROUNDSIG([.B6];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A6])" office:value-type="string"
office:string-value="=CHISQ.TEST(F1:F11,I1:I11)" calcext:value-type="string">
@@ -4121,7 +4121,7 @@
<table:table-cell office:value-type="float"
office:value="0.997916658208002" calcext:value-type="float">
<text:p>0.997916658208002</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A7];14)=ORG.LIBREOFFICE.ROUNDSIG([.B7];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A7];15)=ORG.LIBREOFFICE.ROUNDSIG([.B7];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A7])" office:value-type="string"
office:string-value="=CHISQ.TEST(H1:H11,I1:I11)" calcext:value-type="string">
@@ -4184,7 +4184,7 @@
<table:table-cell office:value-type="float"
office:value="0.00154971363304587" calcext:value-type="float">
<text:p>0.001549713633046</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A8];14)=ORG.LIBREOFFICE.ROUNDSIG([.B8];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A8];15)=ORG.LIBREOFFICE.ROUNDSIG([.B8];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A8])" office:value-type="string"
office:string-value="=CHISQ.TEST(L3:L9,M3:M9)" calcext:value-type="string">
@@ -4246,7 +4246,7 @@
<table:table-cell office:value-type="float"
office:value="0.0202524730723578" calcext:value-type="float">
<text:p>0.020252473072358</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A9];14)=ORG.LIBREOFFICE.ROUNDSIG([.B9];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A9];15)=ORG.LIBREOFFICE.ROUNDSIG([.B9];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A9])" office:value-type="string"
office:string-value="=CHISQ.TEST(L4:L10,M4:M10)" calcext:value-type="string">
@@ -4306,7 +4306,7 @@
<table:table-cell office:value-type="float"
office:value="1.66789802691649E-016" calcext:value-type="float">
<text:p>1.66789802691649E-16</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A10];14)=ORG.LIBREOFFICE.ROUNDSIG([.B10];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A10];15)=ORG.LIBREOFFICE.ROUNDSIG([.B10];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A10])" office:value-type="string"
office:string-value="=CHISQ.TEST(T1:T14,U1:U14)" calcext:value-type="string">
@@ -4358,7 +4358,7 @@
<table:table-cell office:value-type="float" office:value="0"
calcext:value-type="float">
<text:p>0</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A11];14)=ORG.LIBREOFFICE.ROUNDSIG([.B11];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A11];15)=ORG.LIBREOFFICE.ROUNDSIG([.B11];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A11])" office:value-type="string"
office:string-value="=CHISQ.TEST(U1:U14,T1:T14)" calcext:value-type="string">
@@ -4403,7 +4403,7 @@
<table:table-cell office:value-type="float"
office:value="0.000308192017008309" calcext:value-type="float">
<text:p>0.000308192017008</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A12];14)=ORG.LIBREOFFICE.ROUNDSIG([.B12];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A12];15)=ORG.LIBREOFFICE.ROUNDSIG([.B12];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A12])" office:value-type="string"
office:string-value="=CHISQ.TEST(W2:X4,W6:X8)" calcext:value-type="string">
@@ -4435,7 +4435,7 @@
<table:table-cell office:value-type="float"
office:value="0.816527699624637" calcext:value-type="float">
<text:p>0.816527699624637</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A13];14)=ORG.LIBREOFFICE.ROUNDSIG([.B13];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A13];15)=ORG.LIBREOFFICE.ROUNDSIG([.B13];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A13])" office:value-type="string"
office:string-value="=CHISQ.TEST(F1:I1,F2:I2)" calcext:value-type="string">
@@ -4466,7 +4466,7 @@
<table:table-cell office:value-type="float"
office:value="0.87928370831036" calcext:value-type="float">
<text:p>0.87928370831036</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A14];14)=ORG.LIBREOFFICE.ROUNDSIG([.B14];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A14];15)=ORG.LIBREOFFICE.ROUNDSIG([.B14];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A14])" office:value-type="string"
office:string-value="=CHISQ.TEST(F2:I2,F3:I3)" calcext:value-type="string">
@@ -4507,7 +4507,7 @@
<table:table-cell office:value-type="float"
office:value="0.911826184650631" calcext:value-type="float">
<text:p>0.911826184650631</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A15];14)=ORG.LIBREOFFICE.ROUNDSIG([.B15];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A15];15)=ORG.LIBREOFFICE.ROUNDSIG([.B15];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A15])" office:value-type="string"
office:string-value="=CHISQ.TEST(F3:I3,F4:I4)" calcext:value-type="string">
@@ -4550,7 +4550,7 @@
<table:table-cell office:value-type="float"
office:value="0.9314883584606" calcext:value-type="float">
<text:p>0.9314883584606</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A16];14)=ORG.LIBREOFFICE.ROUNDSIG([.B16];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A16];15)=ORG.LIBREOFFICE.ROUNDSIG([.B16];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A16])" office:value-type="string"
office:string-value="=CHISQ.TEST(F4:I4,F5:I5)" calcext:value-type="string">
@@ -4581,7 +4581,7 @@
<table:table-cell office:value-type="float"
office:value="0.944539492146675" calcext:value-type="float">
<text:p>0.944539492146675</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A17];14)=ORG.LIBREOFFICE.ROUNDSIG([.B17];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A17];15)=ORG.LIBREOFFICE.ROUNDSIG([.B17];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A17])" office:value-type="string"
office:string-value="=CHISQ.TEST(F5:I5,F6:I6)" calcext:value-type="string">
@@ -4617,7 +4617,7 @@
<table:table-cell office:value-type="float"
office:value="0.953774634535083" calcext:value-type="float">
<text:p>0.953774634535083</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A18];14)=ORG.LIBREOFFICE.ROUNDSIG([.B18];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A18];15)=ORG.LIBREOFFICE.ROUNDSIG([.B18];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A18])" office:value-type="string"
office:string-value="=CHISQ.TEST(F6:I6,F7:I7)" calcext:value-type="string">
@@ -4655,7 +4655,7 @@
<table:table-cell office:value-type="float"
office:value="0.960619865110165" calcext:value-type="float">
<text:p>0.960619865110165</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A19];14)=ORG.LIBREOFFICE.ROUNDSIG([.B19];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A19];15)=ORG.LIBREOFFICE.ROUNDSIG([.B19];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A19])" office:value-type="string"
office:string-value="=CHISQ.TEST(F7:I7,F8:I8)" calcext:value-type="string">
@@ -4681,7 +4681,7 @@
<table:table-cell office:value-type="float"
office:value="0.965875482278625" calcext:value-type="float">
<text:p>0.965875482278625</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A20];14)=ORG.LIBREOFFICE.ROUNDSIG([.B20];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A20];15)=ORG.LIBREOFFICE.ROUNDSIG([.B20];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A20])" office:value-type="string"
office:string-value="=CHISQ.TEST(F8:I8,F9:I9)" calcext:value-type="string">
@@ -4707,7 +4707,7 @@
<table:table-cell office:value-type="float"
office:value="0.970023721006623" calcext:value-type="float">
<text:p>0.970023721006623</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A21];14)=ORG.LIBREOFFICE.ROUNDSIG([.B21];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A21];15)=ORG.LIBREOFFICE.ROUNDSIG([.B21];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A21])" office:value-type="string"
office:string-value="=CHISQ.TEST(F9:I9,F10:I10)" calcext:value-type="string">
@@ -4733,7 +4733,7 @@
<table:table-cell office:value-type="float"
office:value="0.973371683412022" calcext:value-type="float">
<text:p>0.973371683412022</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A22];14)=ORG.LIBREOFFICE.ROUNDSIG([.B22];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A22];15)=ORG.LIBREOFFICE.ROUNDSIG([.B22];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A22])" office:value-type="string"
office:string-value="=CHISQ.TEST(F10:I10,F11:I11)" calcext:value-type="string">
@@ -4792,7 +4792,7 @@
<table:table-cell office:value-type="float"
office:value="0.726644540598389" calcext:value-type="float">
<text:p>0.726644540598389</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ROUND([.A24];14)=ROUND([.B24];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ROUND([.A24];15)=ROUND([.B24];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A24])" office:value-type="string"
office:string-value="=CHISQ.TEST(I13:J17,L13:M17)" calcext:value-type="string">
@@ -4850,7 +4850,7 @@
<table:table-cell office:value-type="float"
office:value="0.721391783070078" calcext:value-type="float">
<text:p>0.721391783070078</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ROUND([.A26];14)=ROUND([.B26];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ROUND([.A26];15)=ROUND([.B26];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A26])" office:value-type="string"
office:string-value="=CHISQ.TEST(J13:K17,M13:N17)" calcext:value-type="string">
@@ -4908,7 +4908,7 @@
<table:table-cell office:value-type="float"
office:value="0.999898925814582" calcext:value-type="float">
<text:p>0.999898925814582</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ROUND([.A28];14)=ROUND([.B28];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ROUND([.A28];15)=ROUND([.B28];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A28])" office:value-type="string"
office:string-value="=CHISQ.TEST(K13:L17,N13:O17)" calcext:value-type="string">
@@ -5412,4 +5412,4 @@
</table:named-expressions>
</office:spreadsheet>
</office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/chisqdist.fods
b/sc/qa/unit/data/functions/statistical/fods/chisqdist.fods
index c9a69597b71e..6c4313b3bdaa 100644
--- a/sc/qa/unit/data/functions/statistical/fods/chisqdist.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/chisqdist.fods
@@ -2832,10 +2832,10 @@
<table:table-cell table:formula="of:=CHISQDIST(3; 2; 0)"
office:value-type="float" office:value="0.111565080074215"
calcext:value-type="float">
<text:p>0.111565080074215</text:p>
</table:table-cell>
- <table:table-cell office:value-type="float"
office:value="0.111565080074215" calcext:value-type="float">
+ <table:table-cell table:formula="of:=0.11156508007421+4.91E-015"
office:value-type="float" office:value="0.944539492146675"
calcext:value-type="float">
<text:p>0.111565080074215</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A2];14)=ORG.LIBREOFFICE.ROUNDSIG([.B2];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A2];15)=ORG.LIBREOFFICE.ROUNDSIG([.B2];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A2])" office:value-type="string"
office:string-value="=CHISQDIST(3, 2, 0)" calcext:value-type="string">
@@ -2868,7 +2868,7 @@
<table:table-cell table:style-name="ce113" office:value-type="float"
office:value="0.77686983985157" calcext:value-type="float">
<text:p>0.77686983985157</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A3];14)=ORG.LIBREOFFICE.ROUNDSIG([.B3];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A3];15)=ORG.LIBREOFFICE.ROUNDSIG([.B3];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A3])" office:value-type="string"
office:string-value="=CHISQDIST(3, 2, 1)" calcext:value-type="string">
@@ -2901,7 +2901,7 @@
<table:table-cell office:value-type="float"
office:value="0.207553748710297" calcext:value-type="float">
<text:p>0.207553748710297</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A4];14)=ORG.LIBREOFFICE.ROUNDSIG([.B4];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A4];15)=ORG.LIBREOFFICE.ROUNDSIG([.B4];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A4])" office:value-type="string"
office:string-value="=CHISQDIST(2,3,0)" calcext:value-type="string">
@@ -2965,7 +2965,7 @@
<table:table-cell office:value-type="float" office:value="0"
calcext:value-type="float">
<text:p>0</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A6];14)=ORG.LIBREOFFICE.ROUNDSIG([.B6];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A6];15)=ORG.LIBREOFFICE.ROUNDSIG([.B6];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A6])" office:value-type="string"
office:string-value="=CHISQDIST(-2,3,0)" calcext:value-type="string">
@@ -3022,7 +3022,7 @@
<table:table-cell office:value-type="float"
office:value="0.42759329552912" calcext:value-type="float">
<text:p>0.42759329552912</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A8];14)=ORG.LIBREOFFICE.ROUNDSIG([.B8];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A8];15)=ORG.LIBREOFFICE.ROUNDSIG([.B8];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A8])" office:value-type="string"
office:string-value="=CHISQDIST(2,3,-7)" calcext:value-type="string">
@@ -3099,7 +3099,7 @@
<table:table-cell office:value-type="float"
office:value="0.103776874355149" calcext:value-type="float">
<text:p>0.103776874355149</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A11];14)=ORG.LIBREOFFICE.ROUNDSIG([.B11];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A11];15)=ORG.LIBREOFFICE.ROUNDSIG([.B11];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A11])" office:value-type="string"
office:string-value="=CHISQDIST(2, 1, 0)" calcext:value-type="string">
@@ -3121,7 +3121,7 @@
<table:table-cell office:value-type="float"
office:value="0.103776874355149" calcext:value-type="float">
<text:p>0.103776874355149</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A12];14)=ORG.LIBREOFFICE.ROUNDSIG([.B12];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A12];15)=ORG.LIBREOFFICE.ROUNDSIG([.B12];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A12])" office:value-type="string"
office:string-value="{=CHISQDIST(I1:I6,J1:J6,K1:K6)}"
calcext:value-type="string">
@@ -3145,7 +3145,7 @@
<table:table-cell office:value-type="float"
office:value="0.77686983985157" calcext:value-type="float">
<text:p>0.77686983985157</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A13];14)=ORG.LIBREOFFICE.ROUNDSIG([.B13];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A13];15)=ORG.LIBREOFFICE.ROUNDSIG([.B13];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A13])" office:value-type="string"
office:string-value="{=CHISQDIST(I1:I6,J1:J6,K1:K6)}"
calcext:value-type="string">
@@ -3169,7 +3169,7 @@
<table:table-cell office:value-type="float"
office:value="0.107981933026376" calcext:value-type="float">
<text:p>0.107981933026376</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A14];14)=ORG.LIBREOFFICE.ROUNDSIG([.B14];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A14];15)=ORG.LIBREOFFICE.ROUNDSIG([.B14];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A14])" office:value-type="string"
office:string-value="{=CHISQDIST(I1:I6,J1:J6,K1:K6)}"
calcext:value-type="string">
@@ -3192,7 +3192,7 @@
<table:table-cell office:value-type="float"
office:value="0.712702504816354" calcext:value-type="float">
<text:p>0.712702504816354</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A15];14)=ORG.LIBREOFFICE.ROUNDSIG([.B15];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A15];15)=ORG.LIBREOFFICE.ROUNDSIG([.B15];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A15])" office:value-type="string"
office:string-value="{=CHISQDIST(I1:I6,J1:J6,K1:K6)}"
calcext:value-type="string">
@@ -3214,7 +3214,7 @@
<table:table-cell office:value-type="float"
office:value="0.0973043466592829" calcext:value-type="float">
<text:p>0.097304346659283</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A16];14)=ORG.LIBREOFFICE.ROUNDSIG([.B16];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A16];15)=ORG.LIBREOFFICE.ROUNDSIG([.B16];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A16])" office:value-type="string"
office:string-value="{=CHISQDIST(I1:I6,J1:J6,K1:K6)}"
calcext:value-type="string">
@@ -3240,7 +3240,7 @@
<table:table-cell office:value-type="float"
office:value="0.679152801137866" calcext:value-type="float">
<text:p>0.679152801137866</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A17];14)=ORG.LIBREOFFICE.ROUNDSIG([.B17];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A17];15)=ORG.LIBREOFFICE.ROUNDSIG([.B17];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A17])" office:value-type="string"
office:string-value="{=CHISQDIST(I1:I6,J1:J6,K1:K6)}"
calcext:value-type="string">
@@ -3265,7 +3265,7 @@
<table:table-cell office:value-type="float" office:value="0"
calcext:value-type="float">
<text:p>0</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A18];14)=ORG.LIBREOFFICE.ROUNDSIG([.B18];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A18];15)=ORG.LIBREOFFICE.ROUNDSIG([.B18];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A18])" office:value-type="string"
office:string-value="=CHISQDIST(0,2)" calcext:value-type="string">
@@ -3290,7 +3290,7 @@
<table:table-cell office:value-type="float" office:value="0"
calcext:value-type="float">
<text:p>0</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A19];14)=ORG.LIBREOFFICE.ROUNDSIG([.B19];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A19];15)=ORG.LIBREOFFICE.ROUNDSIG([.B19];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A19])" office:value-type="string"
office:string-value="=CHISQDIST(0,2,FALSE())" calcext:value-type="string">
@@ -3312,7 +3312,7 @@
<table:table-cell office:value-type="float"
office:value="0.183939720585721" calcext:value-type="float">
<text:p>0.183939720585721</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A20];14)=ORG.LIBREOFFICE.ROUNDSIG([.B20];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A20];15)=ORG.LIBREOFFICE.ROUNDSIG([.B20];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A20])" office:value-type="string"
office:string-value="=CHISQDIST(2,2,FALSE())" calcext:value-type="string">
@@ -3334,7 +3334,7 @@
<table:table-cell office:value-type="float"
office:value="0.632120558828558" calcext:value-type="float">
<text:p>0.632120558828558</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A21];14)=ORG.LIBREOFFICE.ROUNDSIG([.B21];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A21];15)=ORG.LIBREOFFICE.ROUNDSIG([.B21];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A21])" office:value-type="string"
office:string-value="=CHISQDIST(2,2,TRUE())" calcext:value-type="string">
@@ -3356,7 +3356,7 @@
<table:table-cell office:value-type="float"
office:value="0.0676676416183064" calcext:value-type="float">
<text:p>0.067667641618306</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A22];14)=ORG.LIBREOFFICE.ROUNDSIG([.B22];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A22];15)=ORG.LIBREOFFICE.ROUNDSIG([.B22];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A22])" office:value-type="string"
office:string-value="=CHISQDIST(4,2,FALSE())" calcext:value-type="string">
@@ -3380,7 +3380,7 @@
<table:table-cell office:value-type="float"
office:value="0.864664716763387" calcext:value-type="float">
<text:p>0.864664716763387</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A23];14)=ORG.LIBREOFFICE.ROUNDSIG([.B23];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce117"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A23];15)=ORG.LIBREOFFICE.ROUNDSIG([.B23];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce124"
table:formula="of:=FORMULA([.A23])" office:value-type="string"
office:string-value="=CHISQDIST(4,2,TRUE())" calcext:value-type="string">
@@ -4023,4 +4023,4 @@
</table:named-expressions>
</office:spreadsheet>
</office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/chisqinv.fods
b/sc/qa/unit/data/functions/statistical/fods/chisqinv.fods
index 2046696ba246..4bb9cc65d9df 100644
--- a/sc/qa/unit/data/functions/statistical/fods/chisqinv.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/chisqinv.fods
@@ -3799,7 +3799,7 @@
<table:table-cell table:style-name="ce75" office:value-type="float"
office:value="3.28302028675954" calcext:value-type="float">
<text:p>3.28302028675954</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A2];14)=ORG.LIBREOFFICE.ROUNDSIG([.B2];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A2];15)=ORG.LIBREOFFICE.ROUNDSIG([.B2];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A2])" office:value-type="string"
office:string-value="=CHISQINV(0.93,1)" calcext:value-type="string">
@@ -3858,7 +3858,7 @@
<table:table-cell table:style-name="ce75" office:value-type="float"
office:value="1.83258146374831" calcext:value-type="float">
<text:p>1.83258146374831</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A3];14)=ORG.LIBREOFFICE.ROUNDSIG([.B3];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A3];15)=ORG.LIBREOFFICE.ROUNDSIG([.B3];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A3])" office:value-type="string"
office:string-value="=CHISQINV(0.6,2)" calcext:value-type="string">
@@ -3922,7 +3922,7 @@
<table:table-cell office:value-type="float"
office:value="4.53504966643008" calcext:value-type="float">
<text:p>4.53504966643008</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A4];14)=ORG.LIBREOFFICE.ROUNDSIG([.B4];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A4];15)=ORG.LIBREOFFICE.ROUNDSIG([.B4];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A4])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -3984,7 +3984,7 @@
<table:table-cell office:value-type="float"
office:value="5.40462670205885" calcext:value-type="float">
<text:p>5.40462670205885</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A5];14)=ORG.LIBREOFFICE.ROUNDSIG([.B5];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A5];15)=ORG.LIBREOFFICE.ROUNDSIG([.B5];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A5])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4042,7 +4042,7 @@
<table:table-cell office:value-type="float"
office:value="6.30379605958432" calcext:value-type="float">
<text:p>6.30379605958432</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A6];14)=ORG.LIBREOFFICE.ROUNDSIG([.B6];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A6];15)=ORG.LIBREOFFICE.ROUNDSIG([.B6];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A6])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4101,7 +4101,7 @@
<table:table-cell office:value-type="float"
office:value="7.22840922887967" calcext:value-type="float">
<text:p>7.22840922887967</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A7];14)=ORG.LIBREOFFICE.ROUNDSIG([.B7];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A7];15)=ORG.LIBREOFFICE.ROUNDSIG([.B7];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A7])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4160,7 +4160,7 @@
<table:table-cell office:value-type="float"
office:value="8.17520208558841" calcext:value-type="float">
<text:p>8.17520208558841</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A8];14)=ORG.LIBREOFFICE.ROUNDSIG([.B8];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A8];15)=ORG.LIBREOFFICE.ROUNDSIG([.B8];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A8])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4218,7 +4218,7 @@
<table:table-cell office:value-type="float"
office:value="9.14156135907027" calcext:value-type="float">
<text:p>9.14156135907027</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A9];14)=ORG.LIBREOFFICE.ROUNDSIG([.B9];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A9];15)=ORG.LIBREOFFICE.ROUNDSIG([.B9];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A9])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4276,7 +4276,7 @@
<table:table-cell office:value-type="float"
office:value="10.1253633400196" calcext:value-type="float">
<text:p>10.1253633400196</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A10];14)=ORG.LIBREOFFICE.ROUNDSIG([.B10];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A10];15)=ORG.LIBREOFFICE.ROUNDSIG([.B10];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A10])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4328,7 +4328,7 @@
<table:table-cell office:value-type="float"
office:value="11.1248597059224" calcext:value-type="float">
<text:p>11.1248597059224</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A11];14)=ORG.LIBREOFFICE.ROUNDSIG([.B11];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A11];15)=ORG.LIBREOFFICE.ROUNDSIG([.B11];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A11])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4373,7 +4373,7 @@
<table:table-cell office:value-type="float"
office:value="12.1385949123142" calcext:value-type="float">
<text:p>12.1385949123142</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A12];14)=ORG.LIBREOFFICE.ROUNDSIG([.B12];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A12];15)=ORG.LIBREOFFICE.ROUNDSIG([.B12];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A12])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4405,7 +4405,7 @@
<table:table-cell office:value-type="float"
office:value="13.1653452479781" calcext:value-type="float">
<text:p>13.1653452479781</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A13];14)=ORG.LIBREOFFICE.ROUNDSIG([.B13];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A13];15)=ORG.LIBREOFFICE.ROUNDSIG([.B13];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A13])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4436,7 +4436,7 @@
<table:table-cell office:value-type="float"
office:value="14.2040730851385" calcext:value-type="float">
<text:p>14.2040730851385</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A14];14)=ORG.LIBREOFFICE.ROUNDSIG([.B14];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A14];15)=ORG.LIBREOFFICE.ROUNDSIG([.B14];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A14])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4467,7 +4467,7 @@
<table:table-cell office:value-type="float"
office:value="3.07008840528929" calcext:value-type="float">
<text:p>3.07008840528929</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A15];14)=ORG.LIBREOFFICE.ROUNDSIG([.B15];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A15];15)=ORG.LIBREOFFICE.ROUNDSIG([.B15];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A15])" office:value-type="string"
office:string-value="{=CHISQINV(L3:L9,M3:M9)}" calcext:value-type="string">
@@ -4501,7 +4501,7 @@
<table:table-cell office:value-type="float"
office:value="2.99990813275991" calcext:value-type="float">
<text:p>2.99990813275991</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A16];14)=ORG.LIBREOFFICE.ROUNDSIG([.B16];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A16];15)=ORG.LIBREOFFICE.ROUNDSIG([.B16];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A16])" office:value-type="string"
office:string-value="{=CHISQINV(L3:L9,M3:M9)}" calcext:value-type="string">
@@ -4527,7 +4527,7 @@
<table:table-cell office:value-type="float"
office:value="9.23728542384152" calcext:value-type="float">
<text:p>9.23728542384152</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A17];14)=ORG.LIBREOFFICE.ROUNDSIG([.B17];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A17];15)=ORG.LIBREOFFICE.ROUNDSIG([.B17];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A17])" office:value-type="string"
office:string-value="{=CHISQINV(L3:L9,M3:M9)}" calcext:value-type="string">
@@ -4553,7 +4553,7 @@
<table:table-cell office:value-type="float"
office:value="6.34581119552152" calcext:value-type="float">
<text:p>6.34581119552152</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A18];14)=ORG.LIBREOFFICE.ROUNDSIG([.B18];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A18];15)=ORG.LIBREOFFICE.ROUNDSIG([.B18];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A18])" office:value-type="string"
office:string-value="{=CHISQINV(L3:L9,M3:M9)}" calcext:value-type="string">
@@ -4581,7 +4581,7 @@
<table:table-cell office:value-type="float"
office:value="5.13186707440182" calcext:value-type="float">
<text:p>5.13186707440182</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A19];14)=ORG.LIBREOFFICE.ROUNDSIG([.B19];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A19];15)=ORG.LIBREOFFICE.ROUNDSIG([.B19];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A19])" office:value-type="string"
office:string-value="{=CHISQINV(L3:L9,M3:M9)}" calcext:value-type="string">
@@ -4607,7 +4607,7 @@
<table:table-cell office:value-type="float"
office:value="4.87843296656041" calcext:value-type="float">
<text:p>4.87843296656041</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A20];14)=ORG.LIBREOFFICE.ROUNDSIG([.B20];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A20];15)=ORG.LIBREOFFICE.ROUNDSIG([.B20];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A20])" office:value-type="string"
office:string-value="{=CHISQINV(L3:L9,M3:M9)}" calcext:value-type="string">
@@ -4633,7 +4633,7 @@
<table:table-cell office:value-type="float"
office:value="5.98861669400425" calcext:value-type="float">
<text:p>5.98861669400425</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A21];14)=ORG.LIBREOFFICE.ROUNDSIG([.B21];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A21];15)=ORG.LIBREOFFICE.ROUNDSIG([.B21];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A21])" office:value-type="string"
office:string-value="{=CHISQINV(L3:L9,M3:M9)}" calcext:value-type="string">
@@ -4659,7 +4659,7 @@
<table:table-cell office:value-type="float"
office:value="0.981793008255829" calcext:value-type="float">
<text:p>0.981793008255829</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A22];14)=ORG.LIBREOFFICE.ROUNDSIG([.B22];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A22];15)=ORG.LIBREOFFICE.ROUNDSIG([.B22];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A22])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4685,7 +4685,7 @@
<table:table-cell office:value-type="float"
office:value="2.75660369088146" calcext:value-type="float">
<text:p>2.75660369088146</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A23];14)=ORG.LIBREOFFICE.ROUNDSIG([.B23];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A23];15)=ORG.LIBREOFFICE.ROUNDSIG([.B23];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A23])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4711,7 +4711,7 @@
<table:table-cell office:value-type="float"
office:value="2.1113261237018" calcext:value-type="float">
<text:p>2.1113261237018</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A24];14)=ORG.LIBREOFFICE.ROUNDSIG([.B24];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A24];15)=ORG.LIBREOFFICE.ROUNDSIG([.B24];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A24])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4737,7 +4737,7 @@
<table:table-cell office:value-type="float"
office:value="2.0764999935322" calcext:value-type="float">
<text:p>2.0764999935322</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A25];14)=ORG.LIBREOFFICE.ROUNDSIG([.B25];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A25];15)=ORG.LIBREOFFICE.ROUNDSIG([.B25];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A25])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4763,7 +4763,7 @@
<table:table-cell office:value-type="float"
office:value="5.01515445024952" calcext:value-type="float">
<text:p>5.01515445024952</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A26];14)=ORG.LIBREOFFICE.ROUNDSIG([.B26];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A26];15)=ORG.LIBREOFFICE.ROUNDSIG([.B26];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A26])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4789,7 +4789,7 @@
<table:table-cell office:value-type="float"
office:value="15.2911628705065" calcext:value-type="float">
<text:p>15.2911628705065</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A27];14)=ORG.LIBREOFFICE.ROUNDSIG([.B27];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A27];15)=ORG.LIBREOFFICE.ROUNDSIG([.B27];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A27])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4815,7 +4815,7 @@
<table:table-cell office:value-type="float"
office:value="20.4461298047275" calcext:value-type="float">
<text:p>20.4461298047275</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A28];14)=ORG.LIBREOFFICE.ROUNDSIG([.B28];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A28];15)=ORG.LIBREOFFICE.ROUNDSIG([.B28];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A28])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4841,7 +4841,7 @@
<table:table-cell office:value-type="float"
office:value="16.3884014923503" calcext:value-type="float">
<text:p>16.3884014923503</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A29];14)=ORG.LIBREOFFICE.ROUNDSIG([.B29];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A29];15)=ORG.LIBREOFFICE.ROUNDSIG([.B29];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A29])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4867,7 +4867,7 @@
<table:table-cell office:value-type="float"
office:value="13.3824533053927" calcext:value-type="float">
<text:p>13.3824533053927</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A30];14)=ORG.LIBREOFFICE.ROUNDSIG([.B30];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A30];15)=ORG.LIBREOFFICE.ROUNDSIG([.B30];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A30])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4893,7 +4893,7 @@
<table:table-cell office:value-type="float"
office:value="7.91959455051006" calcext:value-type="float">
<text:p>7.91959455051006</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A31];14)=ORG.LIBREOFFICE.ROUNDSIG([.B31];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A31];15)=ORG.LIBREOFFICE.ROUNDSIG([.B31];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A31])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4919,7 +4919,7 @@
<table:table-cell office:value-type="float"
office:value="15.6557151216055" calcext:value-type="float">
<text:p>15.6557151216055</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A32];14)=ORG.LIBREOFFICE.ROUNDSIG([.B32];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A32];15)=ORG.LIBREOFFICE.ROUNDSIG([.B32];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A32])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4945,7 +4945,7 @@
<table:table-cell office:value-type="float"
office:value="24.5318147689017" calcext:value-type="float">
<text:p>24.5318147689017</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A33];14)=ORG.LIBREOFFICE.ROUNDSIG([.B33];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A33];15)=ORG.LIBREOFFICE.ROUNDSIG([.B33];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A33])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4971,7 +4971,7 @@
<table:table-cell office:value-type="float"
office:value="9.94221245771641" calcext:value-type="float">
<text:p>9.94221245771641</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A34];14)=ORG.LIBREOFFICE.ROUNDSIG([.B34];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A34];15)=ORG.LIBREOFFICE.ROUNDSIG([.B34];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A34])" office:value-type="string"
office:string-value="{=CHISQINV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4997,7 +4997,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0" calcext:value-type="float">
<text:p>0.000000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A35];14)=ORG.LIBREOFFICE.ROUNDSIG([.B35];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A35];15)=ORG.LIBREOFFICE.ROUNDSIG([.B35];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A35])" office:value-type="string"
office:string-value="=CHISQINV(0,1)" calcext:value-type="string">
@@ -5049,7 +5049,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.454936423119572" calcext:value-type="float">
<text:p>0.454936</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A37];14)=ORG.LIBREOFFICE.ROUNDSIG([.B37];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A37];15)=ORG.LIBREOFFICE.ROUNDSIG([.B37];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A37])" office:value-type="string"
office:string-value="=CHISQINV(0.5,1)" calcext:value-type="string">
@@ -5075,7 +5075,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.0157907740934312" calcext:value-type="float">
<text:p>0.015791</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A38];14)=ORG.LIBREOFFICE.ROUNDSIG([.B38];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A38];15)=ORG.LIBREOFFICE.ROUNDSIG([.B38];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A38])" office:value-type="string"
office:string-value="=CHISQINV(0.1,1.1)" calcext:value-type="string">
@@ -5129,7 +5129,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.010086932215776" calcext:value-type="float">
<text:p>0.010087</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A40];14)=ORG.LIBREOFFICE.ROUNDSIG([.B40];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A40];15)=ORG.LIBREOFFICE.ROUNDSIG([.B40];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A40])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5155,7 +5155,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.188621358942483" calcext:value-type="float">
<text:p>0.188621</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A41];14)=ORG.LIBREOFFICE.ROUNDSIG([.B41];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A41];15)=ORG.LIBREOFFICE.ROUNDSIG([.B41];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A41])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5181,7 +5181,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.584374374155183" calcext:value-type="float">
<text:p>0.584374</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A42];14)=ORG.LIBREOFFICE.ROUNDSIG([.B42];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A42];15)=ORG.LIBREOFFICE.ROUNDSIG([.B42];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A42])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5207,7 +5207,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="1.1267819797945" calcext:value-type="float">
<text:p>1.126782</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A43];14)=ORG.LIBREOFFICE.ROUNDSIG([.B43];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A43];15)=ORG.LIBREOFFICE.ROUNDSIG([.B43];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A43])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5233,7 +5233,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="1.76973389560269" calcext:value-type="float">
<text:p>1.769734</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A44];14)=ORG.LIBREOFFICE.ROUNDSIG([.B44];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A44];15)=ORG.LIBREOFFICE.ROUNDSIG([.B44];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A44])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5259,7 +5259,7 @@
<table:table-cell office:value-type="float"
office:value="2.48627982968339" calcext:value-type="float">
<text:p>2.48627982968339</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A45];14)=ORG.LIBREOFFICE.ROUNDSIG([.B45];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A45];15)=ORG.LIBREOFFICE.ROUNDSIG([.B45];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A45])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5285,7 +5285,7 @@
<table:table-cell office:value-type="float"
office:value="3.25953870534247" calcext:value-type="float">
<text:p>3.25953870534247</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A46];14)=ORG.LIBREOFFICE.ROUNDSIG([.B46];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A46];15)=ORG.LIBREOFFICE.ROUNDSIG([.B46];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A46])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5311,7 +5311,7 @@
<table:table-cell office:value-type="float"
office:value="4.07819909611163" calcext:value-type="float">
<text:p>4.07819909611163</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A47];14)=ORG.LIBREOFFICE.ROUNDSIG([.B47];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A47];15)=ORG.LIBREOFFICE.ROUNDSIG([.B47];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A47])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5337,7 +5337,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="4.93427041996151" calcext:value-type="float">
<text:p>4.934270</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A48];14)=ORG.LIBREOFFICE.ROUNDSIG([.B48];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A48];15)=ORG.LIBREOFFICE.ROUNDSIG([.B48];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A48])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5363,7 +5363,7 @@
<table:table-cell office:value-type="float"
office:value="5.8218731997855" calcext:value-type="float">
<text:p>5.8218731997855</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A49];14)=ORG.LIBREOFFICE.ROUNDSIG([.B49];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A49];15)=ORG.LIBREOFFICE.ROUNDSIG([.B49];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A49])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5389,7 +5389,7 @@
<table:table-cell office:value-type="float"
office:value="6.73654101450682" calcext:value-type="float">
<text:p>6.73654101450682</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A50];14)=ORG.LIBREOFFICE.ROUNDSIG([.B50];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A50];15)=ORG.LIBREOFFICE.ROUNDSIG([.B50];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A50])" office:value-type="string"
office:string-value="{=CHISQINV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5441,7 +5441,7 @@
<table:table-cell office:value-type="float" office:value="0.1"
calcext:value-type="float">
<text:p>0.1</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A52];14)=ORG.LIBREOFFICE.ROUNDSIG([.B52];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A52];15)=ORG.LIBREOFFICE.ROUNDSIG([.B52];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A52])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.1,3),3,TRUE() )"
calcext:value-type="string">
@@ -5465,7 +5465,7 @@
<table:table-cell office:value-type="float" office:value="0.3"
calcext:value-type="float">
<text:p>0.3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A53];14)=ORG.LIBREOFFICE.ROUNDSIG([.B53];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A53];15)=ORG.LIBREOFFICE.ROUNDSIG([.B53];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A53])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.3,3),3,TRUE())"
calcext:value-type="string">
@@ -5489,7 +5489,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.5" calcext:value-type="float">
<text:p>0.500000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A54];14)=ORG.LIBREOFFICE.ROUNDSIG([.B54];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A54];15)=ORG.LIBREOFFICE.ROUNDSIG([.B54];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A54])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.5,3),3,TRUE())"
calcext:value-type="string">
@@ -5513,7 +5513,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.7" calcext:value-type="float">
<text:p>0.700000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A55];14)=ORG.LIBREOFFICE.ROUNDSIG([.B55];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A55];15)=ORG.LIBREOFFICE.ROUNDSIG([.B55];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A55])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.7,3),3,TRUE())"
calcext:value-type="string">
@@ -5537,7 +5537,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.9" calcext:value-type="float">
<text:p>0.900000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A56];14)=ORG.LIBREOFFICE.ROUNDSIG([.B56];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A56];15)=ORG.LIBREOFFICE.ROUNDSIG([.B56];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A56])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.9,3),3,TRUE())"
calcext:value-type="string">
@@ -5561,7 +5561,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.0999999999999997" calcext:value-type="float">
<text:p>0.100000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A57];14)=ORG.LIBREOFFICE.ROUNDSIG([.B57];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A57];15)=ORG.LIBREOFFICE.ROUNDSIG([.B57];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A57])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.1,20),20,TRUE())"
calcext:value-type="string">
@@ -5585,7 +5585,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.299999999999999" calcext:value-type="float">
<text:p>0.300000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A58];14)=ORG.LIBREOFFICE.ROUNDSIG([.B58];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A58];15)=ORG.LIBREOFFICE.ROUNDSIG([.B58];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A58])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.3,20),20,TRUE())"
calcext:value-type="string">
@@ -5607,7 +5607,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.500000000000001" calcext:value-type="float">
<text:p>0.500000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A59];14)=ORG.LIBREOFFICE.ROUNDSIG([.B59];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A59];15)=ORG.LIBREOFFICE.ROUNDSIG([.B59];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A59])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.5,20),20,TRUE())"
calcext:value-type="string">
@@ -5629,7 +5629,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.7" calcext:value-type="float">
<text:p>0.700000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A60];14)=ORG.LIBREOFFICE.ROUNDSIG([.B60];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A60];15)=ORG.LIBREOFFICE.ROUNDSIG([.B60];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A60])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.7,20),20,TRUE())"
calcext:value-type="string">
@@ -5651,7 +5651,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0.9" calcext:value-type="float">
<text:p>0.900000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A61];14)=ORG.LIBREOFFICE.ROUNDSIG([.B61];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A61];15)=ORG.LIBREOFFICE.ROUNDSIG([.B61];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A61])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0.9,20),20,TRUE())"
calcext:value-type="string">
@@ -5673,7 +5673,7 @@
<table:table-cell table:style-name="ce79" office:value-type="float"
office:value="0" calcext:value-type="float">
<text:p>0.000000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A62];14)=ORG.LIBREOFFICE.ROUNDSIG([.B62];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce80"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A62];15)=ORG.LIBREOFFICE.ROUNDSIG([.B62];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce83"
table:formula="of:=FORMULA([.A62])" office:value-type="string"
office:string-value="=CHISQDIST(CHISQINV(0,20),20,TRUE())"
calcext:value-type="string">
@@ -6047,4 +6047,4 @@
</table:named-expressions>
</office:spreadsheet>
</office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/chitest.fods
b/sc/qa/unit/data/functions/statistical/fods/chitest.fods
index 62e3ab0f53b3..67f803af72ee 100644
--- a/sc/qa/unit/data/functions/statistical/fods/chitest.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/chitest.fods
@@ -3803,7 +3803,7 @@
<table:table-cell table:style-name="ce19" office:value-type="float"
office:value="1.16440189336067E-029" calcext:value-type="float">
<text:p>1.16440189336067E-29</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A2];14)=ORG.LIBREOFFICE.ROUNDSIG([.B2];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A2];15)=ORG.LIBREOFFICE.ROUNDSIG([.B2];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A2])" office:value-type="string"
office:string-value="=CHITEST(F1:F11,G1:G11)" calcext:value-type="string">
@@ -3866,7 +3866,7 @@
<table:table-cell table:style-name="ce19" office:value-type="float"
office:value="0.000000000903490480352966" calcext:value-type="float">
<text:p>9.03490480352966E-10</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A3];14)=ORG.LIBREOFFICE.ROUNDSIG([.B3];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A3];15)=ORG.LIBREOFFICE.ROUNDSIG([.B3];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A3])" office:value-type="string"
office:string-value="=CHITEST(F1:F11,H1:H11)" calcext:value-type="string">
@@ -3934,7 +3934,7 @@
<table:table-cell office:value-type="float"
office:value="0.00000000134423459890025" calcext:value-type="float">
<text:p>1.34423459890025E-09</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A4];14)=ORG.LIBREOFFICE.ROUNDSIG([.B4];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A4];15)=ORG.LIBREOFFICE.ROUNDSIG([.B4];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A4])" office:value-type="string"
office:string-value="=CHITEST(H1:H11,G1:G11)" calcext:value-type="string">
@@ -4000,7 +4000,7 @@
<table:table-cell office:value-type="float" office:value="0"
calcext:value-type="float">
<text:p>0</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A5];14)=ORG.LIBREOFFICE.ROUNDSIG([.B5];14)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce54"
table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A5];15)=ORG.LIBREOFFICE.ROUNDSIG([.B5];15)"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
... etc. - the rest is truncated
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
