BookmarkSubscribeRSS Feed
Ujjawal
Quartz | Level 8

Has anyone worked on Price Elasticity model at customer level? In Insurance Industry, insurance policies from a insurer that have been given a renewal offer in the period of 2 years are taken. Target Variable: (Binary) whether a customer renew an existing insurance contract or policy? I have read somewhere they generally use the treatment - the rate change: percentage change in
premium from the current to the new rate, categorized into ordered values. My question - How price elasticity would be calculated give it's a logistic regression model (binary)?  How can model help in finding the customers which are more sensitive toward policy premium changes?

 

Any help would be highly appreciated!

1 REPLY 1
morglum
Quartz | Level 8

Hmm.

 I never really thought about this before.   Here's an idea for price elasticity:

 

a) compute the parameters of your logitstic regression.

 

For each person in your sample:

b) predict the probability that someone will renew at Price =    Price   based on that person's  characteristics  .This is quantity B

c) predict the probability that someone will renew at Price =    Price - 0.5%    based on that person's  characteristics .This is quantity C.

d) predict the probability that someone will renew at Price =    Price + 0.5%     based on that person's characteristics .This is quantity D.

e)The quantity demanded for that person increases by   (C-D)/ B percent  for each 1% price drop.  

 

 

Average the amount obtained in e)  over your whole population to get average price elasticity.

 

------------- regarding the "finding which customers are more sensible to price changes", you would need to interact the "price" variable with other variables.

For example, you could have  "price" variable  and "price * binary male=1" variable      If the coefficient for "price*male" is greater than 0, then men are more sensitive to price than women.

 

 

 

 

 

 

 

 

 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1555 views
  • 0 likes
  • 2 in conversation