2016-12-30T16:35:40.174400414P0D1LibreOfficeDev/5.3.0.0.alpha1$Linux_X86_64 LibreOffice_project/883024d657fb45c7da459017d2f936aac5644bfb 0 0 57546 61425 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 4 5 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ł € - € : : : : € - € € - € / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € : : : € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 PEARSON Function Result TRUE Sheet Result Description 1 TRUE Simple PEARSON formulas with local references and values Function Expected Correct FunctionString Comment Data 1 12 1 31622779.6016838 Power of 10 to add to data 0.699378606180235 0.699378606180235 TRUE =PEARSON(I3:I7,J3:J7) Independent values Dependent values 2 13 2 31622780.6016838 7.5 1.0000000000000000000 1 TRUE =PEARSON(J12:J17,I12:I17) 9 10 3 14 3 31622778.6016838 900000002 899999998 1 1 TRUE =PEARSON(L1:L25,M1:M25) 7 6 4 15 4 31622781.6016838 900000003 899999997 0.713771885812213 0.713771885812213 TRUE =PEARSON(O1:O6,P1:P6) 5 1 5 16 5 31622780.6016838 900000004 899999996 -0.99844495050475 -0.99844495050475 TRUE =PEARSON(T2:T101,U2:U101) 3 5 6 17 6 31622783.6016838 900000005 899999995 0.712309892320122 0.712309892320122 TRUE =PEARSON(I3:I9,J3:J9) 1 3 7 18 900000015 899999994 a 8 19 900000007 899999993 3 0 9 20 900000008 899999992 10 21 900000009 899999991 11 22 900000010 899999990 10000000000004 10000000000003 12 23 900000011 899999989 10000000000005 10000000000004 13 24 900000012 899999988 10000000000003 10000000000002 14 25 900000013 899999987 10000000000006 10000000000005 15 26 900000014 899999986 10000000000005 10000000000004 16 27 900000015 899999985 10000000000008 10000000000007 17 28 900000016 899999984 18 29 900000017 899999983 13.0 19 30 900000018 899999982 20 31 900000019 899999981 21 32 900000020 899999980 22 33 900000021 899999979 23 34 900000022 899999978 24 35 900000023 899999977 25 36 900000024 899999976 900000025 899999975 900000026 899999974 900000027 899999960 900000028 899999972 900000029 899999971 900000030 899999970 900000031 899999969 900000032 899999968 900000033 899999967 900000034 899999966 900000035 899999965 900000036 899999964 900000037 899999963 900000038 899999962 900000039 899999961 900000040 899999960 900000041 899999959 900000042 899999958 900000043 899999957 900000044 899999956 900000045 899999955 900000046 899999954 900000047 899999953 900000048 899999952 900000049 899999951 900000050 899999950 900000051 899999949 900000052 899999948 900000053 899999947 900000054 899999946 900000055 899999945 900000056 899999944 900000057 899999943 900000058 899999942 900000059 899999941 900000060 899999940 900000061 899999939 900000062 899999938 900000063 899999937 900000064 899999936 900000065 899999935 900000066 899999934 900000067 899999933 900000068 899999932 900000069 899999931 900000070 899999930 900000071 899999929 900000072 899999928 900000073 899999927 900000074 899999926 900000075 899999925 900000076 899999924 900000077 899999923 900000078 899999922 900000079 899999921 900000080 899999920 900000081 899999919 900000082 899999918 900000083 899999917 900000084 899999916 900000085 899999915 900000086 899999914 900000087 899999913 900000088 899999912 900000089 899999911 900000090 899999910 900000091 899999909 900000092 899999908 900000093 899999907 900000094 899999906 900000095 899999905 900000096 899999904 900000097 899999903 900000098 899999902 900000099 899999901 900000100 899999900