Results 1 to 3 of 3

Thread: price elasticity

  1. #1

    price elasticity

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a file which I have attached and I have been (for a week) trying to see how to calculate (1) price sensitivity and price elasticity when a price is increased by a certain percentage.
    What I have historical data (2010 and 2011relating to
    1. number fo students in a program per month/quater and year
    2. The price per program per month/qauter and year.

    I want to increase the school fees by say 4% in 2012. By increasing the price, will it have a positive/negative effect on the number of student that might enrol for 2012 by month/quater/year?
    How can I show this using a chart and pv table?

    I will really appreciate your assisatnce.
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    Wowsers... it's been a LONG time since I did any elasticity exercises.

    I see Microsoft has a template for calculating price elasticity here:

    And Wikipedia has an article here:

    Honestly, I'm going to be much help to you on this one. I can certainly help you implement formulas and such, but I'm going to need you to do the research to figure out what calculations need to get in there.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3

    Apologies for late response. Got your response in my spam box.
    Thanks for the link oyu sent and will really appreciate your help on this one.
    My excel skil is next to nothing but I need to get this one right.

    Please let me know what you need from me to get this started.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts