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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 1569 views
  • 0 likes
  • 2 in conversation