-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSOA-eda-summary.txt
392 lines (364 loc) · 55.7 KB
/
SOA-eda-summary.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
> str(X2009_15_Data_20180601)
Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 30631099 obs. of 32 variables:
$ Observation Year : int 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 ...
$ Common Company Indicator 57 : int 1 1 1 1 1 1 1 1 1 1 ...
$ Preferred Indicator : int 1 1 1 1 1 1 1 1 1 1 ...
$ Gender : chr "Female" "Female" "Female" "Female" ...
$ Smoker Status : chr "NonSmoker" "NonSmoker" "NonSmoker" "NonSmoker" ...
$ Insurance Plan : chr "Term" "ULSG" "Term" "ULSG" ...
$ Issue Age : int 44 40 44 40 40 40 44 40 40 40 ...
$ Duration : int 9 2 9 2 2 2 9 2 2 2 ...
$ Attained Age : int 52 41 52 41 41 41 52 41 41 41 ...
$ Age Basis : int 0 0 0 0 0 0 0 0 1 1 ...
$ Face Amount Band : chr "100000-249999" "1000000-2499999" "100000-249999" "1000000-2499999" ...
$ Issue Year : int 2000 2008 2000 2008 2007 2008 2000 2008 2007 2008 ...
$ Number of Preferred Classes : int 2 4 2 4 3 4 2 4 3 3 ...
$ Preferred Class : int 1 2 2 4 3 3 2 3 3 3 ...
$ SOA Anticipated Level Term Period : chr "Unknown" "N/A (Not Term)" "Unknown" "N/A (Not Term)" ...
$ SOA Guaranteed Level Term Period : chr "Unknown" "N/A (Not Term)" "5 yr guaranteed" "N/A (Not Term)" ...
$ SOA Post level term indicator : chr "Unknown Level Term Period" "N/A (Not Term)" "Post Level Term" "N/A (Not Term)" ...
$ Select_Ultimate_Indicator : chr "Select" "Select" "Select" "Select" ...
$ Number of Deaths : int 0 0 0 0 0 0 0 0 0 0 ...
$ Death Claim Amount : num 0 0 0 0 0 0 0 0 0 0 ...
$ Policies Exposed : num 2.66 0.364 20.324 0.871 0.173 ...
$ Amount Exposed : num 305327 364384 2742586 871233 517809 ...
$ Expected Death QX7580E by Amount : num 980 292 8804 697 414 ...
$ Expected Death QX2001VBT by Amount : num 666 128 5979 305 181 ...
$ Expected Death QX2008VBT by Amount : num 409.1 98.4 3675.1 235.2 139.8 ...
$ Expected Death QX2008VBTLU by Amount: num 733 200 6582 479 285 ...
$ Expected Death QX2015VBT by Amount : num 332.8 76.5 2989.4 183 108.7 ...
$ Expected Death QX7580E by Policy : num 0.008539 0.000292 0.06524 0.000697 0.000138 ...
$ Expected Death QX2001VBT by Policy : num 5.80e-03 1.28e-04 4.43e-02 3.05e-04 6.04e-05 ...
$ Expected Death QX2008VBT by Policy : num 3.56e-03 9.84e-05 2.72e-02 2.35e-04 4.66e-05 ...
$ Expected Death QX2008VBTLU by Policy: num 6.38e-03 2.00e-04 4.88e-02 4.79e-04 9.49e-05 ...
$ Expected Death QX2015VBT by Policy : num 2.90e-03 7.65e-05 2.22e-02 1.83e-04 3.62e-05 ...
- attr(*, "spec")=List of 2
..$ cols :List of 32
.. ..$ Observation Year : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Common Company Indicator 57 : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Preferred Indicator : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Gender : list()
.. .. ..- attr(*, "class")= chr "collector_character" "collector"
.. ..$ Smoker Status : list()
.. .. ..- attr(*, "class")= chr "collector_character" "collector"
.. ..$ Insurance Plan : list()
.. .. ..- attr(*, "class")= chr "collector_character" "collector"
.. ..$ Issue Age : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Duration : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Attained Age : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Age Basis : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Face Amount Band : list()
.. .. ..- attr(*, "class")= chr "collector_character" "collector"
.. ..$ Issue Year : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Number of Preferred Classes : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Preferred Class : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ SOA Anticipated Level Term Period : list()
.. .. ..- attr(*, "class")= chr "collector_character" "collector"
.. ..$ SOA Guaranteed Level Term Period : list()
.. .. ..- attr(*, "class")= chr "collector_character" "collector"
.. ..$ SOA Post level term indicator : list()
.. .. ..- attr(*, "class")= chr "collector_character" "collector"
.. ..$ Select_Ultimate_Indicator : list()
.. .. ..- attr(*, "class")= chr "collector_character" "collector"
.. ..$ Number of Deaths : list()
.. .. ..- attr(*, "class")= chr "collector_integer" "collector"
.. ..$ Death Claim Amount : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Policies Exposed : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Amount Exposed : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX7580E by Amount : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX2001VBT by Amount : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX2008VBT by Amount : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX2008VBTLU by Amount: list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX2015VBT by Amount : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX7580E by Policy : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX2001VBT by Policy : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX2008VBT by Policy : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX2008VBTLU by Policy: list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
.. ..$ Expected Death QX2015VBT by Policy : list()
.. .. ..- attr(*, "class")= chr "collector_double" "collector"
..$ default: list()
.. ..- attr(*, "class")= chr "collector_guess" "collector"
..- attr(*, "class")= chr "col_spec"
> summary(X2009_15_Data_20180601)
Observation Year Common Company Indicator 57 Preferred Indicator Gender
Min. :2009 Min. :0.000 Min. :0.0000 Length:30631099
1st Qu.:2011 1st Qu.:1.000 1st Qu.:0.0000 Class :character
Median :2013 Median :1.000 Median :1.0000 Mode :character
Mean :2012 Mean :0.928 Mean :0.6386
3rd Qu.:2014 3rd Qu.:1.000 3rd Qu.:1.0000
Max. :2015 Max. :1.000 Max. :1.0000
Smoker Status Insurance Plan Issue Age Duration Attained Age
Length:30631099 Length:30631099 Min. : 0.00 Min. : 1.00 Min. : 0.00
Class :character Class :character 1st Qu.:29.00 1st Qu.: 5.00 1st Qu.: 39.00
Mode :character Mode :character Median :40.00 Median : 10.00 Median : 52.00
Mean :40.36 Mean : 12.43 Mean : 51.79
3rd Qu.:52.00 3rd Qu.: 17.00 3rd Qu.: 64.00
Max. :99.00 Max. :107.00 Max. :120.00
Age Basis Face Amount Band Issue Year Number of Preferred Classes Preferred Class
Min. :0.0000 Length:30631099 Min. :1906 Min. :2 Min. :1
1st Qu.:0.0000 Class :character 1st Qu.:1996 1st Qu.:2 1st Qu.:1
Median :0.0000 Mode :character Median :2003 Median :3 Median :2
Mean :0.4156 Mean :2001 Mean :3 Mean :2
3rd Qu.:1.0000 3rd Qu.:2008 3rd Qu.:3 3rd Qu.:2
Max. :1.0000 Max. :2015 Max. :4 Max. :4
NA's :11069266 NA's :11069266
SOA Anticipated Level Term Period SOA Guaranteed Level Term Period SOA Post level term indicator
Length:30631099 Length:30631099 Length:30631099
Class :character Class :character Class :character
Mode :character Mode :character Mode :character
Select_Ultimate_Indicator Number of Deaths Death Claim Amount Policies Exposed
Length:30631099 Min. : 0.0000 Min. : 0 Min. : 0.000
Class :character 1st Qu.: 0.0000 1st Qu.: 0 1st Qu.: 0.679
Mode :character Median : 0.0000 Median : 0 Median : 1.667
Mean : 0.1124 Mean : 5856 Mean : 11.508
3rd Qu.: 0.0000 3rd Qu.: 0 3rd Qu.: 6.060
Max. :265.0000 Max. :60000000 Max. :14238.956
Amount Exposed Expected Death QX7580E by Amount Expected Death QX2001VBT by Amount
Min. : 0 Min. : 0 Min. : 0
1st Qu.: 68493 1st Qu.: 224 1st Qu.: 176
Median : 326502 Median : 1254 Median : 991
Mean : 2321010 Mean : 12967 Mean : 9596
3rd Qu.: 1424658 3rd Qu.: 6516 3rd Qu.: 4929
Max. :923529987 Max. :10766910 Max. :9573841
Expected Death QX2008VBT by Amount Expected Death QX2008VBTLU by Amount
Min. : 0 Min. : 0
1st Qu.: 129 1st Qu.: 203
Median : 714 Median : 1110
Mean : 7207 Mean : 10072
3rd Qu.: 3508 3rd Qu.: 5414
Max. :7976699 Max. :8071363
Expected Death QX2015VBT by Amount Expected Death QX7580E by Policy
Min. : 0 Min. : 0.0000
1st Qu.: 111 1st Qu.: 0.0017
Median : 614 Median : 0.0073
Mean : 6161 Mean : 0.1682
3rd Qu.: 3007 3rd Qu.: 0.0335
Max. :7742218 Max. :329.4730
Expected Death QX2001VBT by Policy Expected Death QX2008VBT by Policy
Min. : 0.00000 Min. : 0.00000
1st Qu.: 0.00124 1st Qu.: 0.00089
Median : 0.00573 Median : 0.00406
Mean : 0.13876 Mean : 0.11536
3rd Qu.: 0.02676 3rd Qu.: 0.01944
Max. :307.53667 Max. :258.69628
Expected Death QX2008VBTLU by Policy Expected Death QX2015VBT by Policy
Min. : 0.00000 Min. : 0.00000
1st Qu.: 0.00147 1st Qu.: 0.00077
Median : 0.00640 Median : 0.00347
Mean : 0.13856 Mean : 0.10345
3rd Qu.: 0.02854 3rd Qu.: 0.01674
Max. :273.58023 Max. :252.96868
> str(data2)
Classes ‘tbl_df’, ‘tbl’ and 'data.frame': 30631099 obs. of 32 variables:
$ Observation Year : int 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 ...
$ Common Company Indicator 57 : int 1 1 1 1 1 1 1 1 1 1 ...
$ Preferred Indicator : int 1 1 1 1 1 1 1 1 1 1 ...
$ Gender : Factor w/ 2 levels "Female","Male": 1 1 1 1 1 1 1 1 1 1 ...
$ Smoker Status : Factor w/ 3 levels "NonSmoker","Smoker",..: 1 1 1 1 1 1 1 1 1 1 ...
$ Insurance Plan : Factor w/ 7 levels "Other","Perm",..: 3 5 3 5 5 5 3 5 5 5 ...
$ Issue Age : int 44 40 44 40 40 40 44 40 40 40 ...
$ Duration : int 9 2 9 2 2 2 9 2 2 2 ...
$ Attained Age : int 52 41 52 41 41 41 52 41 41 41 ...
$ Age Basis : int 0 0 0 0 0 0 0 0 1 1 ...
$ Face Amount Band : Factor w/ 11 levels "1-9999","10000-24999",..: 3 4 3 4 8 8 3 5 6 6 ...
$ Issue Year : int 2000 2008 2000 2008 2007 2008 2000 2008 2007 2008 ...
$ Number of Preferred Classes : int 2 4 2 4 3 4 2 4 3 3 ...
$ Preferred Class : int 1 2 2 4 3 3 2 3 3 3 ...
$ SOA Anticipated Level Term Period : Factor w/ 9 levels "10 yr anticipated",..: 9 7 9 7 7 7 9 7 7 7 ...
$ SOA Guaranteed Level Term Period : Factor w/ 9 levels "10 yr guaranteed",..: 9 7 6 7 7 7 1 7 7 7 ...
$ SOA Post level term indicator : Factor w/ 5 levels "N/A (Not Term)",..: 4 1 3 1 1 1 5 1 1 1 ...
$ Select_Ultimate_Indicator : Factor w/ 2 levels "Select","Ultimate": 1 1 1 1 1 1 1 1 1 1 ...
$ Number of Deaths : int 0 0 0 0 0 0 0 0 0 0 ...
$ Death Claim Amount : num 0 0 0 0 0 0 0 0 0 0 ...
$ Policies Exposed : num 2.66 0.364 20.324 0.871 0.173 ...
$ Amount Exposed : num 305327 364384 2742586 871233 517809 ...
$ Expected Death QX7580E by Amount : num 980 292 8804 697 414 ...
$ Expected Death QX2001VBT by Amount : num 666 128 5979 305 181 ...
$ Expected Death QX2008VBT by Amount : num 409.1 98.4 3675.1 235.2 139.8 ...
$ Expected Death QX2008VBTLU by Amount: num 733 200 6582 479 285 ...
$ Expected Death QX2015VBT by Amount : num 332.8 76.5 2989.4 183 108.7 ...
$ Expected Death QX7580E by Policy : num 0.008539 0.000292 0.06524 0.000697 0.000138 ...
$ Expected Death QX2001VBT by Policy : num 5.80e-03 1.28e-04 4.43e-02 3.05e-04 6.04e-05 ...
$ Expected Death QX2008VBT by Policy : num 3.56e-03 9.84e-05 2.72e-02 2.35e-04 4.66e-05 ...
$ Expected Death QX2008VBTLU by Policy: num 6.38e-03 2.00e-04 4.88e-02 4.79e-04 9.49e-05 ...
$ Expected Death QX2015VBT by Policy : num 2.90e-03 7.65e-05 2.22e-02 1.83e-04 3.62e-05 ...
> summary(data2)
Observation Year Common Company Indicator 57 Preferred Indicator Gender
Min. :2009 Min. :0.000 Min. :0.0000 Female:14117215
1st Qu.:2011 1st Qu.:1.000 1st Qu.:0.0000 Male :16513884
Median :2013 Median :1.000 Median :1.0000
Mean :2012 Mean :0.928 Mean :0.6386
3rd Qu.:2014 3rd Qu.:1.000 3rd Qu.:1.0000
Max. :2015 Max. :1.000 Max. :1.0000
Smoker Status Insurance Plan Issue Age Duration Attained Age
NonSmoker:21826433 Other: 236870 Min. : 0.00 Min. : 1.00 Min. : 0.00
Smoker : 6084338 Perm : 5391279 1st Qu.:29.00 1st Qu.: 5.00 1st Qu.: 39.00
Unknown : 2720328 Term :13802908 Median :40.00 Median : 10.00 Median : 52.00
UL : 4488653 Mean :40.36 Mean : 12.43 Mean : 51.79
ULSG : 2668447 3rd Qu.:52.00 3rd Qu.: 17.00 3rd Qu.: 64.00
VL : 2570343 Max. :99.00 Max. :107.00 Max. :120.00
VLSG : 1472599
Age Basis Face Amount Band Issue Year Number of Preferred Classes
Min. :0.0000 100000-249999 :6990396 Min. :1906 Min. :2
1st Qu.:0.0000 250000-499999 :5118305 1st Qu.:1996 1st Qu.:2
Median :0.0000 50000-99999 :4421158 Median :2003 Median :3
Mean :0.4156 500000-999999 :3785924 Mean :2001 Mean :3
3rd Qu.:1.0000 25000-49999 :3040626 3rd Qu.:2008 3rd Qu.:3
Max. :1.0000 1000000-2499999:2719486 Max. :2015 Max. :4
(Other) :4555204 NA's :11069266
Preferred Class SOA Anticipated Level Term Period SOA Guaranteed Level Term Period
Min. :1 N/A (Not Term) :16828191 N/A (Not Term) :16828191
1st Qu.:1 Unknown : 5655138 20 yr guaranteed: 3096469
Median :2 20 yr anticipated: 2323296 10 yr guaranteed: 3071930
Mean :2 10 yr anticipated: 1755502 15 yr guaranteed: 2170761
3rd Qu.:2 15 yr anticipated: 1490717 Unknown : 2079337
Max. :4 30 yr anticipated: 1077953 30 yr guaranteed: 1280182
NA's :11069266 (Other) : 1500302 (Other) : 2104229
SOA Post level term indicator Select_Ultimate_Indicator Number of Deaths
N/A (Not Term) :16828191 Select :26236931 Min. : 0.0000
Not Level Term : 584787 Ultimate: 4394168 1st Qu.: 0.0000
Post Level Term : 1929331 Median : 0.0000
Unknown Level Term Period: 2079337 Mean : 0.1124
Within Level Term : 9209453 3rd Qu.: 0.0000
Max. :265.0000
Death Claim Amount Policies Exposed Amount Exposed Expected Death QX7580E by Amount
Min. : 0 Min. : 0.000 Min. : 0 Min. : 0
1st Qu.: 0 1st Qu.: 0.679 1st Qu.: 68493 1st Qu.: 224
Median : 0 Median : 1.667 Median : 326502 Median : 1254
Mean : 5856 Mean : 11.508 Mean : 2321010 Mean : 12967
3rd Qu.: 0 3rd Qu.: 6.060 3rd Qu.: 1424658 3rd Qu.: 6516
Max. :60000000 Max. :14238.956 Max. :923529987 Max. :10766910
Expected Death QX2001VBT by Amount Expected Death QX2008VBT by Amount
Min. : 0 Min. : 0
1st Qu.: 176 1st Qu.: 129
Median : 991 Median : 714
Mean : 9596 Mean : 7207
3rd Qu.: 4929 3rd Qu.: 3508
Max. :9573841 Max. :7976699
Expected Death QX2008VBTLU by Amount Expected Death QX2015VBT by Amount
Min. : 0 Min. : 0
1st Qu.: 203 1st Qu.: 111
Median : 1110 Median : 614
Mean : 10072 Mean : 6161
3rd Qu.: 5414 3rd Qu.: 3007
Max. :8071363 Max. :7742218
Expected Death QX7580E by Policy Expected Death QX2001VBT by Policy
Min. : 0.0000 Min. : 0.00000
1st Qu.: 0.0017 1st Qu.: 0.00124
Median : 0.0073 Median : 0.00573
Mean : 0.1682 Mean : 0.13876
3rd Qu.: 0.0335 3rd Qu.: 0.02676
Max. :329.4730 Max. :307.53667
Expected Death QX2008VBT by Policy Expected Death QX2008VBTLU by Policy
Min. : 0.00000 Min. : 0.00000
1st Qu.: 0.00089 1st Qu.: 0.00147
Median : 0.00406 Median : 0.00640
Mean : 0.11536 Mean : 0.13856
3rd Qu.: 0.01944 3rd Qu.: 0.02854
Max. :258.69628 Max. :273.58023
Expected Death QX2015VBT by Policy
Min. : 0.00000
1st Qu.: 0.00077
Median : 0.00347
Mean : 0.10345
3rd Qu.: 0.01674
Max. :252.96868
> skim(data2)
Skim summary statistics
n obs: 30631099
n variables: 32
-- Variable type:factor --------------------------------------------------------
variable missing complete n n_unique
Face Amount Band 0 30631099 30631099 11
Gender 0 30631099 30631099 2
Insurance Plan 0 30631099 30631099 7
Select_Ultimate_Indicator 0 30631099 30631099 2
Smoker Status 0 30631099 30631099 3
SOA Anticipated Level Term Period 0 30631099 30631099 9
SOA Guaranteed Level Term Period 0 30631099 30631099 9
SOA Post level term indicator 0 30631099 30631099 5
top_counts ordered
100: 6990396, 250: 5118305, 500: 4421158, 500: 3785924 FALSE
Mal: 16513884, Fem: 14117215, NA: 0 FALSE
Ter: 13802908, Per: 5391279, UL: 4488653, ULS: 2668447 FALSE
Sel: 26236931, Ult: 4394168, NA: 0 FALSE
Non: 21826433, Smo: 6084338, Unk: 2720328, NA: 0 FALSE
N/A: 16828191, Unk: 5655138, 20 : 2323296, 10 : 1755502 FALSE
N/A: 16828191, 20 : 3096469, 10 : 3071930, 15 : 2170761 FALSE
N/A: 16828191, Wit: 9209453, Unk: 2079337, Pos: 1929331 FALSE
-- Variable type:integer -------------------------------------------------------
variable missing complete n mean sd p0 p25 p50 p75 p100
Age Basis 0 30631099 30631099 0.42 0.49 0 0 0 1 1
Attained Age 0 30631099 30631099 51.79 17.58 0 39 52 64 120
Common Company Indicator 57 0 30631099 30631099 0.93 0.26 0 1 1 1 1
Duration 0 30631099 30631099 12.43 10.22 1 5 10 17 107
Issue Age 0 30631099 30631099 40.36 16.87 0 29 40 52 99
Issue Year 0 30631099 30631099 2000.52 10.28 1906 1996 2003 2008 2015
Number of Deaths 0 30631099 30631099 0.11 1.55 0 0 0 0 265
Number of Preferred Classes 11069266 19561833 30631099 2.83 0.8 2 2 3 3 4
Observation Year 0 30631099 30631099 2012.44 1.91 2009 2011 2013 2014 2015
Preferred Class 11069266 19561833 30631099 1.92 0.89 1 1 2 2 4
Preferred Indicator 0 30631099 30631099 0.64 0.48 0 0 1 1 1
hist
▇▁▁▁▁▁▁▆
▁▂▆▇▆▂▁▁
▁▁▁▁▁▁▁▇
▇▃▁▁▁▁▁▁
▂▃▇▇▆▃▁▁
▁▁▁▁▁▁▅▇
▇▁▁▁▁▁▁▁
▇▁▁▆▁▁▁▅
▃▅▆▇▁▇▇▇
▇▁▇▁▁▃▁▁
▅▁▁▁▁▁▁▇
-- Variable type:numeric -------------------------------------------------------
variable missing complete n mean sd p0
Amount Exposed 0 30631099 30631099 2321010.48 9572807.94 0
Death Claim Amount 0 30631099 30631099 5855.59 107256.5 0
Expected Death QX2001VBT by Amount 0 30631099 30631099 9595.99 42945.78 0
Expected Death QX2001VBT by Policy 0 30631099 30631099 0.14 1.88 0
Expected Death QX2008VBT by Amount 0 30631099 30631099 7206.62 36903.4 0
Expected Death QX2008VBT by Policy 0 30631099 30631099 0.12 1.61 0
Expected Death QX2008VBTLU by Amount 0 30631099 30631099 10072.04 44870.88 0
Expected Death QX2008VBTLU by Policy 0 30631099 30631099 0.14 1.8 0
Expected Death QX2015VBT by Amount 0 30631099 30631099 6160.96 31590 0
Expected Death QX2015VBT by Policy 0 30631099 30631099 0.1 1.49 0
Expected Death QX7580E by Amount 0 30631099 30631099 12966.5 53868.62 0
Expected Death QX7580E by Policy 0 30631099 30631099 0.17 2.18 0
Policies Exposed 0 30631099 30631099 11.51 56.65 0
p25 p50 p75 p100 hist
68493 326502.5 1424657.5 9.2e+08 ▇▁▁▁▁▁▁▁
0 0 0 6e+07 ▇▁▁▁▁▁▁▁
176.4 991.36 4929.5 9573840.56 ▇▁▁▁▁▁▁▁
0.0012 0.0057 0.027 307.54 ▇▁▁▁▁▁▁▁
129.34 714.32 3507.8 8e+06 ▇▁▁▁▁▁▁▁
0.00089 0.0041 0.019 258.7 ▇▁▁▁▁▁▁▁
203.5 1110.49 5414.04 8071362.59 ▇▁▁▁▁▁▁▁
0.0015 0.0064 0.029 273.58 ▇▁▁▁▁▁▁▁
111.3 614.15 3007.43 7742218.05 ▇▁▁▁▁▁▁▁
0.00077 0.0035 0.017 252.97 ▇▁▁▁▁▁▁▁
224.03 1254.18 6516.27 1.1e+07 ▇▁▁▁▁▁▁▁
0.0017 0.0073 0.034 329.47 ▇▁▁▁▁▁▁▁
0.68 1.67 6.06 14238.96 ▇▁▁▁▁▁▁▁