Using Excel, calculate the elasticity of demand for the Washington Nationals from 2008 to 2016. What is the elasticity coefficient?...
michaelovermyerUsing 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 | |
2007 | 21.11 | |
2008 | 25 | |
2009 | 30.63 | |
2010 | 30.63 | |
2011 | 30.54 | |
2012 | 30.54 | |
2013 | 35.24 | |
2014 | 35.24 | |
2015 | 36.02 | |
2016 | 36.59 | |
Year (Attendance) | Average Home Attendance | |
2006 | 26580 | |
2007 | 24217 | |
2008 | 29005 | |
2009 | 22715 | |
2010 | 22568 | |
2011 | 24877 | |
2012 | 30010 | |
2013 | 32745 | |
2014 | 31844 | |
2015 | 32343 |
- 7 years ago
- 20
Answer(1)
Purchase the answer to view it
NOT RATED
- elasticity.xlsx
Bids(1)
other Questions(10)
- questions
- ACC 225 Week 5 DQ 1
- International Trade
- FIN 534 Week 10 Discussion 2
- Explain the impact Roman culture and belief had on the development of Christianity.
- Math Expert Needed
- You have kicked off the District 4 Production Warehouse Move project, your contractors are in place and working on receiving the proper building permits. You originally were told the permits would only take 2 weeks to obtain but the contractors are tellin
- simple task
- MGT Organizational Behavior Take Home Exam
- find this vocabulary words