Airfares - 1.S_CODE: 2.S_CITY:startingcity...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1. S_CODE: starting airport’s code 2. S_CITY: starting city 3. E_CODE: ending airport’s code 4. E_CITY: ending city 5. COUPON: average number of coupons (a one-coupon flight is a non-stop flight, a two-coupon flight is a one stop 6. NEW: number of new carriers entering that route between Q3-96 and Q2-97 7. VACATION: whether a vacation route (Yes) or not (No); Florida and Las Vegas routes are generally considered v 8. SW: whether Southwest Airlines serves that route (Yes) or not (No) 9. HI: Herfindel Index – measure of market concentration (refer to BMGT 681) 10. S_INCOME: starting city’s average personal income 11. E_INCOME: ending city’s average personal income 12. S_POP: starting city’s population 13. E_POP: ending city’s population 14. SLOT: whether either endpoint airport is slot controlled or not; this is a measure of airport congestion 15. GATE: whether either endpoint airport has gate constraints or not; this is another measure of airport congestion 16. DISTANCE: distance between two endpoint airports in miles 17. PAX: number of passengers on that route during period of data collection 18. FARE: average fare on that route
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
p flight, etc.) for that route vacation routes
Background image of page 2
S_CODE S_CITY E_CODE E_CITY COUPON NEW VACATION SW HI S_INCOME E_INCOME * Dallas/Fort * Amarillo       1.00 3 No Yes 5291.99 $28,637 $21,112 * Atlanta     * Baltimore/Wash 1.06 3 No No 5419.16 $26,993 $29,838 * Boston      * Baltimore/Wash 1.06 3 No No 9185.28 $30,124 $29,838 ORD Chicago     * Baltimore/Wash 1.06 3 No Yes 2657.35 $29,260 $29,838 MDW Chicago     * Baltimore/Wash 1.06 3 No Yes 2657.35 $29,260 $29,838 * Cleveland   * Baltimore/Wash 1.01 3 No Yes 3408.11 $26,046 $29,838 * Dallas/Fort * Baltimore/Wash 1.28 3 No No 6754.48 $28,637 $29,838 * Fort Lauderd* Baltimore/Wash 1.15 3 Yes Yes 5584.00 $26,752 $29,838 * Houston     * Baltimore/Wash 1.33 3 No Yes 4662.44 $27,211 $29,838 * Kansas City * Baltimore/Wash 1.60 2 No Yes 2617.00 $25,450 $29,838 * Las Vegas   * Baltimore/Wash 1.57 3 Yes Yes 1772.59 $24,575 $29,838 * Los Angeles * Baltimore/Wash 1.50 1 No Yes 3932.29 $24,706 $29,838 * Nashville   * Baltimore/Wash 1.12 3 No Yes 4471.62 $25,995 $29,838 * New Orleans * Baltimore/Wash 1.29 3 No Yes 4356.12 $22,038 $29,838 JFK New York/New* Baltimore/Wash 1.00 3 No No 2626.90 $32,991 $29,838 LGA New York/New* Baltimore/Wash 1.00 3 No No 2626.90 $32,991 $29,838 EWR New York/New* Baltimore/Wash 1.00 3 No No 2626.90 $32,991 $29,838 * Orlando     * Baltimore/Wash 1.13 3 Yes Yes 5706.76 $22,360 $29,838 * Phoenix     * Baltimore/Wash 1.86 3 No Yes 1230.48 $23,025 $29,838 * Salt Lake Ci* Baltimore/Wash 1.93 3 No Yes 2000.67 $21,121 $29,838 * San Diego   * Baltimore/Wash 1.87 3 No Yes 1572.93 $23,903 $29,838 * San Francisc* Baltimore/Wash 1.52 3 No No 2967.59 $38,813 $29,838 * St Louis    * Baltimore/Wash 1.14 3 No Yes 4191.24 $25,824 $29,838 * Tampa       * Baltimore/Wash 1.13 3 Yes Yes 5201.34 $23,654 $29,838 ORD Chicago     * Birmingham     1.16 3 No Yes 3627.46 $29,260 $23,858 MDW Chicago     * Birmingham     1.16 3 No Yes 3627.46 $29,260 $23,858 * Seattle/Taco* Boise          1.07 3 No Yes 5255.24 $30,916 $23,901 * Atlanta     * Boston         1.25 3 No No 5736.34 $26,993 $30,124 JFK New York/New* Buffalo        1.01 3 No No 4040.09 $32,991 $23,184 LGA New York/New* Buffalo        1.01 3 No No 4040.09 $32,991 $23,184 EWR New York/New* Buffalo        1.01 3 No No 4040.09 $32,991 $23,184 JFK New York/New* Charleston     1.34 0 No No 2587.89 $32,991 $18,851 LGA New York/New* Charleston     1.34 3 No No 2587.89 $32,991 $18,851 EWR New York/New* Charleston     1.34 1 No No 2587.89 $32,991 $18,851 * Atlanta     * Charlotte      1.01 3 No No 4435.92 $26,993 $25,237 *
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 26

Airfares - 1.S_CODE: 2.S_CITY:startingcity...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online