2017-02-24T18:54:26.836995622P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/36de6c50684c8241969a2064d30aff41e0bc5d97
0
0
50173
6972
view1
2
8
0
0
0
0
2
0
0
0
0
0
75
60
true
false
4
1
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
sgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgBJbnB1dFNsb3Q6VHJheTEARHVwbGV4Ok5vbmUAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY=
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
CHISQ.DIST.rt Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple CHISQ.DIST.RT formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
Data
Description
18.307
10
0.020975769403022
0.020975769403022
TRUE
=CHISQ.DIST.RT(13.27, 5)
18.307
Value at which you want to evaluate the distribution
19.307
11
0.050000589091398
0.050000589091398
TRUE
=CHISQ.DIST.RT(I2,I3)
10
Degrees of freedom
20.307
12
Err:502
error
TRUE
=CHISQ.DIST.RT(-13.27, 5)
Tdf #105885
21.307
13
Err:502
Err:502
TRUE
=CHISQ.DIST.RT(13.27, -5)
22.307
14
Err:502
Err:502
TRUE
=CHISQ.DIST.RT(13.27, 0.5)
0.050000589091398
0.050000589091398
TRUE
{=CHISQ.DIST.RT(K1:K5,L1:L5)}
0.055800501996781
0.055800501996781
TRUE
{=CHISQ.DIST.RT(K1:K5,L1:L5)}
0.061496889011824
0.061496889011824
TRUE
{=CHISQ.DIST.RT(K1:K5,L1:L5)}
0.067074267707985
0.067074267707985
TRUE
{=CHISQ.DIST.RT(K1:K5,L1:L5)}
0.072522548628982
0.072522548628982
TRUE
{=CHISQ.DIST.RT(K1:K5,L1:L5)}
0.020975769403022
0.020975769403022
TRUE
=CHISQ.DIST.RT(13.27, 5.9)
4