Homeowners Insurance Frees Welcome
Predictive Modeling of Multi-Peril Homeowners Insurance
Edward W. (Jed) Frees, Glenn Meyers and Dave Cummings
University of Wisconsin – Madison and ISO Innovative Analytics
March, 2011
1 / 33
Predictive Modeling of Multi-Peril Homeowners Welcome Insurance - - PowerPoint PPT Presentation
Homeowners Insurance Frees Predictive Modeling of Multi-Peril Homeowners Welcome Insurance Edward W. (Jed) Frees, Glenn Meyers and Dave Cummings University of Wisconsin Madison and ISO Innovative Analytics March, 2011 1 / 33 Outline
Homeowners Insurance Frees Welcome
University of Wisconsin – Madison and ISO Innovative Analytics
1 / 33
Homeowners Insurance Frees Welcome
2
3
4
5
6
2 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
3 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
4 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
4 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
4 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
4 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
5 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
6 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
7 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
8 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
9 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
10 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
11 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
12 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
iβ).
12 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
iβ).
12 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
13 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
13 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
13 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
i,jβ j).
14 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
15 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
16 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
i=1 rij ×rik.
Assuming independence among perils, this has mean and variance E
i=1
rij ×rik
n
i=1
qij ×qik and Var
i=1
rij ×rik
n
i=1
qijqik −(qijqik)2.
i=1 rij ×rik −∑n i=1 qij ×qik
i=1 qijqik −(qijqik)2
16 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
Light Water Water Non Fire ning Wind Hail Weather Weather Liability Other Lightning 1.472 Wind 1.662 1.530 Hail 0.754 0.247
WaterWeath 3.955
3.185
WaterNWeath 2.732 0.837 3.369 1.697 7.429 Liability 1.023
2.436
0.333 1.825 Other 4.048 2.229 3.919
0.478 4.004 4.929 TheftVand 3.085 1.816 2.270
2.227 3.503 1.147 3.766
17 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
18 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
18 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
18 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
19 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
19 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
Dependent Variables Fire Lightning Wind Explanatory Variables Estimate t-statistic Estimate t-statistic Estimate t-statistic Log Fitted Fire 0.3313 25.10
Log Fitted Lightning 0.2200 15.49 0.4120 28.81 Log Fitted Wind
0.2238 15.43 Log Fitted Hail
0.0702 14.04
Log Fitted WaterWeather 0.2167 14.16
Log Fitted WaterNonWeat
0.2822 12.54 0.3442 18.51 Log Fitted Liability
Log Fitted Other
0.0081 0.80
Log Fitted Theft 0.7854 37.76
20 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
21 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
21 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
22 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
500 1000 1500 500 1000 1500 2000 2500 3000 3500 BasicFS INDFreqSev
23 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
Comparison Score Base Basic IND IVFreqSev IND IV Premium FS TW FreqSev A B C Tweedie Maxima ConsPrem 28.81 28.11 28.00 29.42 28.18 29.44 28.46 28.42 29.44 BasicFS
7.15 9.15 7.32 9.09 9.25 9.49 9.49 BasicTW 9.13
10.31 8.79 10.53 9.68 9.54 10.53 INDFreqSev 11.28 8.99
4.42 10.26 9.55 11.09 11.28 IVFreqSevA 7.15 3.98
1.93 4.48 5.07 7.15 IVFreqSevB 11.03 8.52
10.13
8.87 10.32 11.03 IVFreqSevC 7.43 3.89
0.82
4.55 7.43 INDTweedie 8.57 6.82 4.20 7.40 4.25 7.30
8.57 IVTweedie 8.38 6.58 5.40 7.21 5.55 7.50 4.11
24 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
Comparison Score Base Basic IND IVFreqSev IND IV Premium FS TW FreqSev A B C Tweedie Maxima ConsPrem 28.81 28.11 28.00 29.42 28.18 29.44 28.46 28.42 29.44 BasicFS
7.15 9.15 7.32 9.09 9.25 9.49 9.49 BasicTW 9.13
10.31 8.79 10.53 9.68 9.54 10.53 INDFreqSev 11.28 8.99
4.42 10.26 9.55 11.09 11.28 IVFreqSevA 7.15 3.98
1.93 4.48 5.07 7.15 IVFreqSevB 11.03 8.52
10.13
8.87 10.32 11.03 IVFreqSevC 7.43 3.89
0.82
4.55 7.43 INDTweedie 8.57 6.82 4.20 7.40 4.25 7.30
8.57 IVTweedie 8.38 6.58 5.40 7.21 5.55 7.50 4.11
25 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
26 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
26 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
26 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
27 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
27 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
28 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
Table: Shown are coefficients associated with the instruments, logarithmic fitted values.
Dependent Variables Fire Lightning Wind Explanatory Variables Estimate t-statistic Estimate t-statistic Estimate t-statistic Log Fitted Fire 0.3313 25.10
Log Fitted Lightning 0.2200 15.49 0.4120 28.81 Log Fitted Wind
0.2238 15.43 Log Fitted Hail
0.0702 14.04
Log Fitted WaterWeather 0.2167 14.16
Log Fitted WaterNonWeat
0.2822 12.54 0.3442 18.51 Log Fitted Liability
Log Fitted Other
0.0081 0.80
Log Fitted Theft 0.7854 37.76
Dependent Variables Hail Water Weather Water NonWeather Explanatory Variables Estimate t-statistic Estimate t-statistic Estimate t-statistic Log Fitted Fire
0.1162 7.13 0.3789 33.24 Log Fitted Lightning 0.1291 9.36 0.0062 0.51
Log Fitted Wind 0.1194 5.43 0.0504 3.76 0.0329 2.49 Log Fitted Hail
0.0007 0.14 Log Fitted WaterWeather 0.2794 12.64
Log Fitted WaterNonWeat
0.2833 18.16 Log Fitted Liability
Log Fitted Other
0.2419 20.33 0.0449 4.49 Log Fitted Theft 0.4334 27.43 0.2642 14.36 0.0827 5.10 Dependent Variables Liability Other Theft Explanatory Variables Estimate t-statistic Estimate t-statistic Estimate t-statistic Log Fitted Fire 0.6046 50.38
0.2881 25.72 Log Fitted Lightning 0.3883 31.83 0.1874 19.73 0.1567 11.36 Log Fitted Wind
Log Fitted Hail 0.0822 16.12
Log Fitted WaterWeather
0.2708 27.92 0.2515 18.22 Log Fitted WaterNonWeat
0.5306 28.99
Log Fitted Liability
Log Fitted Other 0.1258 12.21 0.1555 16.37 Log Fitted Theft 0.1447 7.13
29 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
1
2
30 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
j=1
31 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
32 / 33
Homeowners Insurance Frees Homeowners Insurance Modeling Home-
Risk Instrumental Variable Approach Out of Sample Validation Appendix
33 / 33