Originally Posted by eaj3ncsu
Wordy, yes. Hope that clears it up a little. The spreadsheet may give more insight.
Yes, that is much clear. It may be instructive to also compute the average distance to the top 10 airports from each of those cities in the table. A city that is closer on average to the selected airports will have higher fares out of it (smaller distance flight will have disproportionately higher CPM). So that average distance will point out if the data is skewed by the distance to the selected airports. I am wondering if this factor will completely dominate the table as posted in either direction.