BUS 530 Module 1 Case

profileantony34
module_1_price_elasticity_of_demand.xlsx

Sheet1

Calculation of the price elasticity of demand
quantity before 1.55 change in quantity quantity after - quantity before 0.1
quantity after 1.65
price before 100 change in price price after - price before -10
price after 90
average quantity (quantity after + quantity before)/2 1.6
average price (price after +price before)/2 95
ARC ELASTICITY -0.59375
In your specific problem all you need to do is change the numbers in colum B4-B7

Sheet2

Sheet3