2016-09-13T18:40:38.515032568P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/a8a7b7114d96b2013b00e9bc0ced81aad5495457 0 0 44106 60254 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 4 9 0 0 0 0 2 0 0 0 81 0 75 60 true false Sheet2 1241 0 75 60 false true true true 12632256 true true true true false 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 kQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= 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 / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 FISHERINV Function Result TRUE Sheet Result Description 1 TRUE Simple FISHERINV formulas with local references and values Function Expected Correct FunctionString Comment -1 -0.09 0.000000000000002 -0.761594155955765 -0.761594155955765 TRUE =FISHERINV(I1) -0.9 -0.08 0.000000000000050 -0.716297870199024 -0.716297870199024 TRUE =FISHERINV(I2) -0.8 -0.07 0.000000000000900 -0.664036770267849 -0.664036770267849 TRUE =FISHERINV(I3) -0.7 -0.06 0.000000000002000 -0.604367777117164 -0.604367777117164 TRUE =FISHERINV(I4) -0.6 -0.05 0.000000000050000 -0.537049566998035 -0.537049566998035 TRUE =FISHERINV(I5) -0.5 -0.04 0.000000000900000 -0.46211715726001 -0.46211715726001 TRUE =FISHERINV(I6) -0.4 -0.03 0.000000002000000 -0.379948962255225 -0.3799489622552250000 TRUE =FISHERINV(I7) -0.3 -0.02 0.000000050000000 -0.291312612451591 -0.291312612451591 TRUE =FISHERINV(I8) -0.2 -0.01 0.000000900000000 -0.197375320224904 -0.197375320224904 TRUE =FISHERINV(I9) -0.1 0 0.000002000000000 -0.099667994624956 -0.099667994624956 TRUE =FISHERINV(I10) 0 0.01 0.000050000000000 0 0 TRUE =FISHERINV(I11) 0.1 0.02 0.000900000000000 0.099667994624956 0.099667994624956 TRUE =FISHERINV(I12) 0.2 0.03 0.002000000000000 0.197375320224904 0.197375320224904 TRUE =FISHERINV(I13) 0.3 0.04 0.003000000000000 0.291312612451591 0.291312612451591 TRUE =FISHERINV(I14) 0.4 0.05 0.007000000000000 0.379948962255225 0.379948962255225 TRUE =FISHERINV(I15) 0.5 0.06 0.010000000000000 0.46211715726001 0.46211715726001 TRUE =FISHERINV(I16) 0.6 0.07 0.016000000000000 0.537049566998035 0.537049566998035 TRUE =FISHERINV(I17) 0.7 0.08 0.050000000000000 0.604367777117164 0.604367777117164 TRUE =FISHERINV(I18) 0.8 0.09 0.090000000000000 0.664036770267849 0.664036770267849 TRUE =FISHERINV(I19) 0.9 0.1 9.87000000000000E-010 0.716297870199024 0.716297870199024 TRUE =FISHERINV(I20) 1 0.11 9.87000000000000E-015 0.761594155955765 0.761594155955765 TRUE =FISHERINV(I21) 9.87000000000000E-016 0 0 TRUE =FISHERINV(I22) 9.87000000000000E-017 -0.08975778474716 -0.08975778474716 TRUE =FISHERINV(J1) 9.87000000000000E-018 -0.079829769111131 -0.079829769111131 TRUE =FISHERINV(J2) 9.87000000000000E-050 -0.069885890316429 -0.069885890316429 TRUE =FISHERINV(J3) 9.87000000000000E-100 -0.059928103529144 -0.059928103529144 TRUE =FISHERINV(J4) 9.87000000000000E-300 -0.04995837495788 -0.04995837495788 TRUE =FISHERINV(J5) 0.000000000000000 -0.039978680311164 -0.039978680311164 TRUE =FISHERINV(J6) -0.000000000000002 -0.02999100323882 -0.02999100323882 TRUE =FISHERINV(J7) -0.000000000000050 -0.019997333759931 -0.019997333759931 TRUE =FISHERINV(J8) -0.000000000000900 -0.009999666679999 -0.009999666679999 TRUE =FISHERINV(J9) -0.000000000002000 0 0 TRUE =FISHERINV(J10) -0.000000000050000 0.009999666679999 0.009999666679999 TRUE =FISHERINV(J11) -0.000000000900000 0.019997333759931 0.019997333759931 TRUE =FISHERINV(J12) -0.000000002000000 0.02999100323882 0.02999100323882 TRUE =FISHERINV(J13) -0.000000050000000 0.039978680311164 0.039978680311164 TRUE =FISHERINV(J14) -0.000000900000000 0.04995837495788 0.04995837495788 TRUE =FISHERINV(J15) -0.000002000000000 0.059928103529144 0.059928103529144 TRUE =FISHERINV(J16) -0.000050000000000 0.069885890316429 0.069885890316429 TRUE =FISHERINV(J17) -0.000900000000000 0.079829769111131 0.079829769111131 TRUE =FISHERINV(J18) -0.002000000000000 0.08975778474716 0.08975778474716 TRUE =FISHERINV(J19) -0.003000000000000 0.099667994624956 0.099668 TRUE =FISHERINV(J20) -0.007000000000000 0.10955847021443 0.109558 TRUE =FISHERINV(J21) -0.010000000000000 2E-15 0.000000 TRUE =FISHERINV(K1) -0.016000000000000 5E-14 0.000000 TRUE =FISHERINV(K2) -0.050000000000000 9E-13 0.000000 TRUE =FISHERINV(K3) -0.090000000000000 2E-12 0.000000 TRUE =FISHERINV(K4) -9.87000000000000E-010 5E-11 0.000000 TRUE =FISHERINV(K5) -9.87000000000000E-015 9E-10 0.000000 TRUE =FISHERINV(K6) -9.87000000000000E-016 2E-09 0.000000 TRUE =FISHERINV(K7) -9.87000000000000E-017 5E-08 0.000000 TRUE =FISHERINV(K8) -9.87000000000000E-018 8.99999999999757E-07 8.99999999999757E-07 TRUE =FISHERINV(K9) -9.87000000000000E-050 1.99999999999733E-06 1.99999999999733E-06 TRUE =FISHERINV(K10) -9.87000000000000E-100 4.99999999583333E-05 4.99999999583333E-05 TRUE =FISHERINV(K11) -9.87000000000000E-300 0.000899999757 0.000900 TRUE =FISHERINV(K12) 0.001999997333338 0.001999997333338 TRUE =FISHERINV(K13) 0.002999991000032 0.002999991000032 TRUE =FISHERINV(K14) 0.006999885668908 0.006999885668908 TRUE =FISHERINV(K15) 0.009999666679999 0.009999666679999 TRUE =FISHERINV(K16) 0.015998634806462 0.015998634806462 TRUE =FISHERINV(K17) 0.04995837495788 0.049958 TRUE =FISHERINV(K18) 0.08975778474716 0.089758 TRUE =FISHERINV(K19) 9.87E-10 0.000000 TRUE =FISHERINV(K20) 9.87E-15 0.000000 TRUE =FISHERINV(K21) 9.87E-16 0.000000 TRUE =FISHERINV(K22) 9.87E-17 0.000000 TRUE =FISHERINV(K23) 9.87E-18 0.000000 TRUE =FISHERINV(K24) 9.87E-50 0.000000 TRUE =FISHERINV(K25) 9.87E-100 0.000000 TRUE =FISHERINV(K26) 9.87E-300 0.000000 TRUE =FISHERINV(K27) 0 0.000000 TRUE =FISHERINV(K28) -2E-15 0.000000 TRUE =FISHERINV(K29) -5E-14 0.000000 TRUE =FISHERINV(K30) -9E-13 0.000000 TRUE =FISHERINV(K31) -2E-12 0.000000 TRUE =FISHERINV(K32) -5E-11 0.000000 TRUE =FISHERINV(K33) -9E-10 0.000000 TRUE =FISHERINV(K34) -2E-09 -2E-09 TRUE =FISHERINV(K35) -5E-08 -5E-08 TRUE =FISHERINV(K36) -8.99999999999757E-07 -8.99999999999757E-07 TRUE =FISHERINV(K37) -1.99999999999733E-06 -1.99999999999733E-06 TRUE =FISHERINV(K38) -4.99999999583333E-05 -4.99999999583333E-05 TRUE =FISHERINV(K39) -0.000899999757 -0.000899999757 TRUE =FISHERINV(K40) -0.001999997333338 -0.001999997333338 TRUE =FISHERINV(K41) -0.002999991000032 -0.002999991000032 TRUE =FISHERINV(K42) -0.006999885668908 -0.006999885668908 TRUE =FISHERINV(K43) -0.009999666679999 -0.009999666679999 TRUE =FISHERINV(K44) -0.015998634806462 -0.015998634806462 TRUE =FISHERINV(K45) -0.04995837495788 -0.04995837495788 TRUE =FISHERINV(K46) -0.08975778474716 -0.08975778474716 TRUE =FISHERINV(K47) -9.87E-10 -9.87E-10 TRUE =FISHERINV(K48) -9.87E-15 -9.87E-15 TRUE =FISHERINV(K49) -9.87E-16 -9.87E-16 TRUE =FISHERINV(K50) -9.87E-17 -9.87E-17 TRUE =FISHERINV(K51) -9.87E-18 -9.87E-18 TRUE =FISHERINV(K52) -9.87E-50 -9.87E-50 TRUE =FISHERINV(K53) -9.87E-100 -9.87E-100 TRUE =FISHERINV(K54) -9.87E-300 -9.87E-300 TRUE =FISHERINV(K55) -0.08975778474716 -0.08975778474716 TRUE {=FISHERINV(J1:J2)} -0.079829769111131 -0.079829769111131 TRUE {=FISHERINV(J1:J2)} 4