Using Excel, calculate the elasticity of demand for the Washington Nationals from 2008 to 2016. What is the elasticity coefficient?...

profilemichaelovermyer

Using Excel, calculate the elasticity of demand for the Washington Nationals from 2008 to 2016. What is the elasticity coefficient? ____________ 

Create a time-series graph that plots the elasticity coefficient (left axis) with the % change in average home ticket prices (right coefficient). Print off that graph and attach to this assignment. 

You'll need to look at my documents for the average attendance and average ticket prices as well.

Year (Tickets)Average Ticket Price  
200721.11 
200825 
200930.63 
201030.63 
201130.54 
201230.54 
201335.24 
201435.24 
201536.02 
201636.59 
   
   
   
   
Year (Attendance)Average Home Attendance 
200626580 
200724217 
200829005 
200922715 
201022568 
201124877 
201230010 
201332745 
201431844 
201532343 
    • 7 years ago
    • 20
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      elasticity.xlsx