Chapter 14.7, Problem 43E

A 2012 suvey conducted by Idea Works provided data showing the percentage of seats available when customers try to redeem points or miles for free travel. For each airline listed, the column labeled 2011 Percentage shows the percentage of seats available in 2011 and the column labeled 2012 shows the correponding percentage in 2012 (The Wall street Journal, May 17, 2012).

Airline	2011 Percentage	2012 Percentage
AirBerlin	96.4	100.0
Air Canada	82.1	78.6
Air France, KLM	65.0	55.7
AirTran Airways	47.1	87.1
Alaska Airlines	64.3	59.3
American Airlines	62.9	45.7
British Airways	61.4	79.3
Cathay Pacific	66.4	70.7
Delta Air Lines	27.1	27.1
Emirates	35.7	32.9
GOL Airlines (Brazil)	100.0	97.1
Iberia	70.7	63.6
JetBlue	79.3	86.4
Lan (Chile)	75.7	78.6
Lufthansa, Swiss, Austrian	85.0	92.1
Qantas	75.0	78.6
SAS Scandinavian	52.9	57.9
Singapore Airlines	90.7	90.7
Southwest	99.3	100.0
Turkish Airways	49.3	38.6
United Airlines	71.4	87.1
US Airways	25.7	33.6
Virgin Australia	91.4	90.0

1. a. Develop a scatter diagram with 2011 Percentage as the independent variable.
2. b. what does the scatter diagram developed in part (a) indicate about the relationship between the two variables?
3. c. Develop the estimated regression equation.
4. d. Test for a significant relationship. Use α = .05.
5. e. Did the estimated regression equation provide a good fit?