{"id":5270,"date":"2016-05-07T12:20:34","date_gmt":"2016-05-07T17:20:34","guid":{"rendered":"http:\/\/www.ssc.wisc.edu\/~jfrees\/?page_id=5270"},"modified":"2016-12-29T09:33:51","modified_gmt":"2016-12-29T15:33:51","slug":"fund-claims-variables","status":"publish","type":"page","link":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/loss-data-analytics\/introduction-to-loss-data-analytics\/1-4-case-study-wisconsin-property-fund\/fund-claims-variables\/","title":{"rendered":"Claims Variables"},"content":{"rendered":"<p>At a fundamental level, insurance companies accept premiums in exchange for promises to indemnify a policyholder upon the uncertain occurrence of an insured event. This indemnification is known as a <em>claim<\/em>. A positive amount, also known as the <em>severity<\/em> of the claim, is a key financial expenditure for an insurer. The claim amount represents the reimbursement to the policyholder.  <\/p>\n<p>Ignoring expenses, an insurer that examines only amounts paid would be indifferent to two claims of 100 when compared to one claim of 200, even though the number of claims differ. Nonetheless, it is common for insurers to study how often claims arise, known as the <em>frequency<\/em> of claims. The frequency is important for expenses and influences contractual parameters that are written on a per occurrence basis such as  deductibles and policy limits. Claims frequency is routinely monitored by insurance regulators and can be a key driver in the overall indemnification obligation of the insurer. We shall consider the two claims variables, the severity and frequency, as the two main outcome variables that we wish to understand, model, and manage. <\/p>\n<p>To illustrate, in 2010 there were 1,110 policyholders in the property fund. Table 1.2 shows the distribution of the 1,377 claims. Almost two-thirds (63.7%) of the policyholders did not have any claims and an additional 18.8% only had one claim. The remaining  17.5% (=1 &#8211; 0.637 &#8211; 0.188) had more than one claim; the policyholder with the highest number recorded 239 claims. The average number of claims for this sample was 1.24 (=1377\/1110). <\/p>\n<p><span id=\"tablepress-3-description\" class=\"tablepress-table-description tablepress-table-description-id-3\">Table 1.2. 2010 Claims Frequency Distribution<\/span>\n\n<table id=\"tablepress-3\" class=\"tablepress tablepress-id-3\" aria-describedby=\"tablepress-3-description\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1\">\n\t<td class=\"column-1\">Type<\/td><td colspan=\"3\" class=\"column-2\">Number of Claims<\/td><td class=\"column-5\"><\/td><td class=\"column-6\"><\/td><td class=\"column-7\"><\/td><td class=\"column-8\"><\/td><td class=\"column-9\"><\/td><td class=\"column-10\"><\/td><td class=\"column-11\"><\/td><td class=\"column-12\"><\/td>\n<\/tr>\n<tr class=\"row-2\">\n\t<td class=\"column-1\">Number<\/td><td class=\"column-2\">0<\/td><td class=\"column-3\">1<\/td><td class=\"column-4\">2<\/td><td class=\"column-5\">3<\/td><td class=\"column-6\">4<\/td><td class=\"column-7\">5<\/td><td class=\"column-8\">6<\/td><td class=\"column-9\">7<\/td><td class=\"column-10\">8<\/td><td class=\"column-11\">9 or more<\/td><td class=\"column-12\">Sum<\/td>\n<\/tr>\n<tr class=\"row-3\">\n\t<td class=\"column-1\">Count<\/td><td class=\"column-2\">707<\/td><td class=\"column-3\">209<\/td><td class=\"column-4\">86<\/td><td class=\"column-5\">40<\/td><td class=\"column-6\">18<\/td><td class=\"column-7\">12<\/td><td class=\"column-8\">9<\/td><td class=\"column-9\">4<\/td><td class=\"column-10\">6<\/td><td class=\"column-11\">19<\/td><td class=\"column-12\">1,110<\/td>\n<\/tr>\n<tr class=\"row-4\">\n\t<td class=\"column-1\">Proportion<\/td><td class=\"column-2\">0.637<\/td><td class=\"column-3\">0.188<\/td><td class=\"column-4\">0.077<\/td><td class=\"column-5\">0.036<\/td><td class=\"column-6\">0.016<\/td><td class=\"column-7\">0.011<\/td><td class=\"column-8\">0.008<\/td><td class=\"column-9\">0.004<\/td><td class=\"column-10\">0.005<\/td><td class=\"column-11\">0.017<\/td><td class=\"column-12\">1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-3 from cache --><br \/>\n<div class=\"scbb-content-box scbb-content-box-blue\"><br \/>\n<div id=\"test-link-5270\" class=\"sh-link test-link sh-hide\"><a href=\"#\" onclick=\"showhide_toggle('test', 5270, 'Show R Code for Table 1.2', 'Hide R Code'); return false;\" aria-expanded=\"false\"><span id=\"test-toggle-5270\">Show R Code for Table 1.2<\/span><\/a><\/div><div id=\"test-content-5270\" class=\"sh-content test-content sh-hide\" style=\"display: none;\">\n<pre>Insample &lt;- read.csv(&quot;Insample.csv&quot;, header=T,  na.strings=c(&quot;.&quot;), stringsAsFactors=FALSE)\r\nInsample2010 &lt;- subset(Insample, Year==2010)\r\ntable(Insample2010$Freq)<\/pre>\n<p><\/div><\/p><\/div><\/p>\n<p>There are two common approaches for examining the distribution of the claims severity. One common approach is to examine each of the 1,377 claims and construct a distribution from this sample. Another common approach is to examine each insured with at least one claim and construct a distribution from each insured&#8217;s average claim. In our 2010 sample, there were 403 (=1110-707) such policyholders. For 209 of these policyholders with one claim, the average claim equals the only claim they experienced. For the policyholder with highest frequency, the average claim is an average over 239 separately reported claim events. The total severity divided by the number of claims is also known as the <em>pure premium<\/em> or <em>loss cost<\/em>. <\/p>\n<p>Table 1.3 summarizes the sample distribution of average severities from the 403 policyholders; it shows that the average claim amount was 56,330 (all amounts are in US Dollars). However, the average gives only a limited look at the distribution. More information can be gleaned from the summary statistics which show a very large claim in the amount of 12,920,000. Figure 1.2 provides further information about the distribution of sample claims, showing a distribution that is dominated by this single large claim so that the histogram is not very helpful. Even when removing the large claim, you will find a distribution that is skewed to the right. A generally accepted technique is to work with claims in logarithmic units especially for graphical purposes; the corresponding figure in the right-hand panel is much easier to interpret. <\/p>\n<span id=\"tablepress-1-description\" class=\"tablepress-table-description tablepress-table-description-id-1\">Table 1.3. 2010 Average Severity Distribution<\/span>\n\n<table id=\"tablepress-1\" class=\"tablepress tablepress-id-1\" aria-describedby=\"tablepress-1-description\">\n<tbody class=\"row-hover\">\n<tr class=\"row-1\">\n\t<td class=\"column-1\">Minimum<\/td><td class=\"column-2\">First Quartile<\/td><td class=\"column-3\">Median<\/td><td class=\"column-4\">Mean<\/td><td class=\"column-5\">Third Quartile<\/td><td class=\"column-6\">Maximum<\/td>\n<\/tr>\n<tr class=\"row-2\">\n\t<td class=\"column-1\">167<\/td><td class=\"column-2\">2,226<\/td><td class=\"column-3\">4,951<\/td><td class=\"column-4\">56,330<\/td><td class=\"column-5\">11,900<\/td><td class=\"column-6\">12,920,000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-1 from cache -->\n<figure id=\"attachment_5328\" class=\"wp-caption aligncenter\" style=\"max-width: 300px;\" aria-label=\"Figure 1.2: Distribution of Positive Average Severities.\"><a href=\"http:\/\/www.ssc.wisc.edu\/~jfrees\/wp-content\/uploads\/2016\/05\/Severity1.png\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.ssc.wisc.edu\/~jfrees\/wp-content\/uploads\/2016\/05\/Severity1-300x225.png\" alt=\"Figure 1.2: Distribution of Positive Average Severities.\" width=\"300\" height=\"225\" class=\"size-medium wp-image-5328\" srcset=\"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-content\/uploads\/2016\/05\/Severity1-300x225.png 300w, https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-content\/uploads\/2016\/05\/Severity1-768x576.png 768w, https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-content\/uploads\/2016\/05\/Severity1-1024x768.png 1024w, https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-content\/uploads\/2016\/05\/Severity1.png 1600w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption class=\"wp-caption-text\">Figure 1.2: Distribution of Positive Average Severities.<\/figcaption><\/figure>\n<div class=\"scbb-content-box scbb-content-box-blue\"><br \/>\n<div id=\"test1-link-5270\" class=\"sh-link test1-link sh-hide\"><a href=\"#\" onclick=\"showhide_toggle('test1', 5270, 'Show R Code for Table 1.3 and Figure 1.2', 'Hide R Code'); return false;\" aria-expanded=\"false\"><span id=\"test1-toggle-5270\">Show R Code for Table 1.3 and Figure 1.2<\/span><\/a><\/div><div id=\"test1-content-5270\" class=\"sh-content test1-content sh-hide\" style=\"display: none;\">\n<pre>#Table 1.3\r\nInsample &lt;- read.csv(\"Insample.csv\", header=T, na.strings=c(\".\"), stringsAsFactors=FALSE)\r\nInsample2010 &lt;- subset(Insample, Year==2010)\r\nInsamplePos2010 &lt;- subset(Insample2010, yAvg&gt;0)\r\nsummary(InsamplePos2010\\$yAvg)\r\nlength(InsamplePos2010\\$yAvg)\r\n#Figure 1.2\r\npar(mfrow=c(1, 2))\r\nhist(InsamplePos2010\\$yAvg, main=\"\", xlab=\"Average Claims\")\r\nhist(log(InsamplePos2010\\$yAvg), main=\"\", xlab=\"Logarithmic Average Claims\")\r\n<\/pre>\n<p><\/div><\/p><\/div>\n<p><div class=\"alignleft\"><a href=\"https:\/\/users.ssc.wisc.edu\/~ewfrees\/loss-data-analytics\/introduction-to-loss-data-analytics\/1-4-case-study-wisconsin-property-fund\/\" title=\"1.4 Case Study: Wisconsin Property Fund\">&#9668 Previous page<\/a><\/div><div class=\"alignright\"><a href=\"https:\/\/users.ssc.wisc.edu\/~ewfrees\/loss-data-analytics\/introduction-to-loss-data-analytics\/1-4-case-study-wisconsin-property-fund\/fund-rating-variables\/\" title=\"Fund Rating Variables\">Next page &#9658<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>At a fundamental level, insurance companies accept premiums in exchange for promises to indemnify a policyholder upon the uncertain occurrence of an insured event. This indemnification is known as a claim. A positive amount, also &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":5266,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P8cLPd-1n0","acf":[],"_links":{"self":[{"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/pages\/5270"}],"collection":[{"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/comments?post=5270"}],"version-history":[{"count":17,"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/pages\/5270\/revisions"}],"predecessor-version":[{"id":6054,"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/pages\/5270\/revisions\/6054"}],"up":[{"embeddable":true,"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/pages\/5266"}],"wp:attachment":[{"href":"https:\/\/users.ssc.wisc.edu\/~ewfrees\/wp-json\/wp\/v2\/media?parent=5270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}