MCA Semester I · 26MCAC103 Business Statistics using Python
A statistical analysis of 1,676 premium quotes. Age sets most of the price, cover sets some of it, and gender and BMI set almost none.
MIT ADT University · College of Management and Computer Applications
Team: Aditi Naik · Aaisha Khan · Shrinidhi Hegde · Yogesh Kurdule · Siddharth Mane
Guide: Prof. Pradnya Mulay
Ages 76–85 pay about 7.7 times the price of ages 18–25.
Price index by age group, 18–25 = 100
Flat until 35, then it climbs fast. Age carries 88% of the importance in the best model.
Rs 1 crore cover costs Rs 416 per lakh. Rs 5 lakh costs Rs 3,614.
Men and women pay the same. BMI has no link either once age is removed.
Average error of only Rs 296. Log-linear is the one that is easiest to explain.
The question
The premium is the yearly price of a policy. We wanted to know which facts about a person change it, and whether a computer model can predict it.
Data and method
Key words
Finding 1
The average premium is Rs 30,300 and the middle premium (median) is Rs 18,225. The average is higher because a few very costly quotes pull it up.
Rs per year. Bar length is proportional to the value.
Correlation with premium (0 to 1)
*After removing the effect of age. BMI (Body Mass Index) = weight ÷ height², with height in metres.
Age is a very strong link, cover is weak to medium, and BMI shows no link.
Hypothesis tests
A hypothesis test starts by assuming nothing is different, then checks whether the data proves otherwise. The p-value is the chance the result is just luck. Below 0.05 is a real difference. Above 0.05 is no proof of a difference.
| Question | Answer | p-value |
|---|---|---|
| Do men and women pay differently? | No | 0.95 |
| Does age group change the price? | Yes, a lot | < 0.001 |
| Does cover change the price? | Yes, but less | < 0.001 |
| Do older people pay more? | Yes (r = 0.80) | < 0.001 |
Prediction
A model is a formula that predicts price from age, cover and the rest. We built four and compared them to find the one that predicts best and is still easy to explain.
Finds how much price changes when an input changes. The problem is that price grows in a curve, not a line.
Fixes the curve by using age groups and the log of price. Easy to explain in plain words.
Builds 300 small decision trees. Each asks yes/no questions such as age above 50 or cover above 10 lakh. All trees vote and the average is the price. Needs no formula and handles curves.
Random Forest is the most accurate. Log-linear is second and the best one we can still explain to people. The straight line is the weakest.
Test score (R²). Closer to 1 is better.
Importance in the Random Forest
Age 88%, cover 11.5%, BMI and gender almost 0. This matches the hypothesis tests.
Index numbers
An index sets the starting group to 100 and shows every other group as a number against it. The data has no dates, so we compare across age instead of across time.
Example: ages 46–55 pay Rs 14,693 and ages 18–25 pay Rs 7,015. So 14,693 ÷ 7,015 × 100 = 209, which means about 2 times the price.
The price is the same up to age 35. Ages 46–55 pay about 2 times, and ages 76–85 pay about 7.7 times.
Ages 18–25 = 100
Finding 2
When the cover doubles from Rs 5 lakh to Rs 10 lakh, the price rises only 35%.
Average yearly premium in Rs.
Recommendations
Limits of our work
Conclusion