2017-02-17T19:43:08.726352913P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/2aea0d0148ea0940da2b32387c330f9aa590294c 0 0 96176 28426 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 4 1 0 0 0 0 2 0 0 0 0 0 100 60 true false Sheet2 1241 0 100 60 false true true true 12632256 true true true true true false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn cs CZ de DE en US nl NL true true 3 1 true 1 true lgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== false 0 Kč - Kč ( ) - Kč - Kč Kč - Kč Kč - Kč Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € $ ($ ) € - € € - € € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € % % % % % % $ ( $ ) % % - % - - - £ - £ £ - £ % - % DM - DM DM - DM DM - DM DM - DM - - DM - DM - DM - - DM - DM - DM Ouch! - - Error detected! - Result=0 - No Errordetection / / / / £ -£ £ -£ £ -£ £ -£ - - £ -£ £ - - - £ -£ £ - ￥ - ￥ DM - DM DM - DM DM - DM DM - DM DM - DM € € - tan aa zł - zł € - € : : : : € - € € - € ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - € ( € ) ok ERR! - - Kč - Kč - Kč - - Kč - Kč - Kč ¥€ ( € ) / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € : : : € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 CHISQ.INV.RT Function Result TRUE Sheet Result Description 1 TRUE Simple CHISQ.INV.RT formulas with local references and values Function Expected Correct FunctionString Comment 0.08 10 1 1.9 Data Data 1 Data 2 0.402599231572822 2.00000000000000E+000 0.007716715544952 0.007716715544952 TRUE =CHISQ.INV.RT(0.93,1) 0.09 11 2 2.9 1.959999998 0.400653343414888 3 6 0.194342606933787 3.00000000000000E+000 105 1.02165124753198E+000 1.02165124753198 TRUE =CHISQ.INV.RT(0.6,2) 0.1 12 3 3.9 0.2 6 60 0.166463582077995 4 19 0.400653343414888 4.00000000000000E+000 20 16.7534776469389 16.7534776469389 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.11 13 4 4.9 0.3 5 0.087469917023554 5 3 0.166463582077995 5.00000000000000E+000 100 17.6525801619669 17.6525801619669 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.12 14 5 5.9 0.4 11 0.341886235401034 8 2 0.087469917023554 6.00000000000000E+000 18.5493477867032 18.5493477867032 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.13 15 6 6.9 0.5 7 0.946274813031778 9 14 0.341886235401034 7.00000000000000E+000 19.4428496786188 19.4428496786188 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.14 16 7 7.9 0.6 5 0.984649823047221 1 4 0.946274813031778 8.00000000000000E+000 20.3325727225773 20.3325727225773 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.15 17 8 8.9 0.7 4 0.910959278000519 2 5 0.984649823047221 9.00000000000000E+000 21.2182466705059 21.2182466705059 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.16 18 9 9.9 0.8 4 0.730935096507892 4 17 0.910959278000519 1.00000000000000E+001 22.0997454457368 22.0997454457368 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.17 19 10 10.9 1.40065334341489 5 1 0.730935096507892 1.10000000000000E+001 22.9770293848276 22.9770293848276 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.18 20 11 11.9 0.208618188742548 1.20000000000000E+001 23.85011045647 23.85011045647 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.731778104091063 1.30000000000000E+001 24.7190308455959 24.7190308455959 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.960519265849143 1.40000000000000E+001 25.5838495454566 25.5838495454566 TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 0.176640923600644 1.50000000000000E+001 #N/A #N/A TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 654654 654 1 #N/A #N/A TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} #N/A #N/A TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} #N/A #N/A TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} #N/A #N/A TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} #N/A #N/A TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} #N/A #N/A TRUE {=CHISQ.INV.RT(F1:F11,G1:G11)} 4.70955884872834E+000 4.70955884872834 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 4.03974744526039E+000 4.03974744526039 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 7.81957420938411E+000 7.81957420938411 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 1.10294689688936E+001 11.0294689688936 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 7.89563999324175E+000 7.89563999324175 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 2.79999887565962E+000 2.79999887565962 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 2.34997118934965E+000 2.34997118934965 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 4.68904427791835E+000 4.68904427791835 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 7.80186272744315E+000 7.80186272744315 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 1.56332273173671E+001 15.6332273173671 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 9.53080142936969E+000 9.53080142936969 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 6.22E+00 6.22422896246087 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} 1.98785604332263E+001 19.8785604332263 TRUE {=CHISQ.INV.RT(T2:T14,U2:U14)} Err:502 Err:502 TRUE =CHISQ.INV.RT(0,1) 0.00000000000000E+000 0.000000 TRUE =CHISQ.INV.RT(1,1) 4.54936423119572E-001 0.454936 TRUE =CHISQ.INV.RT(0.5,1) 2.70554345409541E+000 2.705543 TRUE =CHISQ.INV.RT(0.1,1.1) Err:502 Err:502 TRUE =CHISQ.INV.RT(-1,11) 3.06490172007635E+000 3.064902 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 4.81589121730374E+000 4.815891 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 6.25138863117033E+000 6.251389 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 7.53904147809598E+000 7.539041 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 8.73758545502142E+000 8.737585 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 9.87535922791348E+000 9.87535922791348 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 1.09684761325019E+001 10.9684761325019 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 1.20270737621362E+001 12.0270737621362 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 1.30579852053024E+001 13.057985 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 1.40660528318963E+001 14.0660528318963 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} 1.50548415709125E+001 15.0548415709125 TRUE {=CHISQ.INV.RT(F1:F11,I1:I11)} Err:502 Err:502 TRUE =CHISQ.INV.RT(0.1,0.1)