2016-08-18T22:58:05.915011208P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/93eb0896bc30163dba47e20459dd0d14fb9770f9 0 0 90556 65270 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 0 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 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 / / / / / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € % % / / / / $ - $ ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 CHIDIST Function Result TRUE Sheet Result Description 1 TRUE Simple CHIDIST formulas with local references and values Function Expected Correct FunctionString Comment Data Description year month day value 0.020975769403022 0.020975769403022 TRUE =CHIDIST(13.27, 5) 18.307 Value at which you want to evaluate the distribution 2012 12 15 6 0.57240670447088 0.57240670447088 TRUE =CHIDIST(2, 3) 10 Degrees of freedom 2012 4 1 10.4 0.050000589091398 0.050000589091398 TRUE =CHIDIST(I2,I3) 2013 8 15 7 1 1 TRUE =CHIDIST(F5,5) 0 2011 11 1 12 0.962565773247296 0.962565773247296 TRUE =CHIDIST(F6,5) 1 2011 2 14 8 0.84914503608461 0.84914503608461 TRUE =CHIDIST(F7,5) 2 2010 6 1 15 0.699985835878627 0.699985835878627 TRUE =CHIDIST(F8,5) 3 0.54941595135278 0.54941595135278 TRUE =CHIDIST(F9,5) 4 0.415880186995508 0.415880186995508 TRUE =CHIDIST(F10,5) 5 0.306218918413278 0.306218918413278 TRUE =CHIDIST(F11,5) 6 0.22064030793671 0.22064030793671 TRUE =CHIDIST(F12,5) 7 0.156235627577722 0.156235627577722 TRUE =CHIDIST(F13,5) 8 0.109064157949772 0.109064157949772 TRUE =CHIDIST(F14,5) 9 0.075235246146512 0.075235246146512 TRUE =CHIDIST(F15,5) 10 0.05137998348307 0.05137998348307 TRUE =CHIDIST(F16,5) 11 0.034787780506242 0.034787780506242 TRUE =CHIDIST(F17,5) 12 0.023378768103564 0.023378768103564 TRUE =CHIDIST(F18,5) 13 0.015609416100267 0.015609416100267 TRUE =CHIDIST(F19,5) 14 0.010362337915787 0.010362337915786 TRUE =CHIDIST(F20,5) 15 0.00684407392242 0.00684407392242 TRUE =CHIDIST(F21,5) 16 0.004499796977971 0.004499796977971 TRUE =CHIDIST(F22,5) 17 0.00294640458788 0.00294640458788 TRUE =CHIDIST(F23,5) 18 0.001922136820943 0.001922136820943 TRUE =CHIDIST(F24,5) 19 0.001249730563031 0.001249730563031 TRUE =CHIDIST(F25,5) 20 0.00081005961819 0.00081005961819 TRUE =CHIDIST(F26,5) 21 0.000523598316107 0.000523598316107 TRUE =CHIDIST(F27,5) 22 0.000337566057614 0.000337566057614 TRUE =CHIDIST(F28,5) 23 0.000217112943453 0.000217112943453 TRUE =CHIDIST(F29,5) 24 0.000139333791186 0.000139333791186 TRUE =CHIDIST(F30,5) 25 8.92359833449632E-05 8.92359833449632E-05 TRUE =CHIDIST(F31,5) 26 5.70424566826866E-05 5.70424566826866E-05 TRUE =CHIDIST(F32,5) 27 3.63987669058086E-05 3.63987669058086E-05 TRUE =CHIDIST(F33,5) 28 2.31875858031011E-05 2.31875858031011E-05 TRUE =CHIDIST(F34,5) 29 1.47485810384431E-05 1.47485810384431E-05 TRUE =CHIDIST(F35,5) 30 9.36724870539855E-06 0.000009 TRUE =CHIDIST(F36,5) 31 5.94126010477135E-06 5.94126010477135E-06 TRUE =CHIDIST(F37,5) 32 3.76343249052742E-06 3.76343249052742E-06 TRUE =CHIDIST(F38,5) 33 2.38100443698901E-06 2.38100443698901E-06 TRUE =CHIDIST(F39,5) 34 1.50465066217572E-06 1.50465066217572E-06 TRUE =CHIDIST(F40,5) 35 9.49810899862509E-07 9.49810899862509E-07 TRUE =CHIDIST(F41,5) 36 5.98948029538294E-07 5.98948029538294E-07 TRUE =CHIDIST(F42,5) 37 3.77323913873248E-07 0.000000 TRUE =CHIDIST(F43,5) 38 2.37483654613763E-07 0.000000 TRUE =CHIDIST(F44,5) 39 1.49336790005039E-07 0.000000 TRUE =CHIDIST(F45,5) 40 9.38278398162711E-08 0.000000 TRUE =CHIDIST(F46,5) 41 5.89040720215747E-08 0.000000 TRUE =CHIDIST(F47,5) 42 3.69507585298366E-08 0.000000 TRUE =CHIDIST(F48,5) 43 2.31622394075481E-08 0.000000 TRUE =CHIDIST(F49,5) 44 1.45087716965827E-08 0.000000 TRUE =CHIDIST(F50,5) 45 9.08210581888929E-09 0.000000 TRUE =CHIDIST(F51,5) 46 5.68146559452648E-09 0.000000 TRUE =CHIDIST(F52,5) 47 3.55192255556018E-09 0.000000 TRUE =CHIDIST(F53,5) 48 2.21925177751758E-09 0.000000 TRUE =CHIDIST(F54,5) 49 1.38579733670096E-09 0.000000 TRUE =CHIDIST(F55,5) 50 8.64873176526339E-10 0.000000 TRUE =CHIDIST(F56,5) 51 5.3947790695877E-10 0.000000 TRUE =CHIDIST(F57,5) 52 3.36334879656051E-10 0.000000 TRUE =CHIDIST(F58,5) 53 2.09582579825749E-10 0.000000 TRUE =CHIDIST(F59,5) 54 1.30536234619946E-10 0.000000 TRUE =CHIDIST(F60,5) 55 8.12656112671903E-11 0.000000 TRUE =CHIDIST(F61,5) 56 5.05695617619749E-11 0.000000 TRUE =CHIDIST(F62,5) 57 3.14546401054883E-11 0.000000 TRUE =CHIDIST(F63,5) 58 1.95568797382087E-11 0.000000 TRUE =CHIDIST(F64,5) 59 1.2154569777183E-11 0.000000 TRUE =CHIDIST(F65,5) 60 7.55110283295074E-12 0.000000 TRUE =CHIDIST(F66,5) 61 4.68939988256006E-12 0.000000 TRUE =CHIDIST(F67,5) 62 2.91115491988963E-12 0.000000 TRUE =CHIDIST(F68,5) 63 1.80658905929871E-12 0.000000 TRUE =CHIDIST(F69,5) 64 1.12073792572193E-12 0.000000 TRUE =CHIDIST(F70,5) 65 6.95030424871408E-13 0.000000 TRUE =CHIDIST(F71,5) 66 4.30886458001334E-13 0.000000 TRUE =CHIDIST(F72,5) 67 2.67045460858897E-13 0.000000 TRUE =CHIDIST(F73,5) 68 1.65453041298584E-13 0.000000 TRUE =CHIDIST(F74,5) 69 1.0247908013196E-13 0.000000 TRUE =CHIDIST(F75,5) 70 6.34556283871416E-14 0.000000 TRUE =CHIDIST(F76,5) 71 3.92810383254513E-14 0.000000 TRUE =CHIDIST(F77,5) 72 2.43095502015946E-14 0.000000 TRUE =CHIDIST(F78,5) 73 1.50402545513147E-14 1.50402545513147E-14 TRUE =CHIDIST(F79,5) 74 9.3029518094026E-15 9.3029518094026E-15 TRUE =CHIDIST(F80,5) 75 5.75276432086483E-15 5.75276432086483E-15 TRUE =CHIDIST(F81,5) 76 3.55652129735241E-15 3.55652129735241E-15 TRUE =CHIDIST(F82,5) 77 2.19821392469072E-15 2.19821392469072E-15 TRUE =CHIDIST(F83,5) 78 1.35835346114789E-15 1.35835346114789E-15 TRUE =CHIDIST(F84,5) 79 8.3918251148316E-16 8.3918251148316E-16 TRUE =CHIDIST(F85,5) 80 5.18326305693304E-16 5.18326305693304E-16 TRUE =CHIDIST(F86,5) 81 3.20077825396592E-16 3.20077825396592E-16 TRUE =CHIDIST(F87,5) 82 1.97613072880797E-16 1.97613072880797E-16 TRUE =CHIDIST(F88,5) 83 1.21979165467929E-16 1.21979165467929E-16 TRUE =CHIDIST(F89,5) 84 7.52779230504521E-17 7.52779230504521E-17 TRUE =CHIDIST(F90,5) 85 4.64476336588717E-17 4.64476336588717E-17 TRUE =CHIDIST(F91,5) 86 2.86533559401803E-17 2.86533559401803E-17 TRUE =CHIDIST(F92,5) 87 1.76727937971441E-17 1.76727937971441E-17 TRUE =CHIDIST(F93,5) 88 1.08981945017093E-17 1.08981945017093E-17 TRUE =CHIDIST(F94,5) 89 6.71931936485258E-18 6.71931936485258E-18 TRUE =CHIDIST(F95,5) 90 4.1420858423525E-18 4.1420858423525E-18 TRUE =CHIDIST(F96,5) 91 2.55292251953569E-18 2.55292251953569E-18 TRUE =CHIDIST(F97,5) 92 1.57319476575966E-18 1.57319476575966E-18 TRUE =CHIDIST(F98,5) 93 9.69293304276011E-19 9.69293304276011E-19 TRUE =CHIDIST(F99,5) 94 5.97114047362401E-19 5.97114047362401E-19 TRUE =CHIDIST(F100,5) 95 3.6778174384969E-19 3.6778174384969E-19 TRUE =CHIDIST(F101,5) 96 2.26493245597239E-19 2.26493245597239E-19 TRUE =CHIDIST(F102,5) 97 1.39461365299684E-19 1.39461365299684E-19 TRUE =CHIDIST(F103,5) 98 8.58593232658406E-20 8.58593232658406E-20 TRUE =CHIDIST(F104,5) 99 5.28514836094322E-20 5.28514836094322E-20 TRUE =CHIDIST(F105,5) 100 0.99999999999834 0.99999999999834 TRUE =CHIDIST(F106,G106) 2.30000000000000E-002 1.00000000000000E+001 5.44970198292052E-17 5.44970198292052E-17 TRUE =CHIDIST(F107,G107) 1.00000000000000E+002 1.00000000000000E+001 0.999999999999999 0.999999999999999 TRUE =CHIDIST(F108,G108) 0.005035400390625 10 0.964294972685089 0.964294972685089 TRUE =CHIDIST(3, 9) 0.483767381553687 0.483767381553687 TRUE =CHIDIST(7.5, 8) Err:502 Err:502 TRUE =CHIDIST(7.5,0) Err:502 Err:502 TRUE =CHIDIST(7.5,-8) 4