diff options
| -rw-r--r-- | sal/rtl/math.cxx | 3 | ||||
| -rw-r--r-- | sc/qa/unit/data/functions/mathematical/fods/round.fods | 45 | ||||
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/chisq.test.fods | 50 | ||||
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/chisqdist.fods | 40 | ||||
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/chisqinv.fods | 118 | ||||
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/chitest.fods | 50 | ||||
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/stdevpa.fods | 28 | ||||
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/t.dist.rt.fods | 66 | ||||
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/tinv.fods | 60 |
9 files changed, 243 insertions, 217 deletions
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> <table:table-cell table:style-name="ce32" table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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="=CHITEST(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:=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="ce54" 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="ce32" table:formula="of:=FORMULA([.A24])" office:value-type="string" office:string-value="=CHITEST(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:=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="ce54" 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="ce32" table:formula="of:=FORMULA([.A26])" office:value-type="string" office:string-value="=CHITEST(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:=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="ce54" 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="ce32" table:formula="of:=FORMULA([.A28])" office:value-type="string" office:string-value="=CHITEST(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/stdevpa.fods b/sc/qa/unit/data/functions/statistical/fods/stdevpa.fods index e0b43c6bef11..825f7b1961c6 100644 --- a/sc/qa/unit/data/functions/statistical/fods/stdevpa.fods +++ b/sc/qa/unit/data/functions/statistical/fods/stdevpa.fods @@ -3674,7 +3674,7 @@ <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1.63299316185545" calcext:value-type="float"> <text:p>1.63299316185545</text:p> </table:table-cell> - <table:table-cell table:style-name="ce39" 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="ce39" 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="=STDEVPA(2, 6, 4)" calcext:value-type="string"> @@ -3728,7 +3728,7 @@ <table:table-cell office:value-type="float" office:value="4.04972501741921" calcext:value-type="float"> <text:p>4.04972501741921</text:p> </table:table-cell> - <table:table-cell table:style-name="ce39" 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="ce39" 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="=STDEVPA(F1:G14)" calcext:value-type="string"> @@ -3790,7 +3790,7 @@ <table:table-cell table:style-name="ce19" office:value-type="float" office:value="58.506579065081" calcext:value-type="float"> <text:p>58.506579065081</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA(I3:J101)" calcext:value-type="string"> @@ -3849,7 +3849,7 @@ <table:table-cell table:style-name="ce19" office:value-type="float" office:value="2.63899331455874" calcext:value-type="float"> <text:p>2.63899331455874</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA(L3:M9)" calcext:value-type="string"> @@ -3908,7 +3908,7 @@ <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1.41774468787578" calcext:value-type="float"> <text:p>1.41774468787578</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA(O2:O11)" calcext:value-type="string"> @@ -3967,7 +3967,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="ce28" 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="ce28" 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="=STDEVPA(F1)" calcext:value-type="string"> @@ -4026,7 +4026,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="ce28" 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="ce28" 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="=STDEVPA(H1:H3)" calcext:value-type="string"> @@ -4085,7 +4085,7 @@ <table:table-cell office:value-type="float" office:value="0.816496580927726" calcext:value-type="float"> <text:p>0.816496580927726</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA("red",1,2)" calcext:value-type="string"> @@ -4139,7 +4139,7 @@ <table:table-cell table:style-name="ce19" office:value-type="float" office:value="26.0545581424825" calcext:value-type="float"> <text:p>26.0545581424825</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA(P3:P12)" calcext:value-type="string"> @@ -4187,7 +4187,7 @@ <table:table-cell office:value-type="float" office:value="7.17538356723097" calcext:value-type="float"> <text:p>7.17538356723097</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA(F14:G15)" calcext:value-type="string"> @@ -4233,7 +4233,7 @@ <table:table-cell office:value-type="float" office:value="14.6711451495785" calcext:value-type="float"> <text:p>14.6711451495785</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA(34.5, 2, 8.9, -4)" calcext:value-type="string"> @@ -4271,7 +4271,7 @@ <table:table-cell office:value-type="float" office:value="0.707106781186548" calcext:value-type="float"> <text:p>0.707106781186548</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA("red",1,2,F18)" calcext:value-type="string"> @@ -4306,7 +4306,7 @@ <table:table-cell office:value-type="float" office:value="2.63899331455874" calcext:value-type="float"> <text:p>2.63899331455874</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=STDEVPA(range)" calcext:value-type="string"> @@ -6626,4 +6626,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/t.dist.rt.fods b/sc/qa/unit/data/functions/statistical/fods/t.dist.rt.fods index 4993d024932d..889a95d0f528 100644 --- a/sc/qa/unit/data/functions/statistical/fods/t.dist.rt.fods +++ b/sc/qa/unit/data/functions/statistical/fods/t.dist.rt.fods @@ -3806,7 +3806,7 @@ <table:table-cell table:style-name="ce19" office:value-type="float" office:value="0.17044656615103" calcext:value-type="float"> <text:p>0.17044656615103</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" 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="ce42" 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="=T.DIST.RT(1, 10)" calcext:value-type="string"> @@ -3853,7 +3853,7 @@ <table:table-cell table:style-name="ce19" office:value-type="float" office:value="0.17044656615103" calcext:value-type="float"> <text:p>0.17044656615103</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" 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="ce42" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -3901,7 +3901,7 @@ <table:table-cell office:value-type="float" office:value="0.0354019775340173" calcext:value-type="float"> <text:p>0.035401977534017</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -3945,7 +3945,7 @@ <table:table-cell office:value-type="float" office:value="0.00553334784301685" calcext:value-type="float"> <text:p>0.005533347843017</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -3991,7 +3991,7 @@ <table:table-cell office:value-type="float" office:value="0.000756039679405987" calcext:value-type="float"> <text:p>0.000756039679406</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4035,7 +4035,7 @@ <table:table-cell office:value-type="float" office:value="0.000097257653128633" calcext:value-type="float"> <text:p>9.7257653128633E-05</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4078,7 +4078,7 @@ <table:table-cell office:value-type="float" office:value="0.0000121632727555193" calcext:value-type="float"> <text:p>1.21632727555193E-05</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4122,7 +4122,7 @@ <table:table-cell office:value-type="float" office:value="0.00000149794463195888" calcext:value-type="float"> <text:p>1.49794463195888E-06</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4165,7 +4165,7 @@ <table:table-cell office:value-type="float" office:value="0.000000182496662157233" calcext:value-type="float"> <text:p>1.82496662157233E-07</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4201,7 +4201,7 @@ <table:table-cell office:value-type="float" office:value="0.0000000220213936459103" calcext:value-type="float"> <text:p>2.20213936459103E-08</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4238,7 +4238,7 @@ <table:table-cell office:value-type="float" office:value="0.00000000263151308116795" calcext:value-type="float"> <text:p>2.63151308116795E-09</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4262,7 +4262,7 @@ <table:table-cell office:value-type="float" office:value="0.00000000031123250806477" calcext:value-type="float"> <text:p>3.1123250806477E-10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="{=T.DIST.RT(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4284,7 +4284,7 @@ <table:table-cell office:value-type="float" office:value="0.25" calcext:value-type="float"> <text:p>0.25</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=T.DIST.RT(F1,H1)" calcext:value-type="string"> @@ -4306,7 +4306,7 @@ <table:table-cell office:value-type="float" office:value="0.091751709536137" calcext:value-type="float"> <text:p>0.091751709536137</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=T.DIST.RT(F2,H2)" calcext:value-type="string"> @@ -4338,7 +4338,7 @@ <table:table-cell office:value-type="float" office:value="0.0288344428112187" calcext:value-type="float"> <text:p>0.028834442811219</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=T.DIST.RT(F3,H3)" calcext:value-type="string"> @@ -4362,7 +4362,7 @@ <table:table-cell office:value-type="float" office:value="0.00806504495004626" calcext:value-type="float"> <text:p>0.008065044950046</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=T.DIST.RT(F4,H4)" calcext:value-type="string"> @@ -4386,7 +4386,7 @@ <table:table-cell office:value-type="float" office:value="0.00205235799002666" calcext:value-type="float"> <text:p>0.002052357990027</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=T.DIST.RT(F5,H5)" calcext:value-type="string"> @@ -4412,7 +4412,7 @@ <table:table-cell office:value-type="float" office:value="0.000482267597207565" calcext:value-type="float"> <text:p>0.000482267597208</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=T.DIST.RT(F6,H6)" calcext:value-type="string"> @@ -4433,8 +4433,8 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.T.DIST.RT([.F7];[.H7])" office:value-type="float" office:value="0.000105777425972937" calcext:value-type="float"> <text:p>0.000105777425973</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0.000105777425972937" calcext:value-type="float"> - <text:p>0.000105777425973</text:p> + <table:table-cell office:value-type="float" office:value="0.00010577742597293646" calcext:value-type="float"> + <text:p>0.0001057774259772936</text:p> </table:table-cell> <table:table-cell table:style-name="ce28" 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"> <text:p>TRUE</text:p> @@ -4460,7 +4460,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="ce28" 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="ce28" 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="=T.DIST.RT(F15,G15)" calcext:value-type="string"> @@ -4484,7 +4484,7 @@ <table:table-cell office:value-type="float" office:value="0.000486711984884764" calcext:value-type="float"> <text:p>0.000486711984885</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="=T.DIST.RT(G15,H15)" calcext:value-type="string"> @@ -4508,7 +4508,7 @@ <table:table-cell office:value-type="float" office:value="0.0462131557658376" calcext:value-type="float"> <text:p>0.046213155765838</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A23])" office:value-type="string" office:string-value="{=T.DIST.RT(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4532,7 +4532,7 @@ <table:table-cell office:value-type="float" office:value="0.0150496239487313" calcext:value-type="float"> <text:p>0.015049623948731</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A24])" office:value-type="string" office:string-value="{=T.DIST.RT(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4556,7 +4556,7 @@ <table:table-cell office:value-type="float" office:value="0.00000104807918350441" calcext:value-type="float"> <text:p>1.04807918350441E-06</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A25])" office:value-type="string" office:string-value="{=T.DIST.RT(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4580,7 +4580,7 @@ <table:table-cell office:value-type="float" office:value="0.175308331410104" calcext:value-type="float"> <text:p>0.175308331410104</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A26])" office:value-type="string" office:string-value="{=T.DIST.RT(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4604,7 +4604,7 @@ <table:table-cell office:value-type="float" office:value="0.000246453330286222" calcext:value-type="float"> <text:p>0.000246453330286</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A27])" office:value-type="string" office:string-value="{=T.DIST.RT(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4628,7 +4628,7 @@ <table:table-cell office:value-type="float" office:value="0.00109606490334647" calcext:value-type="float"> <text:p>0.001096064903346</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A28])" office:value-type="string" office:string-value="{=T.DIST.RT(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4652,7 +4652,7 @@ <table:table-cell office:value-type="float" office:value="0.00374521694063726" calcext:value-type="float"> <text:p>0.003745216940637</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A29])" office:value-type="string" office:string-value="{=T.DIST.RT(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4700,7 +4700,7 @@ <table:table-cell office:value-type="float" office:value="0.5" calcext:value-type="float"> <text:p>0.5</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A31])" office:value-type="string" office:string-value="=T.DIST.RT(0,9)" calcext:value-type="string"> @@ -4724,7 +4724,7 @@ <table:table-cell office:value-type="float" office:value="0.828281801931043" calcext:value-type="float"> <text:p>0.828281801931043</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A32])" office:value-type="string" office:string-value="=T.DIST.RT(-1,9)" calcext:value-type="string"> @@ -4748,7 +4748,7 @@ <table:table-cell office:value-type="float" office:value="0.0273224649879605" calcext:value-type="float"> <text:p>0.027322464987961</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" 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="ce28" 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="ce32" table:formula="of:=FORMULA([.A33])" office:value-type="string" office:string-value="=T.DIST.RT(O2,O3)" calcext:value-type="string"> @@ -5288,4 +5288,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/tinv.fods b/sc/qa/unit/data/functions/statistical/fods/tinv.fods index 31c9cbebf555..89832a2a16c3 100644 --- a/sc/qa/unit/data/functions/statistical/fods/tinv.fods +++ b/sc/qa/unit/data/functions/statistical/fods/tinv.fods @@ -3766,7 +3766,7 @@ <table:table-cell table:style-name="ce75" 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="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=TINV(1, 10)" calcext:value-type="string"> @@ -3815,7 +3815,7 @@ <table:table-cell table:style-name="ce75" office:value-type="float" office:value="1.81246112281168" calcext:value-type="float"> <text:p>1.81246112281168</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -3863,7 +3863,7 @@ <table:table-cell office:value-type="float" office:value="1.54755976627494" calcext:value-type="float"> <text:p>1.54755976627494</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -3907,7 +3907,7 @@ <table:table-cell office:value-type="float" office:value="1.35621733402321" calcext:value-type="float"> <text:p>1.35621733402321</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -3953,7 +3953,7 @@ <table:table-cell office:value-type="float" office:value="1.20414624166526" calcext:value-type="float"> <text:p>1.20414624166526</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -3997,7 +3997,7 @@ <table:table-cell office:value-type="float" office:value="1.07628024458382" calcext:value-type="float"> <text:p>1.07628024458382</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4040,7 +4040,7 @@ <table:table-cell office:value-type="float" office:value="0.964682373011799" calcext:value-type="float"> <text:p>0.964682373011799</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4084,7 +4084,7 @@ <table:table-cell office:value-type="float" office:value="0.864667001798292" calcext:value-type="float"> <text:p>0.864667001798292</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4163,7 +4163,7 @@ <table:table-cell office:value-type="float" office:value="0.688363806466199" calcext:value-type="float"> <text:p>0.688363806466199</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4200,7 +4200,7 @@ <table:table-cell office:value-type="float" office:value="0.608595649161802" calcext:value-type="float"> <text:p>0.608595649161802</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4224,7 +4224,7 @@ <table:table-cell office:value-type="float" office:value="0.532862791616333" calcext:value-type="float"> <text:p>0.532862791616333</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="{=TINV(F1:F11,G1:G11)}" calcext:value-type="string"> @@ -4246,7 +4246,7 @@ <table:table-cell office:value-type="float" office:value="6.31375151467504" calcext:value-type="float"> <text:p>6.31375151467504</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=TINV(F1,H1)" calcext:value-type="string"> @@ -4268,7 +4268,7 @@ <table:table-cell office:value-type="float" office:value="2.28193058772768" calcext:value-type="float"> <text:p>2.28193058772768</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="=TINV(F2,H2)" calcext:value-type="string"> @@ -4300,7 +4300,7 @@ <table:table-cell office:value-type="float" office:value="1.63774435369621" calcext:value-type="float"> <text:p>1.63774435369621</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A16])" office:value-type="string" office:string-value="=TINV(F3,H3)" calcext:value-type="string"> @@ -4324,7 +4324,7 @@ <table:table-cell office:value-type="float" office:value="1.34439755550909" calcext:value-type="float"> <text:p>1.34439755550909</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A17])" office:value-type="string" office:string-value="=TINV(F4,H4)" calcext:value-type="string"> @@ -4348,7 +4348,7 @@ <table:table-cell office:value-type="float" office:value="1.15576734289429" calcext:value-type="float"> <text:p>1.15576734289429</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=TINV(F5,H5)" calcext:value-type="string"> @@ -4398,7 +4398,7 @@ <table:table-cell office:value-type="float" office:value="0.896029644313764" calcext:value-type="float"> <text:p>0.896029644313764</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A20])" office:value-type="string" office:string-value="=TINV(F7,H7)" calcext:value-type="string"> @@ -4422,7 +4422,7 @@ <table:table-cell office:value-type="float" office:value="0.125944078921444" calcext:value-type="float"> <text:p>0.125944078921444</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="=TINV(F15,G15)" calcext:value-type="string"> @@ -4446,7 +4446,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="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A22])" office:value-type="string" office:string-value="=TINV(H15,G15)" calcext:value-type="string"> @@ -4470,7 +4470,7 @@ <table:table-cell office:value-type="float" office:value="1.36163241825017" calcext:value-type="float"> <text:p>1.36163241825017</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A23])" office:value-type="string" office:string-value="{=TINV(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4494,7 +4494,7 @@ <table:table-cell office:value-type="float" office:value="1.070480073011" calcext:value-type="float"> <text:p>1.070480073011</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A24])" office:value-type="string" office:string-value="{=TINV(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4518,7 +4518,7 @@ <table:table-cell office:value-type="float" office:value="0.793181382641255" calcext:value-type="float"> <text:p>0.793181382641255</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A25])" office:value-type="string" office:string-value="{=TINV(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4542,7 +4542,7 @@ <table:table-cell office:value-type="float" office:value="0.618938866571943" calcext:value-type="float"> <text:p>0.618938866571943</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A26])" office:value-type="string" office:string-value="{=TINV(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4566,7 +4566,7 @@ <table:table-cell office:value-type="float" office:value="0.457258216476513" calcext:value-type="float"> <text:p>0.457258216476513</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A27])" office:value-type="string" office:string-value="{=TINV(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4590,7 +4590,7 @@ <table:table-cell office:value-type="float" office:value="0.301894783862139" calcext:value-type="float"> <text:p>0.301894783862139</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A28])" office:value-type="string" office:string-value="{=TINV(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4614,7 +4614,7 @@ <table:table-cell office:value-type="float" office:value="0.148831111963765" calcext:value-type="float"> <text:p>0.148831111963765</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A29])" office:value-type="string" office:string-value="{=TINV(L3:L9,M3:M9)}" calcext:value-type="string"> @@ -4734,7 +4734,7 @@ <table:table-cell office:value-type="float" office:value="1.9431802805153" calcext:value-type="float"> <text:p>1.9431802805153</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A34])" office:value-type="string" office:string-value="=TINV(0.1,6)" calcext:value-type="string"> @@ -4758,7 +4758,7 @@ <table:table-cell table:style-name="ce78" office:value-type="float" office:value="0.365148371670111" calcext:value-type="float"> <text:p>0.365148</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" 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="ce79" 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="ce82" table:formula="of:=FORMULA([.A35])" office:value-type="string" office:string-value="=TINV(0.75,2)" calcext:value-type="string"> @@ -4782,7 +4782,7 @@ <table:table-cell table:style-name="ce78" office:value-type="float" office:value="0.365148371670111" calcext:value-type="float"> <text:p>0.365148</text:p> </table:table-cell> - <table:table-cell table:style-name="ce79" table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A36];14)=ORG.LIBREOFFICE.ROUNDSIG([.B36];14)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce79" table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A36];15)=ORG.LIBREOFFICE.ROUNDSIG([.B36];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="ce82" table:formula="of:=FORMULA([.A36])" office:value-type="string" office:string-value="=TINV(0.75,2.8)" calcext:value-type="string"> @@ -5314,4 +5314,4 @@ </table:named-expressions> </office:spreadsheet> </office:body> -</office:document>
\ No newline at end of file +</office:document> |