Tuesday, June 23, 2015

Classification of customers based on given business rules

Calc has been used to create 500 records of customers (simulated) and business rules have been applied to classify them. The file is available at  https://drive.google.com/file/d/0B6PHuk6I5SxbOWExbnVkaW9ndjA/view?usp=sharing. 
Posted by at

2 comments:

  1. Ankita23 June, 2015

    A) Annual total premium: <1 lac(0), 1-3 lacs(1), 3-8 lacs(2),>8 lacs(3)
    B) Claim history: Yes(0), No(1)
    C) Age: < 30 yrs(0), >=30 yrs(!)
    D) Annual Income: <8 lacs(0), 8-25 lacs(!), > 25 lacs(2)

    1) Excellent customer: Premium>8 lacs, Claims: no, Age<30yrs, Annual Income > 25 lacs
    2) High valued: Premium: 3-8 lacs, Claims: No, Age: any, Annual Income: 8-25 lacs
    3) Valued: Premium: 1-3 lacs, claims: any, age: any, Annual Income< 8 lacs

    ReplyDelete
  2. Unknown29 July, 2015

    Solution file is at https://drive.google.com/open?id=0B5y8cM619JSvTHJMODAzLS04TWM

    ReplyDelete

Subscribe to: Post Comments (Atom)