View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Price Elasticity
 
Posts: n/a
Default Price elasticity

I have a data set with volume numbers at certain price points. I want to use
the data to determine what might be the outcome at different prices. For
instance:

At $.99 per lb, the average lb sold is 100,000 lbs.
At $1.29, per lb, lbs sold is about 77,000 lbs.
And on. What I am trying to figure out is how much I could expect to sell at
price points where I have no history of sales. Please tell me there is an
easy, uncomplicated way to do this. I am not a statistician.