2017-02-17T19:42:47.143959875P0D1LibreOfficeDev/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 Function Result TRUE Sheet Result Description 1 TRUE Simple CHISQ.INV 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 3.28302028675954 3.28302028675954 TRUE =CHISQ.INV(0.93,1) 0.09 11 2 2.9 1.959999998 0.400653343414888 3 6 0.194342606933787 3.00000000000000E+000 105 1.83258146374831E+000 1.83258146374831 TRUE =CHISQ.INV(0.6,2) 0.1 12 3 3.9 0.2 6 60 0.166463582077995 4 19 0.400653343414888 4.00000000000000E+000 20 4.53504966643008 4.53504966643008 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.11 13 4 4.9 0.3 5 0.087469917023554 5 3 0.166463582077995 5.00000000000000E+000 100 5.40462670205885 5.40462670205885 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.12 14 5 5.9 0.4 11 0.341886235401034 8 2 0.087469917023554 6.00000000000000E+000 6.30379605958432 6.30379605958432 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.13 15 6 6.9 0.5 7 0.946274813031778 9 14 0.341886235401034 7.00000000000000E+000 7.22840922887967 7.22840922887967 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.14 16 7 7.9 0.6 5 0.984649823047221 1 4 0.946274813031778 8.00000000000000E+000 8.17520208558841 8.17520208558841 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.15 17 8 8.9 0.7 4 0.910959278000519 2 5 0.984649823047221 9.00000000000000E+000 9.14156135907027 9.14156135907027 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.16 18 9 9.9 0.8 4 0.730935096507892 4 17 0.910959278000519 1.00000000000000E+001 10.1253633400196 10.1253633400196 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.17 19 10 10.9 1.40065334341489 5 1 0.730935096507892 1.10000000000000E+001 11.1248597059224 11.1248597059224 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.18 20 11 11.9 0.208618188742548 1.20000000000000E+001 12.1385949123142 12.1385949123142 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.731778104091063 1.30000000000000E+001 13.1653452479781 13.1653452479781 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.960519265849143 1.40000000000000E+001 14.2040730851385 14.2040730851385 TRUE {=CHISQ.INV(F1:F11,G1:G11)} 0.176640923600644 1.50000000000000E+001 3.07008840528929 3.07008840528929 TRUE {=CHISQ.INV(L3:L9,M3:M9)} 654654 654 1 2.99990813275991 2.99990813275991 TRUE {=CHISQ.INV(L3:L9,M3:M9)} 9.23728542384152 9.23728542384152 TRUE {=CHISQ.INV(L3:L9,M3:M9)} 6.34581119552152 6.34581119552152 TRUE {=CHISQ.INV(L3:L9,M3:M9)} 5.13186707440182 5.13186707440182 TRUE {=CHISQ.INV(L3:L9,M3:M9)} 4.87843296656041 4.87843296656041 TRUE {=CHISQ.INV(L3:L9,M3:M9)} 5.98861669400425E+000 5.98861669400425 TRUE {=CHISQ.INV(L3:L9,M3:M9)} 9.81793008255829E-001 0.981793008255829 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 2.75660369088146E+000 2.75660369088146 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 2.11132612370180E+000 2.1113261237018 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 2.07649999353220E+000 2.0764999935322 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 5.01515445024952E+000 5.01515445024952 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 1.52911628705065E+001 15.2911628705065 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 2.04461298047275E+001 20.4461298047275 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 1.63884014923503E+001 16.3884014923503 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 1.33824533053927E+001 13.3824533053927 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 7.91959455051006E+000 7.91959455051006 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 1.56557151216055E+001 15.6557151216055 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 2.45E+01 24.5318147689017 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 9.94221245771641E+000 9.94221245771641 TRUE {=CHISQ.INV(T2:T14,U2:U14)} 0.00000000000000E+000 0.000000 TRUE =CHISQ.INV(0,1) Err:502 Err:502 TRUE =CHISQ.INV(1,1) If probability < 0 or probability > 1, CHISQ.INV returns the #NUM! error value. 4.54936423119572E-001 0.454936 TRUE =CHISQ.INV(0.5,1) 1.57907740934312E-002 0.015791 TRUE =CHISQ.INV(0.1,1.1) Err:502 Err:502 TRUE =CHISQ.INV(-1,11) 1.00869322157760E-002 0.010087 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 1.88621358942483E-001 0.188621 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 5.84374374155183E-001 0.584374 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 1.12678197979450E+000 1.126782 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 1.76973389560269E+000 1.769734 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 2.48627982968339E+000 2.48627982968339 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 3.25953870534247E+000 3.25953870534247 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 4.07819909611163E+000 4.07819909611163 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 4.93427041996151E+000 4.934270 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 5.82187319978550E+000 5.8218731997855 TRUE {=CHISQ.INV(F1:F11,I1:I11)} 6.73654101450682E+000 6.73654101450682 TRUE {=CHISQ.INV(F1:F11,I1:I11)} Err:502 Err:502 TRUE =CHISQ.INV(0.1,0.1)