Originally Posted by
lebowski2222
Wow, that is an excellent analysis, how do you get this data Knope?
The market capacity increase/decreas info came from their schedule.
Mileage and yield came from various tables in the quarterly DoT stats linked below. They have fare and distance, but yield is a clean calculation with those two fields.
http://ostpxweb.dot.gov/aviation/X-5...farereport.htm
A bunch of relatively straightforward formulas and calculations in Excel based on these stats produced the numbers I posted. It can be pretty cumbersome, time consuming, and take a decent amount of thinking things through, but it's all arithmetic.