2017-04-12T21:54:51.161312286P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/eefe13c77d01be37c911e75af191717a944fedb3 0 0 102362 12819 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 4 4 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 kgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQ8ARHVwbGV4TW9kZTo6T2Zm 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 ZTEST Function Result TRUE Sheet Result Description 1 TRUE Simple ZTEST 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 Data 1 1 TRUE =ZTEST(F1:F11,G1,H2) 0.09 11 2 2.9 1.959999998 0.400653343414888 3 6 0.194342606933787 3.00000000000000E+000 5.80000000000000E+001 3.50000000000000E+001 3 105 1.06721692449657E-001 0.106721692449657 TRUE =ZTEST(F1:G11,H6,I5) 0.1 12 3 3.9 -0.2 6 60 0.166463582077995 4 19 0.400653343414888 4.00000000000000E+000 1.10000000000000E+001 2.50000000000000E+001 6 20 0.081569840497591 0.081569840497591 TRUE =ZTEST(F3:I9,H2,G10) 0.11 13 4 4.9 0.8 5 0.087469917023554 5 3 0.166463582077995 5.00000000000000E+000 1.00000000000000E+001 2.30000000000000E+001 7 100 0.001527889995942 0.001527889995942 TRUE =ZTEST(F4:I11,I2,G1) 0.12 14 5 5.9 1.8 11 0.341886235401034 8 2 0.087469917023554 6.00000000000000E+000 8 9.69315585430299E-001 0.969315585430299 TRUE =ZTEST(L3:M9,I8,H9) 0.13 15 6 6.9 2.8 7 0.946274813031778 9 14 0.341886235401034 7.00000000000000E+000 4.53500000000000E+001 4.76500000000000E+001 6 9.96171942651607E-001 0.996171942651607 TRUE =ZTEST(O2:P10,M5,H6) 0.14 16 7 7.9 3.8 5 0.984649823047221 1 4 0.946274813031778 8.00000000000000E+000 1.75600000000000E+001 1.84400000000000E+001 5 7.75598866865391E-001 0.775598866865391 TRUE =ZTEST(T1:U14,W3,W6) 0.15 17 8 8.9 4.8 4 0.910959278000519 2 5 0.984649823047221 9.00000000000000E+000 1.60900000000000E+001 1.69100000000000E+001 4 1.00000000000000E+000 1 TRUE =ZTEST(W2:X8,AB2,AB3) 0.16 18 9 9.9 5.8 4 0.730935096507892 4 17 0.910959278000519 1.00000000000000E+001 2 9.05741968513638E-002 0.090574196851364 TRUE =ZTEST(Y2:Y11,4) 0.17 19 10 10.9 1.40065334341489 5 1 0.730935096507892 1.10000000000000E+001 1 1.81148393702728E-001 0.181148393702728 TRUE =2*MIN(ZTEST(Y2:Y11,4),1-ZTEST(Y2:Y11,4)) 0.18 20 11 11.9 0.208618188742548 1.20000000000000E+001 9.00000000000000E+000 8.63043389129530E-001 0.86304338912953 TRUE =ZTEST(Y2:Y11,6) 0.731778104091063 1.30000000000000E+001 1.72608677825906E+000 1.72608677825906 TRUE =2*MIN(ZTEST(Y2:Y11,6),1-ZTEST(A2:YY11,6)) 0.960519265849143 1.40000000000000E+001 1.51051498603616E-06 1.51051498603616E-06 TRUE =ZTEST(F3:I9,H2) 0.176640923600644 1.50000000000000E+001 #DIV/0! #DIV/0! TRUE =ZTEST(F1,G1,H1) 654654 654 1 2.54717826485009E-001 0.254717826485009 TRUE =ZTEST(I19:I23,20) 2.54717826485009E-001 0.254717826485009 TRUE =ZTEST(I19:I23,20, STDEV(I19:I23)) #DIV/0! #DIV/0! TRUE =ZTEST(F18:G18, 42) 42 11.4 17.3 21.3 25.9 40.1