2016-08-16T20:20:40.709550117P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/93eb0896bc30163dba47e20459dd0d14fb9770f9 0 0 89632 85395 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 4 7 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 BETADIST Function Result TRUE Sheet Result Description 1 TRUE Simple BETADIST formulas with local references and values Function Expected Correct FunctionString Comment Data Description year month day value 0.96240234375 0.96240234375 TRUE =BETADIST(0.75,3,4) 2 Value at which to evaluate the function 2012 12 15 6 0.2734375 0.2734375 TRUE =BETADIST(1,5,3,-2,4,FALSE()) 8 Parameter of the distribution 2012 4 1 10.4 1.64407702930289 1.64407702930289 TRUE =BETADIST(0.2,0.7,4,0,1,FALSE()) 10 Parameter of the distribution 2013 8 15 7 Err:502 Err:502 TRUE =BETADIST(1,1,0.5,0,1,FALSE()) 1 Lower bound 2011 11 1 12 0 0 TRUE =BETADIST(1.1,1,0.5,0,1,FALSE()) 3 Upper bound 2011 2 14 8 0.2265625 0.2265625 TRUE =BETADIST(1,5,3,-2,4,TRUE()) 2010 6 1 15 0.71794309318323 0.71794309318323 TRUE =BETADIST(0.2,0.7,4,0,1,TRUE()) 0.71794309318323 0.71794309318323 TRUE =BETADIST(0.2,0.7,4) 1 1 TRUE =BETADIST(1.1,1,0.5,0,1,TRUE()) 1.00 1 TRUE =BETADIST(1.1,1,0.5,0,1) ODF: If Cumulative is TRUE(), BETADIST returns 0 if x < a, 1 if x > b 0.685470581054688 0.685470581054688 TRUE =BETADIST(I2,I3,I4,I5,I6) 0.960370937542132 0.960370937542132 TRUE =BETADIST(3, 7.5, 9, 1, 4) 2.00000000000000E-001 0.598190307617188 0.598190307617188 TRUE =BETADIST(7.5, 8, 9, 5, 10) 3.00000000000000E-001 0.876624590753515 0.876624590753515 TRUE =BETADIST(I16,$J$13,$J$14,0,1,FALSE()) 0.546759601543739 0.546759601543739 TRUE =BETADIST(I17,$J$13,$J$14,0,1,FALSE()) 1.00000000000000E-001 0.434028026357426 0.434028026357426 TRUE =BETADIST(I18,$J$13,$J$14,0,1,FALSE()) 2.00000000000000E-001 0.384086937534851 0.384086937534851 TRUE =BETADIST(I19,$J$13,$J$14,0,1,FALSE()) 3.00000000000000E-001 0.365029866220961 0.365029866220961 TRUE =BETADIST(I20,$J$13,$J$14,0,1,FALSE()) 4.00000000000000E-001 0.368825051332716 0.368825051332716 TRUE =BETADIST(I21,$J$13,$J$14,0,1,FALSE()) 5.00000000000000E-001 0.398767812057121 0.398767812057121 TRUE =BETADIST(I22,$J$13,$J$14,0,1,FALSE()) 6.00000000000000E-001 0.475981879111466 0.475981879111466 TRUE =BETADIST(I23,$J$13,$J$14,0,1,FALSE()) 7.00000000000000E-001 0.7037029930589 0.7037029930589 TRUE =BETADIST(I24,$J$13,$J$14,0,1,FALSE()) 8.00000000000000E-001 5.35903263757101E+238 5.35903263757101E+238 TRUE =BETADIST(I25,$J$13,$J$14,0,1,FALSE()) 9.00000000000000E-001 7.41240958948945E+158 7.41240958948945E+158 TRUE =BETADIST(I26,$J$13,$J$14,0,1,FALSE()) 3.00000000000000E-300 1.29057546870231E+079 1.29057546870231E+079 TRUE =BETADIST(I27,$J$13,$J$14,0,1,FALSE()) 2.00000000000000E-200 3.56129050904556E+038 3.56129050904556E+038 TRUE =BETADIST(I28,$J$13,$J$14,0,1,FALSE()) 1.00000000000000E-100 3077955.98886927 3077955.98886927 TRUE =BETADIST(I29,$J$13,$J$14,0,1,FALSE()) 5.00000000000000E-050 272.098567215959 272.098567215959 TRUE =BETADIST(I30,$J$13,$J$14,0,1,FALSE()) 6.00000000000000E-010 1.03195304539888 1.03195304539888 TRUE =BETADIST(I31,$J$13,$J$14,0,1,FALSE()) 7.00000000000000E-005 0.7037029930589 0.7037029930589 TRUE =BETADIST(I32,$J$13,$J$14,0,1,FALSE()) 8.00000000000000E-002 16.2603921489461 16.2603921489461 TRUE =BETADIST(I33,$J$13,$J$14,0,1,FALSE()) 9.00000000000000E-001 408.119062300925 408.119062300925 TRUE =BETADIST(I34,$J$13,$J$14,0,1,FALSE()) 9.99000000000000E-001 10251.4061622172 10251.4061622172 TRUE =BETADIST(I35,$J$13,$J$14,0,1,FALSE()) 9.99990000000000E-001 257503.665036393 257503.665036393 TRUE =BETADIST(I36,$J$13,$J$14,0,1,FALSE()) 9.99999900000000E-001 6468199.11488617 6468199.11488617 TRUE =BETADIST(I37,$J$13,$J$14,0,1,FALSE()) 9.99999999000000E-001 162438470.365225 162438470.365225 TRUE =BETADIST(I38,$J$13,$J$14,0,1,FALSE()) 9.99999999990000E-001 4083442911.23905 4083442911.23905 TRUE =BETADIST(I39,$J$13,$J$14,0,1,FALSE()) 9.99999999999900E-001 19010618424.4271 19010618424.4271 TRUE =BETADIST(I40,$J$13,$J$14,0,1,FALSE()) 9.99999999999999E-001 0.017182573163918 0.017182573163918 TRUE =BETADIST(I42,$J$40,$J$41,0,1,FALSE()) regina 2008-07-06T00:00:00 1-1E-16 1.00000000000000E+000 2.00000000000000E-001 3.07461403537809E-05 3.07461403537809E-05 TRUE =BETADIST(I43,$J$40,$J$41,0,1,FALSE()) 5.00000000000000E+001 3.20119548891565E-08 3.20119548891565E-08 TRUE =BETADIST(I44,$J$40,$J$41,0,1,FALSE()) 1.00000000000000E-001 1.33342475961122E-11 0.000000 TRUE =BETADIST(I45,$J$40,$J$41,0,1,FALSE()) 2.00000000000000E-001 1.47081973442293E-15 0.000000 TRUE =BETADIST(I46,$J$40,$J$41,0,1,FALSE()) 3.00000000000000E-001 2.26789954593594E-20 0.000000 TRUE =BETADIST(I47,$J$40,$J$41,0,1,FALSE()) 4.00000000000000E-001 1.51379925981479E-26 0.000000 TRUE =BETADIST(I48,$J$40,$J$41,0,1,FALSE()) 5.00000000000000E-001 3.20039097644436E-35 0.000000 TRUE =BETADIST(I49,$J$40,$J$41,0,1,FALSE()) 6.00000000000000E-001 5.17381900456755E-50 0.000000 TRUE =BETADIST(I50,$J$40,$J$41,0,1,FALSE()) 7.00000000000000E-001 0 0.000000 TRUE =BETADIST(I51,$J$40,$J$41,0,1,FALSE()) 8.00000000000000E-001 1.9747323258816E+239 197473232588160000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.000000 TRUE =BETADIST(I52,$J$40,$J$41,0,1,FALSE()) 9.00000000000000E-001 2.73137445113117E+159 2731374451131170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.000000 TRUE =BETADIST(I53,$J$40,$J$41,0,1,FALSE()) 1.00000000000000E+000 4.75559913400972E+079 47555991340097200000000000000000000000000000000000000000000000000000000000000000.000000 TRUE =BETADIST(I54,$J$40,$J$41,0,1,FALSE()) 3.00000000000000E-300 1.31228823664249E+039 1312288236642490000000000000000000000000.000000 TRUE =BETADIST(I55,$J$40,$J$41,0,1,FALSE()) 2.00000000000000E-200 11341858.5380473 11341858.538047 TRUE =BETADIST(I56,$J$40,$J$41,0,1,FALSE()) 1.00000000000000E-100 999.164798578344 999.164799 TRUE =BETADIST(I57,$J$40,$J$41,0,1,FALSE()) 5.00000000000000E-050 0.060302704430695 0.060303 TRUE =BETADIST(I58,$J$40,$J$41,0,1,FALSE()) 6.00000000000000E-010 5.17381900456755E-50 0.000000 TRUE =BETADIST(I59,$J$40,$J$41,0,1,FALSE()) 7.00000000000000E-005 4.75940704054726E-148 0.000000 TRUE =BETADIST(I60,$J$40,$J$41,0,1,FALSE()) 8.00000000000000E-002 4.75563717808464E-246 0.000000 TRUE =BETADIST(I61,$J$40,$J$41,0,1,FALSE()) 9.00000000000000E-001 0 0.000000 TRUE =BETADIST(I62,$J$40,$J$41,0,1,FALSE()) 9.99000000000000E-001 0 0.000000 TRUE =BETADIST(I63,$J$40,$J$41,0,1,FALSE()) 9.99990000000000E-001 0 0.000000 TRUE =BETADIST(I64,$J$40,$J$41,0,1,FALSE()) 9.99999900000000E-001 0 0.000000 TRUE =BETADIST(I65,$J$40,$J$41,0,1,FALSE()) 9.99999999000000E-001 0 0.000000 TRUE =BETADIST(I66,$J$40,$J$41,0,1,FALSE()) 9.99999999990000E-001 0 0.000000 TRUE =BETADIST(I67,$J$40,$J$41,0,1,FALSE()) 9.99999999999900E-001 0 0.000000 TRUE =BETADIST(I68,$J$40,$J$41,0,1,FALSE()) 9.99999999999999E-001 1.22691858111198E-59 0.000000 TRUE =BETADIST(I70,$J$68,$J$69,0,1,FALSE()) regina 2008-07-06T00:00:00 1-1E-16 1.00000000000000E+000 7.68054881246347E-42 0.000000 TRUE =BETADIST(I71,$J$68,$J$69,0,1,FALSE()) 1.00000000000000E+000 6.00000000000000E+001 2.06714480699469E-31 0.000000 TRUE =BETADIST(I72,$J$68,$J$69,0,1,FALSE()) 3.00000000000000E-001 5.4152575108696E-24 0.000000 TRUE =BETADIST(I73,$J$68,$J$69,0,1,FALSE()) 1.00000000000000E-001 3.21171317371748E-18 0.000000 TRUE =BETADIST(I74,$J$68,$J$69,0,1,FALSE()) 2.00000000000000E-001 1.76306075778211E-13 0.000000 TRUE =BETADIST(I75,$J$68,$J$69,0,1,FALSE()) 3.00000000000000E-001 1.92125487656783E-09 0.000000 TRUE =BETADIST(I76,$J$68,$J$69,0,1,FALSE()) 4.00000000000000E-001 6.73556041418975E-06 0.000007 TRUE =BETADIST(I77,$J$68,$J$69,0,1,FALSE()) 5.00000000000000E-001 0.01140495450594 0.011405 TRUE =BETADIST(I78,$J$68,$J$69,0,1,FALSE()) 6.00000000000000E-001 8.27163081240875E-246 0.000000 TRUE =BETADIST(I79,$J$68,$J$69,0,1,FALSE()) 7.00000000000000E-001 2.31442575596251E-65 0.000000 TRUE =BETADIST(I80,$J$68,$J$69,0,1,FALSE()) 8.00000000000000E-001 0.01140495450594 0.011405 TRUE =BETADIST(I81,$J$68,$J$69,0,1,FALSE()) 9.00000000000000E-001 135.253747069861 135.253747 TRUE =BETADIST(I82,$J$68,$J$69,0,1,FALSE()) 7.00000000000000E-005 3601.88021136246 3601.880211 TRUE =BETADIST(I83,$J$68,$J$69,0,1,FALSE()) 8.00000000000000E-002 90528.00257483 90528.00257483 TRUE =BETADIST(I84,$J$68,$J$69,0,1,FALSE()) 9.00000000000000E-001 2273973.93981802 2273973.939818 TRUE =BETADIST(I85,$J$68,$J$69,0,1,FALSE()) 9.99000000000000E-001 57119641.747623 57119641.747623 TRUE =BETADIST(I86,$J$68,$J$69,0,1,FALSE()) 9.99990000000000E-001 1434468400.5526 1434468400.5526 TRUE =BETADIST(I87,$J$68,$J$69,0,1,FALSE()) 9.99999900000000E-001 36060237507.1468 36060237507.1468 TRUE =BETADIST(I88,$J$68,$J$69,0,1,FALSE()) 9.99999999000000E-001 167879759909.416 167879759909.416000 TRUE =BETADIST(I89,$J$68,$J$69,0,1,FALSE()) 9.99999999990000E-001 0 0.000000 TRUE =BETADIST(I91,$J$89,$J$90,0,1,FALSE()) 9.99999999999900E-001 1.33923132 1.339231 TRUE =BETADIST(I92,$J$89,$J$90,0,1,FALSE()) 9.99999999999999E-001 2.64241152 2.642412 TRUE =BETADIST(I93,$J$89,$J$90,0,1,FALSE()) regina 2008-07-06T00:00:00 1-1E-16 1.00000000000000E+000 3.00000000000000E+000 2.66827932 2.668279 TRUE =BETADIST(I94,$J$89,$J$90,0,1,FALSE()) 7.00000000000000E+000 1.88116992 1.881170 TRUE =BETADIST(I95,$J$89,$J$90,0,1,FALSE()) 0.00000000000000E+000 0.984375 0.984375 TRUE =BETADIST(I96,$J$89,$J$90,0,1,FALSE()) 1.00000000000000E-001 0.37158912 0.371589 TRUE =BETADIST(I97,$J$89,$J$90,0,1,FALSE()) 2.00000000000000E-001 0.09001692 0.090017 TRUE =BETADIST(I98,$J$89,$J$90,0,1,FALSE()) 3.00000000000000E-001 0.01032192 0.010322 TRUE =BETADIST(I99,$J$89,$J$90,0,1,FALSE()) 4.00000000000000E-001 0.00020412 0.000204 TRUE =BETADIST(I100,$J$89,$J$90,0,1,FALSE()) 5.00000000000000E-001 0 0.000000 TRUE =BETADIST(I101,$J$89,$J$90,0,1,FALSE()) 6.00000000000000E-001 0 0.000000 TRUE =BETADIST(I102,$J$89,$J$90,0,1,FALSE()) 7.00000000000000E-001 0 0.000000 TRUE =BETADIST(I103,$J$89,$J$90,0,1,FALSE()) 8.00000000000000E-001 2.52E-198 0.000000 TRUE =BETADIST(I104,$J$89,$J$90,0,1,FALSE()) 9.00000000000000E-001 6.3E-97 0.000000 TRUE =BETADIST(I105,$J$89,$J$90,0,1,FALSE()) 1.00000000000000E+000 9.0719999673408E-17 0.000000 TRUE =BETADIST(I106,$J$89,$J$90,0,1,FALSE()) 3.00000000000000E-300 1.23428147474933E-06 0.000001 TRUE =BETADIST(I107,$J$89,$J$90,0,1,FALSE()) 2.00000000000000E-200 0.977929346167603 0.977929 TRUE =BETADIST(I108,$J$89,$J$90,0,1,FALSE()) 1.00000000000000E-100 0.00020412 0.000204 TRUE =BETADIST(I109,$J$89,$J$90,0,1,FALSE()) 5.00000000000000E-050 2.51496252000001E-16 0.000000 TRUE =BETADIST(I110,$J$89,$J$90,0,1,FALSE()) 6.00000000000000E-010 2.51994960018319E-28 0.000000 TRUE =BETADIST(I111,$J$89,$J$90,0,1,FALSE()) 7.00000000000000E-005 2.5199995048281E-40 0.000000 TRUE =BETADIST(I112,$J$89,$J$90,0,1,FALSE()) 8.00000000000000E-002 2.51999956733723E-52 0.000000 TRUE =BETADIST(I113,$J$89,$J$90,0,1,FALSE()) 9.00000000000000E-001 2.52016912143431E-64 0.000000 TRUE =BETADIST(I114,$J$89,$J$90,0,1,FALSE()) 9.99000000000000E-001 2.50793904172239E-76 0.000000 TRUE =BETADIST(I115,$J$89,$J$90,0,1,FALSE()) 9.99990000000000E-001 1.23709155325503E-88 0.000000 TRUE =BETADIST(I116,$J$89,$J$90,0,1,FALSE()) 9.99999900000000E-001 4.71912976552974E-94 0.000000 TRUE =BETADIST(I117,$J$89,$J$90,0,1,FALSE()) 9.99999999000000E-001 0 0.000000 TRUE =BETADIST(I118,$J$89,$J$90,0,1,FALSE()) 9.99999999990000E-001 0 0.000000 TRUE =BETADIST(I120,$J$118,$J$119,0,1,FALSE()) 9.99999999999900E-001 1.66200213599109E-13 0.000000 TRUE =BETADIST(I121,$J$118,$J$119,0,1,FALSE()) 9.99999999999999E-001 3.17470115754559E-37 0.000000 TRUE =BETADIST(I122,$J$118,$J$119,0,1,FALSE()) regina 2008-07-06T00:00:00 1-1E-16 1.00000000000000E+000 4.17127538659272E-65 0.000000 TRUE =BETADIST(I123,$J$118,$J$119,0,1,FALSE()) 1.00000000000000E+000 7.00000000000000E+000 9.19291525916191E-98 0.000000 TRUE =BETADIST(I124,$J$118,$J$119,0,1,FALSE()) 5.00000000000000E+002 1.08011887912289E-136 0.000000 TRUE =BETADIST(I125,$J$118,$J$119,0,1,FALSE()) 0.00000000000000E+000 1.41404275937475E-184 0.000000 TRUE =BETADIST(I126,$J$118,$J$119,0,1,FALSE()) 1.00000000000000E-001 1.61329472047363E-246 0.000000 TRUE =BETADIST(I127,$J$118,$J$119,0,1,FALSE()) 2.00000000000000E-001 0 0.000000 TRUE =BETADIST(I128,$J$118,$J$119,0,1,FALSE()) 3.00000000000000E-001 0 0.000000 TRUE =BETADIST(I129,$J$118,$J$119,0,1,FALSE()) 4.00000000000000E-001 0 0.000000 TRUE =BETADIST(I130,$J$118,$J$119,0,1,FALSE()) 5.00000000000000E-001 0 0.000000 TRUE =BETADIST(I131,$J$118,$J$119,0,1,FALSE()) 6.00000000000000E-001 0 0.000000 TRUE =BETADIST(I132,$J$118,$J$119,0,1,FALSE()) 7.00000000000000E-001 0 0.000000 TRUE =BETADIST(I133,$J$118,$J$119,0,1,FALSE()) 8.00000000000000E-001 1.76782549716609E-280 0.000000 TRUE =BETADIST(I134,$J$118,$J$119,0,1,FALSE()) 9.00000000000000E-001 5.27869706888772E-40 0.000000 TRUE =BETADIST(I135,$J$118,$J$119,0,1,FALSE()) 1.00000000000000E+000 1.28539666929823E-09 0.000000 TRUE =BETADIST(I136,$J$118,$J$119,0,1,FALSE()) 3.00000000000000E-300 2.52513810033322E-09 0.000000 TRUE =BETADIST(I137,$J$118,$J$119,0,1,FALSE()) 2.00000000000000E-200 0 0.000000 TRUE =BETADIST(I138,$J$118,$J$119,0,1,FALSE()) 1.00000000000000E-100 0 0.000000 TRUE =BETADIST(I139,$J$118,$J$119,0,1,FALSE()) 5.00000000000000E-050 0 0.000000 TRUE =BETADIST(I140,$J$118,$J$119,0,1,FALSE()) 6.00000000000000E-010 0 0.000000 TRUE =BETADIST(I141,$J$118,$J$119,0,1,FALSE()) 7.00000000000000E-005 0 0.000000 TRUE =BETADIST(I142,$J$118,$J$119,0,1,FALSE()) 8.00000000000000E-002 0 0.000000 TRUE =BETADIST(I143,$J$118,$J$119,0,1,FALSE()) 9.00000000000000E-001 0 0.000000 TRUE =BETADIST(I144,$J$118,$J$119,0,1,FALSE()) 9.99000000000000E-001 0 0.000000 TRUE =BETADIST(I145,$J$118,$J$119,0,1,FALSE()) 9.99990000000000E-001 0 0.000000 TRUE =BETADIST(I146,$J$118,$J$119,0,1,FALSE()) 9.99999900000000E-001 0 0.000000 TRUE =BETADIST(I147,$J$118,$J$119,0,1,FALSE()) 9.99999999000000E-001 9.99999999990000E-001 9.99999999999900E-001 9.99999999999999E-001 regina 2008-07-06T00:00:00 1-1E-16 1.00000000000000E+000 1.00000000000000E+000 4