2017-01-26T20:07:59.488567221P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/326729ce54de5296cb2a673ae88d2befa3e245ef 0 0 81304 28077 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 4 7 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 TTEST Function Result TRUE Sheet Result Description 1 TRUE Simple TTEST formulas with local references and values Function Expected Correct FunctionString Comment 1 10 1 0 Data Data Data 1 Data 2 0.402599231572822 0.169946761336178 8.55266500000000E+006 3.07492200000000E+006 #DIV/0! #DIV/0! TRUE =TTEST(F1:F11,G1:G11,1,1) 2 11 2 0 Known y Known x 1.959999998 3 6 0.194342606933787 0.553136259317398 7.48166900000000E+006 8.55681300000000E+006 1.96015784925282E-001 0.196015784925282 TRUE =TTEST(Q2:Q10,R2:R10,2,1) 3 12 3 0 2 6 60 4 19 0.400653343414888 0.600289918482304 2.50928400000000E+006 7.40836500000000E+006 1.64273886039938E-06 1.64273886039938E-06 TRUE =TTEST(F1:F11,G1:G11,1,2) 4 13 4 0 3 5 5 3 0.166463582077995 0.933991111814976 4.72805200000000E+006 7.07801700000000E+006 1.64273886039938E-06 1.64273886039938E-06 TRUE =TTEST(F1:F11,G1:G11,1,3) 5 14 5 0 9 11 8 2 0.087469917023554 0.263295787386596 9.49210600000000E+006 4.54303500000000E+006 #DIV/0! #DIV/0! TRUE =TTEST(F1:F11,G1:G11,2,1) 6 15 6 0 1 7 9 14 0.341886235401034 0.61026608501561 9.19008300000000E+006 7.35686900000000E+006 3.28547772079875E-06 3.28547772079875E-06 TRUE =TTEST(F1:F11,G1:G11,2,2) 7 16 7 0 8 5 1 4 0.946274813031778 0.417558070970699 3.18773900000000E+006 1.00558500000000E+006 3.28547772079875E-06 3.28547772079875E-06 TRUE =TTEST(F1:F11,G1:G11,2,3) 8 17 8 0 7 4 2 5 0.984649823047221 0.102857194375247 8.53267200000000E+006 6.93940000000000E+006 0.236980811895558 0.236980811895558 TRUE =TTEST(L3:L9,M3:M9,1,1) 9 18 9 0 5 4 4 17 0.910959278000519 0.79397261980921 3.34187900000000E+006 4.68564200000000E+006 0.258253232836168 0.258253232836168 TRUE =TTEST(L3:L9,M3:M9,1,2) 10 19 10 0 5 1 0.730935096507892 0.062783702509478 4.90843300000000E+006 2.65798400000000E+006 0.258593562103877 0.258593562103876 TRUE =TTEST(L3:L9,M3:M9,1,3) 11 20 11 0 0.208618188742548 0.416508829686791 3.86574100000000E+006 1.50118400000000E+006 0.473961623791115 0.473961623791115 TRUE =TTEST(L3:L9,M3:M9,2,1) 0.731778104091063 0.001483274623752 2.76786900000000E+006 9.43757800000000E+006 0.516506465672336 0.516506465672336 TRUE =TTEST(L3:L9,M3:M9,2,2) 0.960519265849143 0.986836141906679 3.93831100000000E+006 6.73757500000000E+006 0.517187124207753 0.517187124207753 TRUE =TTEST(L3:L9,M3:M9,2,3) 0.176640923600644 0.868845847435296 5.62500900000000E+006 9.87330300000000E+006 0.486167279803223 0.486167279803223 TRUE =TTEST(T1:T50,U1:U50,1,1) 654654 654 1 0.47322227130644 0.174563129432499 7.26761800000000E+006 9.07961200000000E+006 0.485578042898102 0.485578042898102 TRUE =TTEST(T1:T50,U1:U50,1,2) 0.111749193863943 0.84864505729638 9.43154800000000E+006 1.84777400000000E+006 0.485578194094926 0.485578194094926 TRUE =TTEST(T1:T50,U1:U50,1,3) 0.370022197486833 0.723300355952233 3.55914100000000E+006 9.00903000000000E+006 0.972334559606446 0.972334559606446 TRUE =TTEST(T1:T50,U1:U50,2,1) 0.120431510265917 0.000142202246934 5.94570300000000E+006 7.89895700000000E+006 0.971156085796204 0.971156085796204 TRUE =TTEST(T1:T50,U1:U50,2,2) 0.865659103030339 0.632935213157907 7.98415600000000E+006 4.39915700000000E+006 0.971156388189853 0.971156388189853 TRUE =TTEST(T1:T50,U1:U50,2,3) 0.541276043280959 0.001646731514484 4.43262500000000E+006 9.69408800000000E+006 0.383986062986469 0.383986062986469 TRUE =TTEST(W1:W50,X1:X50,1,1) 0.900038912659511 0.480235474649817 8.17817400000000E+006 1.03604600000000E+006 0.372577367993232 0.372577367993232 TRUE =TTEST(W1:W50,X1:X50,1,2) 0.08523311605677 0.822807915043086 3.22504400000000E+006 9.99444600000000E+006 3.72596599662044E-001 0.372596599662044 TRUE =TTEST(W1:W50,X1:X50,1,3) 0.337206659838557 0.882674962980673 6.54156800000000E+006 8.04947400000000E+006 7.67972125972938E-001 0.767972125972938 TRUE =TTEST(W1:W50,X1:X50,2,1) 0.854269005125389 0.445781395072117 1.10735700000000E+006 2.60248600000000E+006 7.45154735986465E-001 0.745154735986465 TRUE =TTEST(W1:W50,X1:X50,2,2) 0.374721442349255 0.927562230965123 6.96348900000000E+006 8.73081000000000E+006 7.45193199324088E-001 0.745193199324088 TRUE =TTEST(W1:W50,X1:X50,2,3) 0.114541406510398 0.590035588946193 6.07706800000000E+006 9.31099400000000E+006 7.45193199324088E-001 0.745193199324088 TRUE =TTEST(W1:W50,X1:X50,2.9,3.9) 0.585630424786359 0.828813797561452 6.45186100000000E+006 7.77544400000000E+006 Err:502 #NAME? TRUE =TTEST(W1:W50,X1:X50,4,3) 0.490436446852982 0.573860642267391 6.21535900000000E+006 2.27232600000000E+006 Err:502 #NAME? TRUE =TTEST(W1:W50,X1:X50,2,4) 0.661826125346124 0.390011037467048 1.18509400000000E+006 6.20612800000000E+006 0.90019579930231 0.012589735211805 5.46699000000000E+006 5.74995700000000E+006 0.190245887031779 0.077871951973066 6.25142800000000E+006 8.96555000000000E+006 0.079322624951601 0.592421405483037 4.40051700000000E+006 7.33836300000000E+006 0.564420772949234 0.163427012506872 3.50607400000000E+006 4.92332500000000E+006 0.53767328010872 0.434568428434432 3.42016100000000E+006 8.04694500000000E+006 0.555512311169878 0.707729241810739 8.55000400000000E+006 8.66215600000000E+006 0.738904951605946 0.544847761048004 4.02916400000000E+006 1.91334400000000E+006 0.570837055100128 0.962746524251998 7.60632300000000E+006 1.17951400000000E+006 0.806615271605551 0.073412766680121 4.72676700000000E+006 7.70504400000000E+006 0.547012639464811 0.95261645084247 3.14918300000000E+006 2.39028700000000E+006 0.111656288150698 0.807385856285691 4.82673600000000E+006 9.09768300000000E+006 0.690662265289575 0.519585096277297 7.10288600000000E+006 3.93031100000000E+006 0.19111926923506 0.682888984447345 4.54493600000000E+006 1.94888800000000E+006 0.353901885449886 0.032841254025698 9.51617000000000E+006 4.86070600000000E+006 0.375091741094366 0.15249035647139 4.54480800000000E+006 9.52838400000000E+006 0.864874634193257 0.724242072319612 8.09813100000000E+006 2.28121000000000E+006 0.052185097476468 0.078180975746363 9.89248800000000E+006 1.13269400000000E+006 0.943212330807 0.398327849339694 8.89531600000000E+006 6.20171000000000E+006 0.391606026794761 0.100461794994771 8.12422800000000E+006 1.18423500000000E+006 0.037821719190106 0.152158367680386 9.92476900000000E+006 1.54978800000000E+006 0.206768939038739 0.676331433933228 4.06547700000000E+006 7.03343800000000E+006