Difference between revisions of "AY1516 T2 Team Hew - Prediction"

From Analytics Practicum
Jump to navigation Jump to search
Line 34: Line 34:
 
<div style="margin:20px; padding-top:0px; padding-right:20px; padding-left:20px; background: #ffffff; font-family: Trebuchet MS, sans-serif; font-size: 100%; -webkit-border-radius: 10px;-webkit-box-shadow: 1px 1px 2px rgba(0, 0, 0, 0.08); -moz-box-shadow:    1px 1px 2px rgba(0, 0, 0, 0.08);box-shadow: 1px 1px 2px rgba(0, 0, 0, 0.08);">
 
<div style="margin:20px; padding-top:0px; padding-right:20px; padding-left:20px; background: #ffffff; font-family: Trebuchet MS, sans-serif; font-size: 100%; -webkit-border-radius: 10px;-webkit-box-shadow: 1px 1px 2px rgba(0, 0, 0, 0.08); -moz-box-shadow:    1px 1px 2px rgba(0, 0, 0, 0.08);box-shadow: 1px 1px 2px rgba(0, 0, 0, 0.08);">
  
== <p style="font-family:Trebuchet MS; border-left: 6px solid #62b762; padding-left:10px; line-height:40px; height:40px"><b>Distribution Fitting</b></p>==
+
== <p style="font-family:Trebuchet MS; border-left: 6px solid #62b762; padding-left:10px; line-height:40px; height:40px"><b>Claim Amount Distribution Fitting</b></p>==
Vaughn (1996) and a number of actuaries have mentioned that ClaimPaid amounts have to factor in inflation for greater accuracy. However, as the highest inflation rate attained by Indonesia for the time period of study is about 7%, this is rather negligible. We first excluded rows where ClaimPaid = 0 and derived the distribution statistics of:
+
=== Analyze Distribution===
 +
Vaughn (1996) and a number of actuaries have mentioned that ClaimPaid amounts have to factor in inflation for greater accuracy. However, as the highest inflation rate attained by Indonesia for the time period of study is about 7%, this is rather negligible. Using JMP Pro 12, we first excluded rows where ClaimPaid = 0 and derived the distribution statistics of:
 
<br />
 
<br />
 
{| class="wikitable" style="text-align: center; width: 70%; margin-left: auto; margin-right: auto; border: none;"
 
{| class="wikitable" style="text-align: center; width: 70%; margin-left: auto; margin-right: auto; border: none;"
Line 45: Line 46:
 
<br />
 
<br />
 
[[File:ClaimPaidOverall.png|center|Overall Claim amount distribution]]
 
[[File:ClaimPaidOverall.png|center|Overall Claim amount distribution]]
 
+
<br />
 +
From figure above, we can see that there are many instances of small claim amounts, with few instances of extreme values, and the distribution shape is right skewed. Similar distribution shapes for Claim amounts have also been derived from insurance companies based in other regions, as seen in figure below taken from Eling’s research (2011).
 +
<br />
 +
[[File:Eling's_Research.png|center|Eling's Research]]
 +
<br /><br />
 +
===Fit Distribution===
  
 
</div>
 
</div>

Revision as of 10:45, 17 April 2016

Exploratory Analysis Prediction


Claim Amount Distribution Fitting

Analyze Distribution

Vaughn (1996) and a number of actuaries have mentioned that ClaimPaid amounts have to factor in inflation for greater accuracy. However, as the highest inflation rate attained by Indonesia for the time period of study is about 7%, this is rather negligible. Using JMP Pro 12, we first excluded rows where ClaimPaid = 0 and derived the distribution statistics of:

N Min Max Median Mean Standard Deviation
49,066 2,570 3,295,056,701 4,297,418 21,090,896 90,927,485


Overall Claim amount distribution


From figure above, we can see that there are many instances of small claim amounts, with few instances of extreme values, and the distribution shape is right skewed. Similar distribution shapes for Claim amounts have also been derived from insurance companies based in other regions, as seen in figure below taken from Eling’s research (2011).

Eling's Research



Fit Distribution

Linear Regression

Coming Soon

Research & Methodology

Coming Soon

References