Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The database Airfares.xlsx contains information on the air- fare on 638 routes in the United States. In addition, it contains data on the length of

The database Airfares.xlsx contains information on the air- fare on 638 routes in the United States. In addition, it contains data on the length of the route, the average income in the starting and ending cities, whether Southwest Airlines flies on the route, and other variables. The goal is to create a Multiple Linear Regression model which predicts the airfare along a given route. The datafile named Airfares HW4 datafile is shared with you 

a. Develop an estimated multiple regression equation which predicts the airfare along a given route. 

b. Which variables are significant? Do you prefer to add all the independent variables to the model? 

c. Interpret the R2 (R-squared). 

d. Interpret the results and please add your comments on the fitting of your model?

S_CODES_CITYE_CODEE_CITYCOUPONNEWVACATIONSWHIS_INCOMEE_INCOMES_POPE_POPSLOTGATEDISTANCEPAXFARE
*Dallas/Fort Worth TX*Amarillo TX1.003NoYes5291.99$28,637$21,1123036732205711FreeFree3127864$64.11
*Atlanta GA*Baltimore/Wash Intl MD1.063NoNo5419.16$26,993$29,83835326577145897FreeFree5768820$174.47
*Boston MA*Baltimore/Wash Intl MD1.063NoNo9185.28$30,124$29,83857872937145897FreeFree3646452$207.76
ORDChicago IL*Baltimore/Wash Intl MD1.063NoYes2657.35$29,260$29,83878303327145897ControlledFree61225144$85.47
MDWChicago IL*Baltimore/Wash Intl MD1.063NoYes2657.35$29,260$29,83878303327145897FreeFree61225144$85.47
*Cleveland OH*Baltimore/Wash Intl MD1.013NoYes3408.11$26,046$29,83822309557145897FreeFree30913386$56.76
*Dallas/Fort Worth TX*Baltimore/Wash Intl MD1.283NoNo6754.48$28,637$29,83830367327145897FreeFree12204625$228.00
*Fort Lauderdale FL*Baltimore/Wash Intl MD1.153YesYes5584.00$26,752$29,83814403777145897FreeFree9215512$116.54
*Houston TX*Baltimore/Wash Intl MD1.333NoYes4662.44$27,211$29,83837701257145897FreeFree12497811$172.63
*Kansas City MO*Baltimore/Wash Intl MD1.602NoYes2617.00$25,450$29,83816948037145897FreeFree9644657$114.76
*Las Vegas NV*Baltimore/Wash Intl MD1.573YesYes1772.59$24,575$29,83811972347145897FreeFree21044489$158.20
*Los Angeles CA*Baltimore/Wash Intl MD1.501NoYes3932.29$24,706$29,83890560767145897FreeFree23297349$228.99
*Nashville TN*Baltimore/Wash Intl MD1.123NoYes4471.62$25,995$29,83811150487145897FreeFree5875654$79.17
*New Orleans LA*Baltimore/Wash Intl MD1.293NoYes4356.12$22,038$29,83813084997145897FreeFree9923525$132.05
JFKNew York/Newark NY*Baltimore/Wash Intl MD1.003NoNo2626.90$32,991$29,83886211217145897ControlledFree1817171$117.23
LGANew York/Newark NY*Baltimore/Wash Intl MD1.003NoNo2626.90$32,991$29,83886211217145897ControlledFree1817171$117.23
EWRNew York/Newark NY*Baltimore/Wash Intl MD1.003NoNo2626.90$32,991$29,83886211217145897FreeConstrained1817171$117.23
*Orlando FL*Baltimore/Wash Intl MD1.133YesYes5706.76$22,360$29,83814212877145897FreeFree78811013$106.11
*Phoenix AZ*Baltimore/Wash Intl MD1.863NoYes1230.48$23,025$29,83827533737145897FreeFree20014408$181.16
*Salt Lake City UT*Baltimore/Wash Intl MD1.933NoYes2000.67$21,121$29,83812288167145897FreeFree18662767$157.50
*San Diego CA*Baltimore/Wash Intl MD1.873NoYes1572.93$23,903$29,83826736207145897FreeFree22903170$200.20
*San Francisco CA*Baltimore/Wash Intl MD1.523NoNo2967.59$38,813$29,83816530177145897FreeFree24546417$246.85
*St Louis MO*Baltimore/Wash Intl MD1.143NoYes4191.24$25,824$29,83825498447145897FreeFree72910264$99.70
*Tampa FL*Baltimore/Wash Intl MD1.133YesYes5201.34$23,654$29,83821952157145897FreeFree8467082$106.77
ORDChicago IL*Birmingham AL1.163NoYes3627.46$29,260$23,8587830332895414ControlledFree5764138$113.50
MDWChicago IL*Birmingham AL1.163NoYes3627.46$29,260$23,8587830332895414FreeFree5764138$113.50
*Seattle/Tacoma WA*Boise ID1.073NoYes5255.24$30,916$23,9012230831372606FreeFree4035995$69.12
*Atlanta GA*Boston MA1.253NoNo5736.34$26,993$30,12435326575787293FreeFree93914005$210.00
JFKNew York/Newark NY*Buffalo NY1.013NoNo4040.09$32,991$23,18486211211173217ControlledFree29112432$134.30

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 flight, etc.) for that route
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 vacation routes
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

Step by Step Solution

3.39 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

ANSWER A Multiple regression formula is used in the analysis of the relationship between dependent and multiple independent variables and the formula is represented by the equation Y is equal to a plu... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Thermodynamics An Engineering Approach

Authors: Yunus A. Cengel, Michael A. Boles

8th edition

73398179, 978-0073398174

More Books

Students also viewed these Accounting questions