Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An Insurance firm providing tour insurance is facing higher claim frequency. The management decides to collect data from the past few years. You are assigned

An Insurance firm providing tour insurance is facing higher claim frequency. The management decides to collect data from the past few years. You are assigned the task to make a model which predicts the claim status and provide recommendations to management. Use CART, RF & ANN, and compare the models' performances in train and test sets.

2.1 Data Ingestion: Read the dataset. Do the descriptive statistics and do null value condition check, write an inference on it. 2.2 Data Split: Split the data into test and train, build classification model CART, Random Forest, Artificial Neural Network 2.3 Performance Metrics: Check the performance of Predictions on Train and Test sets using Accuracy, Confusion Matrix, Plot ROC curve and get ROC_AUC score for each model 2.4 Final Model: Compare all the model and write an inference which model is best/optimized.

Age,Agency_Code,Type,Claimed,Commision,Channel,Duration,Sales,Product Name,Destination 48,C2B,Airlines,No,0.7,Online,7,2.51,Customised Plan,ASIA 36,EPX,Travel Agency,No,0,Online,34,20,Customised Plan,ASIA 39,CWT,Travel Agency,No,5.94,Online,3,9.9,Customised Plan,Americas 36,EPX,Travel Agency,No,0,Online,4,26,Cancellation Plan,ASIA 33,JZI,Airlines,No,6.3,Online,53,18,Bronze Plan,ASIA 45,JZI,Airlines,Yes,15.75,Online,8,45,Bronze Plan,ASIA 61,CWT,Travel Agency,No,35.64,Online,30,59.4,Customised Plan,Americas 36,EPX,Travel Agency,No,0,Online,16,80,Cancellation Plan,ASIA 36,EPX,Travel Agency,No,0,Online,19,14,Cancellation Plan,ASIA 36,EPX,Travel Agency,No,0,Online,42,43,Cancellation Plan,ASIA 37,C2B,Airlines,Yes,46.96,Online,368,187.85,Silver Plan,ASIA 43,C2B,Airlines,Yes,15.88,Online,77,63.5,Silver Plan,ASIA 36,EPX,Travel Agency,No,0,Online,23,110,Customised Plan,EUROPE 52,C2B,Airlines,Yes,5.88,Online,7,23.5,Bronze Plan,ASIA 31,CWT,Travel Agency,No,23.76,Online,21,39.6,Customised Plan,ASIA 39,C2B,Airlines,Yes,54,Online,366,216,Silver Plan,ASIA 36,EPX,Travel Agency,No,0,Online,2,42,Customised Plan,ASIA 45,CWT,Travel Agency,No,59.4,Online,40,99,Customised Plan,Americas 23,JZI,Airlines,No,18.2,Online,33,52,Bronze Plan,ASIA 29,EPX,Travel Agency,No,0,Online,66,32,Cancellation Plan,ASIA 36,EPX,Travel Agency,No,0,Online,71,62,Cancellation Plan,ASIA 28,C2B,Airlines,No,17.25,Online,8,69,Gold Plan,ASIA 27,C2B,Airlines,Yes,6.25,Online,8,25,Silver Plan,ASIA 36,EPX,Travel Agency,No,0,Online,25,51,Cancellation Plan,ASIA 44,JZI,Airlines,No,14,Online,21,40,Bronze Plan,ASIA 36,EPX,Travel Agency,No,0,Online,29,30,Cancellation Plan,ASIA 36,EPX,Travel Agency,No,0,Online,42,27,Customised Plan,ASIA 36,EPX,Travel Agency,No,0,Online,31,20,Customised Plan,ASIA 46,JZI,Airlines,No,6.3,Online,36,18,Bronze Plan,ASIA 25,JZI,Airlines,No,25.55,Online,70,50,Bronze Plan,Americas 60,JZI,Airlines,No,7.7,Online,11,22,Bronze Plan,ASIA 30,C2B,Airlines,Yes,15,Online,27,60,Bronze Plan,ASIA 36,EPX,Travel Agency,Yes,0,Online,16,42,Customised Plan,ASIA 40,C2B,Airlines,Yes,20.38,Online,32,81.5,Silver Plan,ASIA 25,EPX,Travel Agency,Yes,0,Offline,20,37,Customised Plan,Americas 27,C2B,Airlines,Yes,9.75,Online,90,39,Silver Plan,ASIA 40,EPX,Travel Agency,No,0,Online,17,20,Customised Plan,ASIA 36,EPX,Travel Agency,No,0,Online,77,56,Cancellation Plan,EUROPE 29,JZI,Airlines,No,6.3,Online,4,18,Bronze Plan,ASIA 36,EPX,Travel Agency,No,0,Online,14,28,Customised Plan,ASIA 30,CWT,Travel Agency,Yes,16.25,Online,5,25,Gold Plan,ASIA 33,C2B,Airlines,Yes,7.38,Online,11,29.5,Bronze Plan,ASIA 48,C2B,Airlines,No,3.15,Online,75,11.24,Customised Plan,ASIA 39,EPX,Travel Agency,Yes,0,Online,3,20,Customised Plan,ASIA 36,EPX,Travel Agency,No,0,Online,3,24,Cancellation Plan,ASIA 32,C2B,Airlines,Yes,54,Online,366,216,Silver Plan,ASIA 26,C2B,Airlines,Yes,40.25,Online,366,161,Silver Plan,ASIA 36,EPX,Travel Agency,No,0,Online,35,43,Customised Plan,ASIA 52,JZI,Airlines,No,11.55,Online,90,33,Bronze Plan,ASIA 36,JZI,Airlines,No,7.7,Online,24,22,Bronze Plan,ASIA 32,EPX,Travel Agency,Yes,0,Online,22,17,Cancellation Plan,ASIA 28,C2B,Airlines,Yes,8.38,Online,71,33.5,Bronze Plan,ASIA 40,C2B,Airlines,Yes,63.21,Online,364,252.85,Silver Plan,ASIA 36,EPX,Travel Agency,No,0,Online,13,10,Cancellation Plan,ASIA 36,EPX,Travel Agency,No,0,Online,20,23,Cancellation Plan,ASIA 25,C2B,Airlines,No,7.38,Online,20,29.5,Bronze Plan,ASIA 33,CWT,Travel Agency,Yes,41.58,Online,31,69.3,Customised Plan,ASIA 36,EPX,Travel Agency,Yes,0,Online,17,60,Cancellation Plan,ASIA 36,EPX,Travel Agency,No,0,Online,15,28,Customised Plan,ASIA 26,C2B,Airlines,No,7.64,Online,23,30.55,Bronze Plan,ASIA 26,C2B,Airlines,Yes,10.5,Online,15,42,Silver Plan,ASIA 36,EPX,Travel Agency,No,0,Online,36,19,Cancellation Plan,ASIA 38,JZI,Airlines,No,6.3,Online,6,18,Bronze Plan,ASIA 30,C2B,Airlines,Yes,15,Online,27,60,Bronze Plan,ASIA 42,EPX,Travel Agency,Yes,0,Online,22,112,Customised Plan,Americas 30,EPX,Travel Agency,Yes,0,Online,35,95,Customised Plan,Americas 28,C2B,Airlines,Yes,23.5,Online,42,94,Bronze Plan,ASIA 25,EPX,Travel Agency,No,0,Online,37,10,Cancellation Plan,ASIA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Theory And Practice

Authors: Clifford Gomez

1st Edition

8120345665, 978-8120345669

More Books

Students also viewed these Accounting questions