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

profilemichaelovermyer
Home>Homework Answsers>Business & Finance homework help>Economics homework help

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 
    • 10 years ago
    • 20
    Report issue
    Answer(1)
    profile
    accuratearchy
    3.0 (4)
     (Not rated)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      elasticity.xlsx