2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/3287bc2f91438085b7604773d5e0346fc3c3f452 0 0 85982 17817 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 2 21 0 0 0 0 2 0 0 0 9 0 75 60 true false Sheet2 1241 0 75 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 en US nl NL true true 3 1 true 1 true sgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpMZXR0ZXIAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY= 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 BETA.DIST Function Result TRUE Sheet Result Description 1 TRUE Simple BETA.DIST formulas with local references and values Function Expected Correct FunctionString Comment Data Description 2 3 4 5 year month day value 0.685470581054688 0.685470581054688 TRUE =BETA.DIST(2,8,10,1,1,3) 2 Value at which to evaluate the function 8 9 10 11 2012 12 15 6 1.4837646484375 1.4837646484375 TRUE =BETA.DIST(2,8,10,0,1,3) 8 Parameter of the distribution 10 11 12 13 2012 4 1 10.4 0.685470581054688 0.685470581054688 TRUE =BETA.DIST(I2,I3,I4,1,I5,I6) 10 Parameter of the distribution 1 2 3 4 2013 8 15 7 1.4837646484375 1.4837646484375 TRUE =BETA.DIST(I2,I3,I4,0,I5,I6) Check 5.3 1 Lower bound 3 4 5 6 2011 11 1 12 0.960370937542132 0.960370937542132 TRUE =BETA.DIST(3, 7.5, 9, 1, 1, 4) 3 Upper bound 2011 2 14 8 0.250512508598433 0.250512508598433 TRUE =BETA.DIST(3, 7.5, 9, 0, 1, 4) 2010 6 1 15 0.598190307617188 0.598190307617188 TRUE =BETA.DIST(7.5, 8, 9, 1, 5, 10) 0.62841796875 0.62841796875 TRUE =BETA.DIST(7.5, 8, 9, 0, 5, 10) Err:502 Err:502 TRUE =BETA.DIST(2,8,10,1,1) If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1 Err:502 Err:502 TRUE =BETA.DIST(2,8,10,1,1,) 0.972715513763135 0.972715513763135 TRUE =BETA.DIST(2,8,10,1,,3) 0 0 TRUE =BETA.DIST(1,8,10,1,1,3) If x < A, x > B, or A = B, BETA.DIST returns the #NUM! error value. Err:502 Err:502 TRUE =BETA.DIST(2,0,10,1,1,3) Err:502 Err:502 TRUE =BETA.DIST(2,-8,10,1,1,3) Err:502 Err:502 TRUE =BETA.DIST(2,8,-10,1,1,3) Err:502 Err:502 TRUE =BETA.DIST(2,8,0,1,1,3) Err:502 Err:502 TRUE =BETA.DIST(2,8,10,1,1,1) https://support.office.com/en-US/article/BETA-DIST-function-11188C9C-780A-42C7-BA43-9ECB5A878D31 Err:502 Err:503 TRUE =BETA.DIST(12,8,10,1,1,3) x>B Err:502 Err:504 TRUE =BETA.DIST(1,8,10,1,2,3) x<A Err:502 Err:502 TRUE =BETA.DIST(2,8,10,1,4,1) A>B #NUM! #NUM! TRUE =BETA.DIST(2,8,10,1,2,2) A=B 0.685470581054688 0.685470581054688 TRUE =BETA.DIST(0.5,8,10,1) A and B omitted 0.28222391837318 0.28222391837318 TRUE =BETA.DIST(0.5,8,10,1,0.2) B omitted 0.939123896703809 0.939123896703809 TRUE =BETA.DIST(0.5,8,10,1,,0.8) A omitted 0.685470581054688 0.685470581054688 TRUE {=BETA.DIST(L1:O1,L2:O2,L3:O3,1,L4:O4,L5:O5)} 0.685470581054688 0.685470581054688 TRUE {=BETA.DIST(L1:O1,L2:O2,L3:O3,1,L4:O4,L5:O5)} 0.685470581054688 0.685470581054688 TRUE {=BETA.DIST(L1:O1,L2:O2,L3:O3,1,L4:O4,L5:O5)} 0.685470581054688 0.685470581054688 TRUE {=BETA.DIST(L1:O1,L2:O2,L3:O3,1,L4:O4,L5:O5)} 0.685470581054688 0.685470581054688 TRUE {=BETA.DIST(L1:O1,L2:O2,L3:O3,1,L4:O4,L5:O5)} 4