2016-12-29T18:23:56.522000000P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/92a1ad1f36b6d3cc13135a8c0805508933011577
0
0
83842
359833
view1
1
7
0
0
0
0
2
0
0
0
0
0
100
60
true
false
2
326
0
0
0
0
2
0
0
0
291
0
100
60
true
false
Sheet1
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
POISSON.DIST Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple POISSON.DIST formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
Data
k
poisson.dist
lambda
600
lambda
2000
0.927839820186743
0.927839820186743
TRUE
=POISSON.DIST(60,50,1)
2
0
probability mass function
cumulative probabiliy function
probability mass function
cumulative probabiliy function
0.124652019483081
0.124652019483081
TRUE
=POISSON.DIST(I2,I3,1)
5
10
k
poisson.dist 0
poisson.dist 1
k
poisson.dist 0
poisson.dist 1
0.084224337488568
0.084224337488568
TRUE
=POISSON.DIST(I2,I3,0)
50
0
0
1.38389652673674E-87
1.38389652673674E-87
TRUE
=POISSON.DIST(K2,L$14,1)
100
1
1
4.10958494344763E-71
4.10958494344763E-71
TRUE
=POISSON.DIST(K3,L$14,1)
103
2
2
6.815847235588E-37
6.815847235588E-37
TRUE
=POISSON.DIST(K4,L$14,1)
104
3
3.72364121520168E-15
3.72364121520168E-15
TRUE
=POISSON.DIST(K5,L$14,1)
110
4
2.89164740503264E-14
2.89164740503264E-14
TRUE
=POISSON.DIST(K6,L$14,1)
133
5
5.61702953605747E-14
5.61702953605747E-14
TRUE
=POISSON.DIST(K7,L$14,1)
134
6
2.48128607783049E-12
2.48128607783049E-12
TRUE
=POISSON.DIST(K8,L$14,1)
200
7
2.94390018678411E-07
2.94390018678411E-07
TRUE
=POISSON.DIST(K9,L$14,1)
250
8
4.45616628385656E-07
4.45616628385656E-07
TRUE
=POISSON.DIST(K10,L$14,1)
9
0.518794309678685
0.518794309678685
TRUE
=POISSON.DIST(K11,L$14,1)
200
10
0.999715378599712
0.999715378599712
TRUE
=POISSON.DIST(K12,L$14,1)
11
2.65039655300431E-261
2.65039655300431E-261
TRUE
=POISSON.DIST(N4,$O$1,FALSE())
12
1.59023793180259E-258
1.59023793180259E-258
TRUE
=POISSON.DIST(N5,$O$1,FALSE())
13
4.77071379540776E-256
4.77071379540776E-256
TRUE
=POISSON.DIST(N6,$O$1,FALSE())
14
9.54142759081552E-254
9.54142759081552E-254
TRUE
=POISSON.DIST(N7,$O$1,FALSE())
15
1.43121413862233E-251
1.43121413862233E-251
TRUE
=POISSON.DIST(N8,$O$1,FALSE())
16
1.71745696634679E-249
1.71745696634679E-249
TRUE
=POISSON.DIST(N9,$O$1,FALSE())
17
1.71745696634679E-247
1.71745696634679E-247
TRUE
=POISSON.DIST(N10,$O$1,FALSE())
18
1.47210597115439E-245
1.47210597115439E-245
TRUE
=POISSON.DIST(N11,$O$1,FALSE())
19
1.10407947836580E-243
1.1040794783658E-243
TRUE
=POISSON.DIST(N12,$O$1,FALSE())
20
7.36052985577197E-242
7.36052985577197E-242
TRUE
=POISSON.DIST(N13,$O$1,FALSE())
21
4.41631791346318E-240
4.41631791346318E-240
TRUE
=POISSON.DIST(N14,$O$1,FALSE())
22
2.40890068007083E-238
2.40890068007083E-238
TRUE
=POISSON.DIST(N15,$O$1,FALSE())
23
1.20445034003541E-236
1.20445034003541E-236
TRUE
=POISSON.DIST(N16,$O$1,FALSE())
24
5.55900156939422E-235
5.55900156939422E-235
TRUE
=POISSON.DIST(N17,$O$1,FALSE())
25
2.38242924402609E-233
2.38242924402609E-233
TRUE
=POISSON.DIST(N18,$O$1,FALSE())
26
9.52971697610437E-232
9.52971697610437E-232
TRUE
=POISSON.DIST(N19,$O$1,FALSE())
27
3.57364386603914E-230
3.57364386603914E-230
TRUE
=POISSON.DIST(N20,$O$1,FALSE())
28
1.26128607036676E-228
1.26128607036676E-228
TRUE
=POISSON.DIST(N21,$O$1,FALSE())
29
4.20428690122252E-227
4.20428690122252E-227
TRUE
=POISSON.DIST(N22,$O$1,FALSE())
30
1.32766954775448E-225
0.000000
TRUE
=POISSON.DIST(N23,$O$1,FALSE())
31
3.98300864326344E-224
0.000000
TRUE
=POISSON.DIST(N24,$O$1,FALSE())
32
1.13800246950384E-222
0.000000
TRUE
=POISSON.DIST(N25,$O$1,FALSE())
33
3.10364309864684E-221
0.000000
TRUE
=POISSON.DIST(N26,$O$1,FALSE())
34
8.09646025733957E-220
0.000000
TRUE
=POISSON.DIST(N27,$O$1,FALSE())
35
2.02411506433489E-218
0.000000
TRUE
=POISSON.DIST(N28,$O$1,FALSE())
36
4.85787615440374E-217
0.000000
TRUE
=POISSON.DIST(N29,$O$1,FALSE())
37
1.12104834332394E-215
0.000000
TRUE
=POISSON.DIST(N30,$O$1,FALSE())
38
2.49121854071987E-214
0.000000
TRUE
=POISSON.DIST(N31,$O$1,FALSE())
39
5.33832544439972E-213
0.000000
TRUE
=POISSON.DIST(N32,$O$1,FALSE())
40
1.10448112642753E-211
1.10448112642753E-211
TRUE
=POISSON.DIST(N33,$O$1,FALSE())
41
2.20896225285506E-210
2.20896225285506E-210
TRUE
=POISSON.DIST(N34,$O$1,FALSE())
42
4.27541081197753E-209
4.27541081197753E-209
TRUE
=POISSON.DIST(N35,$O$1,FALSE())
43
8.01639527245786E-208
0.000000
TRUE
=POISSON.DIST(N36,$O$1,FALSE())
44
1.45752641317416E-206
1.45752641317416E-206
TRUE
=POISSON.DIST(N37,$O$1,FALSE())
45
2.57210543501322E-205
2.57210543501322E-205
TRUE
=POISSON.DIST(N38,$O$1,FALSE())
46
4.40932360287980E-204
4.4093236028798E-204
TRUE
=POISSON.DIST(N39,$O$1,FALSE())
47
7.34887267146634E-203
7.34887267146634E-203
TRUE
=POISSON.DIST(N40,$O$1,FALSE())
48
1.19170908185941E-201
1.19170908185941E-201
TRUE
=POISSON.DIST(N41,$O$1,FALSE())
49
1.88164591872538E-200
0.000000
TRUE
=POISSON.DIST(N42,$O$1,FALSE())
50
2.89483987496212E-199
0.000000
TRUE
=POISSON.DIST(N43,$O$1,FALSE())
51
4.34225981244318E-198
0.000000
TRUE
=POISSON.DIST(N44,$O$1,FALSE())
52
6.35452655479490E-197
0.000000
TRUE
=POISSON.DIST(N45,$O$1,FALSE())
53
9.07789507827843E-196
0.000000
TRUE
=POISSON.DIST(N46,$O$1,FALSE())
54
1.26668303417839E-194
0.000000
TRUE
=POISSON.DIST(N47,$O$1,FALSE())
55
1.72729504660689E-193
0.000000
TRUE
=POISSON.DIST(N48,$O$1,FALSE())
56
2.30306006214252E-192
0.000000
TRUE
=POISSON.DIST(N49,$O$1,FALSE())
57
3.00399138540328E-191
0.000000
TRUE
=POISSON.DIST(N50,$O$1,FALSE())
58
3.83488261966377E-190
0.000000
TRUE
=POISSON.DIST(N51,$O$1,FALSE())
59
4.79360327457971E-189
0.000000
TRUE
=POISSON.DIST(N52,$O$1,FALSE())
60
5.86971829540372E-188
0.000000
TRUE
=POISSON.DIST(N53,$O$1,FALSE())
61
7.04366195448447E-187
0.000000
TRUE
=POISSON.DIST(N54,$O$1,FALSE())
62
8.28666112292291E-186
0.000000
TRUE
=POISSON.DIST(N55,$O$1,FALSE())
63
9.56153206491104E-185
0.000000
TRUE
=POISSON.DIST(N56,$O$1,FALSE())
64
1.08243759225408E-183
0.000000
TRUE
=POISSON.DIST(N57,$O$1,FALSE())
65
1.20270843583787E-182
0.000000
TRUE
=POISSON.DIST(N58,$O$1,FALSE())
66
1.31204556636858E-181
1.31204556636858E-181
TRUE
=POISSON.DIST(N59,$O$1,FALSE())
67
1.40576310682348E-180
1.40576310682348E-180
TRUE
=POISSON.DIST(N60,$O$1,FALSE())
68
1.47975063876156E-179
1.47975063876156E-179
TRUE
=POISSON.DIST(N61,$O$1,FALSE())
69
1.53077652285679E-178
1.53077652285679E-178
TRUE
=POISSON.DIST(N62,$O$1,FALSE())
70
1.55672188765097E-177
1.55672188765097E-177
TRUE
=POISSON.DIST(N63,$O$1,FALSE())
71
1.55672188765097E-176
1.55672188765097E-176
TRUE
=POISSON.DIST(N64,$O$1,FALSE())
72
1.53120185670587E-175
1.53120185670587E-175
TRUE
=POISSON.DIST(N65,$O$1,FALSE())
73
1.48180824842504E-174
1.48180824842504E-174
TRUE
=POISSON.DIST(N66,$O$1,FALSE())
74
1.41124595088099E-173
1.41124595088099E-173
TRUE
=POISSON.DIST(N67,$O$1,FALSE())
75
1.32304307895092E-172
1.32304307895092E-172
TRUE
=POISSON.DIST(N68,$O$1,FALSE())
76
1.22127053441624E-171
1.22127053441624E-171
TRUE
=POISSON.DIST(N69,$O$1,FALSE())
77
1.11024594037840E-170
1.1102459403784E-170
TRUE
=POISSON.DIST(N70,$O$1,FALSE())
78
9.94250095861252E-170
9.94250095861252E-170
TRUE
=POISSON.DIST(N71,$O$1,FALSE())
79
8.77279496348164E-169
8.77279496348164E-169
TRUE
=POISSON.DIST(N72,$O$1,FALSE())
80
7.62851735954925E-168
7.62851735954925E-168
TRUE
=POISSON.DIST(N73,$O$1,FALSE())
81
6.53872916532793E-167
6.53872916532793E-167
TRUE
=POISSON.DIST(N74,$O$1,FALSE())
82
5.52568661858698E-166
5.52568661858698E-166
TRUE
=POISSON.DIST(N75,$O$1,FALSE())
83
4.60473884882249E-165
4.60473884882249E-165
TRUE
=POISSON.DIST(N76,$O$1,FALSE())
84
3.78471686204588E-164
3.78471686204588E-164
TRUE
=POISSON.DIST(N77,$O$1,FALSE())
85
3.06868934760477E-163
3.06868934760477E-163
TRUE
=POISSON.DIST(N78,$O$1,FALSE())
86
2.45495147808381E-162
2.45495147808381E-162
TRUE
=POISSON.DIST(N79,$O$1,FALSE())
87
1.93811958796091E-161
1.93811958796091E-161
TRUE
=POISSON.DIST(N80,$O$1,FALSE())
88
1.51022305555395E-160
1.51022305555395E-160
TRUE
=POISSON.DIST(N81,$O$1,FALSE())
89
1.16171004273381E-159
1.16171004273381E-159
TRUE
=POISSON.DIST(N82,$O$1,FALSE())
90
8.82311424861121E-159
8.82311424861121E-159
TRUE
=POISSON.DIST(N83,$O$1,FALSE())
91
6.61733568645841E-158
6.61733568645841E-158
TRUE
=POISSON.DIST(N84,$O$1,FALSE())
92
4.90173013811734E-157
4.90173013811734E-157
TRUE
=POISSON.DIST(N85,$O$1,FALSE())
93
3.58663180837854E-156
3.58663180837854E-156
TRUE
=POISSON.DIST(N86,$O$1,FALSE())
94
2.59274588557485E-155
2.59274588557485E-155
TRUE
=POISSON.DIST(N87,$O$1,FALSE())
95
1.85196134683918E-154
1.85196134683918E-154
TRUE
=POISSON.DIST(N88,$O$1,FALSE())
96
1.30726683306295E-153
1.30726683306295E-153
TRUE
=POISSON.DIST(N89,$O$1,FALSE())
97
9.12046627718337E-153
9.12046627718337E-153
TRUE
=POISSON.DIST(N90,$O$1,FALSE())
98
6.28997674288508E-152
6.28997674288508E-152
TRUE
=POISSON.DIST(N91,$O$1,FALSE())
99
4.28862050651255E-151
4.28862050651255E-151
TRUE
=POISSON.DIST(N92,$O$1,FALSE())
100
2.89120483585116E-150
2.89120483585116E-150
TRUE
=POISSON.DIST(N93,$O$1,FALSE())
1.92746989056744E-149
1.92746989056744E-149
TRUE
=POISSON.DIST(N94,$O$1,FALSE())
1.27085926850600E-148
1.270859268506E-148
TRUE
=POISSON.DIST(N95,$O$1,FALSE())
8.28821262069133E-148
8.28821262069133E-148
TRUE
=POISSON.DIST(N96,$O$1,FALSE())
5.34723394883312E-147
5.34723394883312E-147
TRUE
=POISSON.DIST(N97,$O$1,FALSE())
3.41312805244667E-146
3.41312805244667E-146
TRUE
=POISSON.DIST(N98,$O$1,FALSE())
2.15565982259790E-145
2.1556598225979E-145
TRUE
=POISSON.DIST(N99,$O$1,FALSE())
1.34728738912369E-144
1.34728738912369E-144
TRUE
=POISSON.DIST(N100,$O$1,FALSE())
8.33373642756919E-144
8.33373642756919E-144
TRUE
=POISSON.DIST(N101,$O$1,FALSE())
5.10228760871583E-143
5.10228760871583E-143
TRUE
=POISSON.DIST(N102,$O$1,FALSE())
3.09229552043384E-142
3.09229552043384E-142
TRUE
=POISSON.DIST(N103,$O$1,FALSE())
1.85537731226030E-141
1.8553773122603E-141
TRUE
=POISSON.DIST(N104,$O$1,FALSE())
2.65039655300431E-261
2.65039655300431E-261
TRUE
=POISSON.DIST(N4,$O$1,TRUE())
1.59288832835559E-258
1.59288832835559E-258
TRUE
=POISSON.DIST(N5,$O$1,TRUE())
4.78664267869132E-256
4.78664267869132E-256
TRUE
=POISSON.DIST(N6,$O$1,TRUE())
9.58929401760243E-254
9.58929401760243E-254
TRUE
=POISSON.DIST(N7,$O$1,TRUE())
1.44080343263993E-251
1.44080343263993E-251
TRUE
=POISSON.DIST(N8,$O$1,TRUE())
1.73186500067319E-249
1.73186500067319E-249
TRUE
=POISSON.DIST(N9,$O$1,TRUE())
1.73477561635353E-247
1.73477561635353E-247
TRUE
=POISSON.DIST(N10,$O$1,TRUE())
1.48945372731793E-245
1.48945372731793E-245
TRUE
=POISSON.DIST(N11,$O$1,TRUE())
1.11897401563898E-243
1.11897401563898E-243
TRUE
=POISSON.DIST(N12,$O$1,TRUE())
7.47242725733587E-242
7.47242725733587E-242
TRUE
=POISSON.DIST(N13,$O$1,TRUE())
4.49104218603654E-240
4.49104218603654E-240
TRUE
=POISSON.DIST(N14,$O$1,TRUE())
2.45381110193119E-238
2.45381110193119E-238
TRUE
=POISSON.DIST(N15,$O$1,TRUE())
1.22898845105473E-236
1.22898845105473E-236
TRUE
=POISSON.DIST(N16,$O$1,TRUE())
5.68190041449969E-235
5.68190041449969E-235
TRUE
=POISSON.DIST(N17,$O$1,TRUE())
2.43924824817109E-233
2.43924824817109E-233
TRUE
=POISSON.DIST(N18,$O$1,TRUE())
9.77364180092148E-232
9.77364180092148E-232
TRUE
=POISSON.DIST(N19,$O$1,TRUE())
3.67138028404835E-230
3.67138028404835E-230
TRUE
=POISSON.DIST(N20,$O$1,TRUE())
1.29799987320724E-228
1.29799987320724E-228
TRUE
=POISSON.DIST(N21,$O$1,TRUE())
4.33408688854324E-227
4.33408688854324E-227
TRUE
=POISSON.DIST(N22,$O$1,TRUE())
1.37101041663991E-225
1.37101041663991E-225
TRUE
=POISSON.DIST(N23,$O$1,TRUE())
4.12010968492743E-224
4.12010968492743E-224
TRUE
=POISSON.DIST(N24,$O$1,TRUE())
1.17920356635311E-222
1.17920356635311E-222
TRUE
=POISSON.DIST(N25,$O$1,TRUE())
3.22156345528214E-221
3.22156345528214E-221
TRUE
=POISSON.DIST(N26,$O$1,TRUE())
8.41861660286778E-220
8.41861660286778E-220
TRUE
=POISSON.DIST(N27,$O$1,TRUE())
2.10830123036357E-218
2.10830123036357E-218
TRUE
=POISSON.DIST(N28,$O$1,TRUE())
5.06870627744010E-217
5.0687062774401E-217
TRUE
=POISSON.DIST(N29,$O$1,TRUE())
1.17173540609834E-215
1.17173540609834E-215
TRUE
=POISSON.DIST(N30,$O$1,TRUE())
2.60839208132970E-214
2.6083920813297E-214
TRUE
=POISSON.DIST(N31,$O$1,TRUE())
5.59916465253269E-213
5.59916465253269E-213
TRUE
=POISSON.DIST(N32,$O$1,TRUE())
1.16047277295285E-211
1.16047277295285E-211
TRUE
=POISSON.DIST(N33,$O$1,TRUE())
2.32500953015034E-210
2.32500953015034E-210
TRUE
=POISSON.DIST(N34,$O$1,TRUE())
4.50791176499256E-209
4.50791176499256E-209
TRUE
=POISSON.DIST(N35,$O$1,TRUE())
8.46718644895711E-208
8.46718644895711E-208
TRUE
=POISSON.DIST(N36,$O$1,TRUE())
1.54219827766373E-206
1.54219827766373E-206
TRUE
=POISSON.DIST(N37,$O$1,TRUE())
2.72632526277959E-205
2.72632526277959E-205
TRUE
=POISSON.DIST(N38,$O$1,TRUE())
4.68195612915776E-204
0.000000
TRUE
=POISSON.DIST(N39,$O$1,TRUE())
7.81706828438211E-203
0.000000
TRUE
=POISSON.DIST(N40,$O$1,TRUE())
1.26987976470323E-201
0.000000
TRUE
=POISSON.DIST(N41,$O$1,TRUE())
2.00863389519570E-200
0.000000
TRUE
=POISSON.DIST(N42,$O$1,TRUE())
3.09570326448169E-199
0.000000
TRUE
=POISSON.DIST(N43,$O$1,TRUE())
4.65183013889135E-198
0.000000
TRUE
=POISSON.DIST(N44,$O$1,TRUE())
6.81970956868403E-197
0.000000
TRUE
=POISSON.DIST(N45,$O$1,TRUE())
9.75986603514682E-196
0.000000
TRUE
=POISSON.DIST(N46,$O$1,TRUE())
1.36428169452985E-194
0.000000
TRUE
=POISSON.DIST(N47,$O$1,TRUE())
1.86372321605987E-193
0.000000
TRUE
=POISSON.DIST(N48,$O$1,TRUE())
2.48943238374850E-192
0.000000
TRUE
=POISSON.DIST(N49,$O$1,TRUE())
3.25293462377813E-191
0.000000
TRUE
=POISSON.DIST(N50,$O$1,TRUE())
4.16017608204158E-190
0.000000
TRUE
=POISSON.DIST(N51,$O$1,TRUE())
5.20962088278386E-189
0.000000
TRUE
=POISSON.DIST(N52,$O$1,TRUE())
6.39068038368211E-188
0.000000
TRUE
=POISSON.DIST(N53,$O$1,TRUE())
7.68272999285268E-187
0.000000
TRUE
=POISSON.DIST(N54,$O$1,TRUE())
9.05493412220817E-186
0.000000
TRUE
=POISSON.DIST(N55,$O$1,TRUE())
1.04670254771319E-184
0.000000
TRUE
=POISSON.DIST(N56,$O$1,TRUE())
1.18710784702540E-183
0.000000
TRUE
=POISSON.DIST(N57,$O$1,TRUE())
1.32141922054041E-182
0.000000
TRUE
=POISSON.DIST(N58,$O$1,TRUE())
1.44418748842262E-181
0.000000
TRUE
=POISSON.DIST(N59,$O$1,TRUE())
1.55018185566574E-180
0.000000
TRUE
=POISSON.DIST(N60,$O$1,TRUE())
1.63476882432813E-179
0.000000
TRUE
=POISSON.DIST(N61,$O$1,TRUE())
1.69425340528960E-178
0.000000
TRUE
=POISSON.DIST(N62,$O$1,TRUE())
1.72614722817993E-177
0.000000
TRUE
=POISSON.DIST(N63,$O$1,TRUE())
1.72933661046896E-176
0.000000
TRUE
=POISSON.DIST(N64,$O$1,TRUE())
1.70413551775277E-175
0.000000
TRUE
=POISSON.DIST(N65,$O$1,TRUE())
1.65222180020031E-174
0.000000
TRUE
=POISSON.DIST(N66,$O$1,TRUE())
1.57646813090102E-173
0.000000
TRUE
=POISSON.DIST(N67,$O$1,TRUE())
1.48068989204103E-172
0.000000
TRUE
=POISSON.DIST(N68,$O$1,TRUE())
1.36933952362034E-171
0.000000
TRUE
=POISSON.DIST(N69,$O$1,TRUE())
1.24717989274043E-170
0.000000
TRUE
=POISSON.DIST(N70,$O$1,TRUE())
1.11896808513529E-169
0.000000
TRUE
=POISSON.DIST(N71,$O$1,TRUE())
9.89176304861693E-169
0.000000
TRUE
=POISSON.DIST(N72,$O$1,TRUE())
8.61769366441094E-168
0.000000
TRUE
=POISSON.DIST(N73,$O$1,TRUE())
7.40049853176902E-167
0.000000
TRUE
=POISSON.DIST(N74,$O$1,TRUE())
6.26573647176388E-166
0.000000
TRUE
=POISSON.DIST(N75,$O$1,TRUE())
5.23131249599887E-165
0.000000
TRUE
=POISSON.DIST(N76,$O$1,TRUE())
4.30784811164576E-164
0.000000
TRUE
=POISSON.DIST(N77,$O$1,TRUE())
3.49947415876934E-163
0.000000
TRUE
=POISSON.DIST(N78,$O$1,TRUE())
2.80489889396075E-162
0.000000
TRUE
=POISSON.DIST(N79,$O$1,TRUE())
2.21860947735698E-161
0.000000
TRUE
=POISSON.DIST(N80,$O$1,TRUE())
1.73208400328965E-160
0.000000
TRUE
=POISSON.DIST(N81,$O$1,TRUE())
1.33491844306277E-159
0.000000
TRUE
=POISSON.DIST(N82,$O$1,TRUE())
1.01580326916740E-158
0.000000
TRUE
=POISSON.DIST(N83,$O$1,TRUE())
7.63313895562580E-158
0.000000
TRUE
=POISSON.DIST(N84,$O$1,TRUE())
5.66504403367992E-157
0.000000
TRUE
=POISSON.DIST(N85,$O$1,TRUE())
4.15313621174653E-156
0.000000
TRUE
=POISSON.DIST(N86,$O$1,TRUE())
3.00805950674950E-155
0.000000
TRUE
=POISSON.DIST(N87,$O$1,TRUE())
2.15276729751413E-154
0.000000
TRUE
=POISSON.DIST(N88,$O$1,TRUE())
1.52254356281436E-153
0.000000
TRUE
=POISSON.DIST(N89,$O$1,TRUE())
1.06430098399977E-152
0.000000
TRUE
=POISSON.DIST(N90,$O$1,TRUE())
7.35427772688485E-152
0.000000
TRUE
=POISSON.DIST(N91,$O$1,TRUE())
5.02404827920104E-151
0.000000
TRUE
=POISSON.DIST(N92,$O$1,TRUE())
3.39360966377126E-150
0.000000
TRUE
=POISSON.DIST(N93,$O$1,TRUE())
2.26683085694456E-149
0.000000
TRUE
=POISSON.DIST(N94,$O$1,TRUE())
1.49754235420046E-148
0.000000
TRUE
=POISSON.DIST(N95,$O$1,TRUE())
9.78575497489179E-148
0.000000
TRUE
=POISSON.DIST(N96,$O$1,TRUE())
6.32580944632229E-147
0.000000
TRUE
=POISSON.DIST(N97,$O$1,TRUE())
4.04570899707890E-146
0.000000
TRUE
=POISSON.DIST(N98,$O$1,TRUE())
2.56023072230579E-145
0.000000
TRUE
=POISSON.DIST(N99,$O$1,TRUE())
1.60331046135426E-144
0.000000
TRUE
=POISSON.DIST(N100,$O$1,TRUE())
9.93704688892345E-144
0.000000
TRUE
=POISSON.DIST(N101,$O$1,TRUE())
6.09599229760817E-143
0.000000
TRUE
=POISSON.DIST(N102,$O$1,TRUE())
3.70189475019465E-142
0.000000
TRUE
=POISSON.DIST(N103,$O$1,TRUE())
2.22556678727977E-141
0.000000
TRUE
=POISSON.DIST(N104,$O$1,TRUE())
0.00000000000000E+000
0.000000
TRUE
=POISSON.DIST(U4,$V$1,FALSE())
0.00000000000000E+000
0.000000
TRUE
=POISSON.DIST(U5,$V$1,FALSE())
0.00000000000000E+000
0.000000
TRUE
=POISSON.DIST(U6,$V$1,FALSE())
0.00000000000000E+000
0.000000
TRUE
=POISSON.DIST(U4,$V$1,TRUE())
0.00000000000000E+000
0.000000
TRUE
=POISSON.DIST(U5,$V$1,TRUE())
0.00000000000000E+000
0.000000
TRUE
=POISSON.DIST(U6,$V$1,TRUE())
0.00000000000000E+000
0.000000
TRUE
=POISSON.DIST(U552,$V$1,FALSE())
0.00000000000000E+000
0.000000
TRUE
=POISSON.DIST(U553,$V$1,FALSE())
1.00000000000000E-323
0.000000
TRUE
=POISSON.DIST(U554,$V$1,FALSE())
2.50000000000000E-323
0.000000
TRUE
=POISSON.DIST(U555,$V$1,FALSE())
1.00000000000000E-322
0
TRUE
=POISSON.DIST(U556,$V$1,FALSE())
3.55000000000000E-322
0
TRUE
=POISSON.DIST(U557,$V$1,FALSE())
1.27722772277228E-321
0
TRUE
=POISSON.DIST(U558,$V$1,FALSE())
4.60396039603960E-321
0
TRUE
=POISSON.DIST(U559,$V$1,FALSE())
1.65266798418972E-320
0
TRUE
=POISSON.DIST(U560,$V$1,FALSE())
5.93379446640316E-320
0
TRUE
=POISSON.DIST(U561,$V$1,FALSE())
2.12687747035573E-319
0
TRUE
=POISSON.DIST(U562,$V$1,FALSE())
7.60963438735178E-319
0
TRUE
=POISSON.DIST(U563,$V$1,FALSE())
2.71769547731742E-318
0
TRUE
=POISSON.DIST(U564,$V$1,FALSE())
9.68874813489985E-318
0
TRUE
=POISSON.DIST(U565,$V$1,FALSE())
3.44794747885770E-317
0
TRUE
=POISSON.DIST(U566,$V$1,FALSE())
1.22484843918484E-316
0
TRUE
=POISSON.DIST(U567,$V$1,FALSE())
4.34343422565708E-316
0
TRUE
=POISSON.DIST(U568,$V$1,FALSE())
1.53749880936355E-315
0
TRUE
=POISSON.DIST(U569,$V$1,FALSE())
5.43285798799878E-315
0
TRUE
=POISSON.DIST(U570,$V$1,FALSE())
1.91635202067190E-314
0
TRUE
=POISSON.DIST(U571,$V$1,FALSE())
6.74771838224392E-314
0
TRUE
=POISSON.DIST(U572,$V$1,FALSE())
2.37178150504455E-313
0
TRUE
=POISSON.DIST(U573,$V$1,FALSE())
8.32204036859297E-313
0
TRUE
=POISSON.DIST(U574,$V$1,FALSE())
2.91490030427243E-312
0
TRUE
=POISSON.DIST(U575,$V$1,FALSE())
1.01919591058406E-311
0
TRUE
=POISSON.DIST(U576,$V$1,FALSE())
3.55740282926599E-311
0
TRUE
=POISSON.DIST(U577,$V$1,FALSE())
1.23951318092751E-310
0
TRUE
=POISSON.DIST(U578,$V$1,FALSE())
4.31135019453222E-310
0
TRUE
=POISSON.DIST(U579,$V$1,FALSE())
1.49699659532439E-309
0
TRUE
=POISSON.DIST(U580,$V$1,FALSE())
5.18889634427939E-309
0
TRUE
=POISSON.DIST(U581,$V$1,FALSE())
1.79546586307158E-308
0
TRUE
=POISSON.DIST(U582,$V$1,FALSE())
6.20195462200930E-308
0
TRUE
=POISSON.DIST(U583,$V$1,FALSE())
2.13860504207216E-307
2.13860504207216E-307
TRUE
=POISSON.DIST(U584,$V$1,FALSE())
7.36180737373940E-307
7.3618073737394E-307
TRUE
=POISSON.DIST(U585,$V$1,FALSE())
2.52983071262586E-306
2.52983071262586E-306
TRUE
=POISSON.DIST(U586,$V$1,FALSE())
8.67866453731218E-306
8.67866453731218E-306
TRUE
=POISSON.DIST(U587,$V$1,FALSE())
2.97214538949098E-305
2.97214538949098E-305
TRUE
=POISSON.DIST(U588,$V$1,FALSE())
1.01611808187636E-304
1.01611808187636E-304
TRUE
=POISSON.DIST(U589,$V$1,FALSE())
3.46797980162611E-304
3.46797980162611E-304
TRUE
=POISSON.DIST(U590,$V$1,FALSE())
1.18159448096384E-303
1.18159448096384E-303
TRUE
=POISSON.DIST(U591,$V$1,FALSE())
4.01902884681354E-303
4.01902884681354E-303
TRUE
=POISSON.DIST(U592,$V$1,FALSE())
1.36469570350217E-302
1.36469570350217E-302
TRUE
=POISSON.DIST(U593,$V$1,FALSE())
4.62608713051705E-302
4.62608713051705E-302
TRUE
=POISSON.DIST(U594,$V$1,FALSE())
1.56551171929498E-301
1.56551171929498E-301
TRUE
=POISSON.DIST(U595,$V$1,FALSE())
5.28889094356169E-301
5.28889094356169E-301
TRUE
=POISSON.DIST(U596,$V$1,FALSE())
1.78377434858818E-300
1.78377434858818E-300
TRUE
=POISSON.DIST(U597,$V$1,FALSE())
6.00597423767105E-300
6.00597423767105E-300
TRUE
=POISSON.DIST(U598,$V$1,FALSE())
2.01881486980391E-299
2.01881486980391E-299
TRUE
=POISSON.DIST(U599,$V$1,FALSE())
6.77454654297043E-299
6.77454654297043E-299
TRUE
=POISSON.DIST(U600,$V$1,FALSE())
0.00000000000000E+000
0
TRUE
=POISSON.DIST(U552,$V$1,TRUE())
1.00000000000000E-323
0
TRUE
=POISSON.DIST(U553,$V$1,TRUE())
1.00000000000000E-323
0
TRUE
=POISSON.DIST(U554,$V$1,TRUE())
4.00000000000000E-323
0
TRUE
=POISSON.DIST(U555,$V$1,TRUE())
1.35000000000000E-322
0
TRUE
=POISSON.DIST(U556,$V$1,TRUE())
4.95000000000000E-322
0
TRUE
=POISSON.DIST(U557,$V$1,TRUE())
1.76732673267327E-321
0
TRUE
=POISSON.DIST(U558,$V$1,TRUE())
6.37128712871287E-321
0
TRUE
=POISSON.DIST(U559,$V$1,TRUE())
2.28853754940711E-320
0
TRUE
=POISSON.DIST(U560,$V$1,TRUE())
8.22233201581028E-320
0
TRUE
=POISSON.DIST(U561,$V$1,TRUE())
2.94911067193676E-319
0
TRUE
=POISSON.DIST(U562,$V$1,TRUE())
1.05586407248940E-318
0
TRUE
=POISSON.DIST(U563,$V$1,TRUE())
3.77355954980682E-318
0
TRUE
=POISSON.DIST(U564,$V$1,TRUE())
1.34622827902647E-317
0
TRUE
=POISSON.DIST(U565,$V$1,TRUE())
4.79417575788417E-317
0
TRUE
=POISSON.DIST(U566,$V$1,TRUE())
1.70426613340514E-316
0
TRUE
=POISSON.DIST(U567,$V$1,TRUE())
6.04770035906221E-316
0
TRUE
=POISSON.DIST(U568,$V$1,TRUE())
2.14226883630589E-315
0
TRUE
=POISSON.DIST(U569,$V$1,TRUE())
7.57512682430467E-315
0
TRUE
=POISSON.DIST(U570,$V$1,TRUE())
2.67386470197958E-314
0
TRUE
=POISSON.DIST(U571,$V$1,TRUE())
9.42158308372943E-314
0
TRUE
=POISSON.DIST(U572,$V$1,TRUE())
3.31393981342035E-313
0
TRUE
=POISSON.DIST(U573,$V$1,TRUE())
1.16359801821364E-312
0
TRUE
=POISSON.DIST(U574,$V$1,TRUE())
4.07849832249101E-312
0
TRUE
=POISSON.DIST(U575,$V$1,TRUE())
1.42704574283305E-311
0
TRUE
=POISSON.DIST(U576,$V$1,TRUE())
4.98444857209608E-311
0
TRUE
=POISSON.DIST(U577,$V$1,TRUE())
1.73795803813734E-310
0
TRUE
=POISSON.DIST(U578,$V$1,TRUE())
6.04930823267134E-310
0
TRUE
=POISSON.DIST(U579,$V$1,TRUE())
2.10192741859220E-309
0
TRUE
=POISSON.DIST(U580,$V$1,TRUE())
7.29082376286659E-309
0
TRUE
=POISSON.DIST(U581,$V$1,TRUE())
2.52454823935901E-308
0
TRUE
=POISSON.DIST(U582,$V$1,TRUE())
8.72650286137006E-308
0
TRUE
=POISSON.DIST(U583,$V$1,TRUE())
3.01125532820697E-307
3.01125532820697E-307
TRUE
=POISSON.DIST(U584,$V$1,TRUE())
1.03730627019498E-306
1.03730627019498E-306
TRUE
=POISSON.DIST(U585,$V$1,TRUE())
3.56713698282175E-306
3.56713698282175E-306
TRUE
=POISSON.DIST(U586,$V$1,TRUE())
1.22458015201371E-305
1.22458015201371E-305
TRUE
=POISSON.DIST(U587,$V$1,TRUE())
4.19672554150185E-305
4.19672554150185E-305
TRUE
=POISSON.DIST(U588,$V$1,TRUE())
1.43579063602682E-304
1.43579063602682E-304
TRUE
=POISSON.DIST(U589,$V$1,TRUE())
4.90377043765395E-304
4.90377043765395E-304
TRUE
=POISSON.DIST(U590,$V$1,TRUE())
1.67197152472841E-303
1.67197152472841E-303
TRUE
=POISSON.DIST(U591,$V$1,TRUE())
5.69100037154357E-303
5.69100037154357E-303
TRUE
=POISSON.DIST(U592,$V$1,TRUE())
1.93379574065693E-302
1.93379574065693E-302
TRUE
=POISSON.DIST(U593,$V$1,TRUE())
6.55988287117568E-302
6.55988287117568E-302
TRUE
=POISSON.DIST(U594,$V$1,TRUE())
2.22150000641088E-301
2.22150000641088E-301
TRUE
=POISSON.DIST(U595,$V$1,TRUE())
7.51039094997493E-301
7.51039094997493E-301
TRUE
=POISSON.DIST(U596,$V$1,TRUE())
2.53481344358645E-300
2.53481344358645E-300
TRUE
=POISSON.DIST(U597,$V$1,TRUE())
8.54078768125146E-300
8.54078768125146E-300
TRUE
=POISSON.DIST(U598,$V$1,TRUE())
2.87289363792972E-299
2.87289363792972E-299
TRUE
=POISSON.DIST(U599,$V$1,TRUE())
9.64744018090371E-299
9.64744018090371E-299
TRUE
=POISSON.DIST(U600,$V$1,TRUE())
0.001011476198916
0.001011476198916
TRUE
=POISSON.DIST(150,120,0)
0.001569895350401
0.001569895350401
TRUE
=POISSON.DIST(148,120,0)
7.667648073722E-53
7.667648073722E-53
TRUE
=POISSON.DIST(0,120,0)
Err:502
Err:502
TRUE
=POISSON.DIST(-1,120,0)
Err:502
Err:502
TRUE
=POISSON.DIST(148,0,0)
Constraints: l > 0
0.00192874041949
0.00192874041949
TRUE
=POISSON.DIST(148.9,120.9,0)
140
120
0
Err:502
Err:502
TRUE
=POISSON.DIST(0,0,0)
141
121
1
Err:511
Err:511
TRUE
=POISSON.DIST(150,120)
0.006933086674227
0.006933086674227
TRUE
{=POISSON.DIST(I327:I328,J327:J328,K327:K328)}
0.96631353539503
0.96631353539503
TRUE
{=POISSON.DIST(I327:I328,J327:J328,K327:K328)}
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596