An air travel service samples domestic airline flights to explore the relationship between airfare

An air travel service samples domestic airline flights to explore the relationship between airfare and distance. The service would like to know if there is a correlation between airfare and flight distance. If there is a correlation, what percentage of the variation in airfare is accounted for by distance? How much does each additional mile add to the fare? The data follow.

1. Draw a scatter diagram with Distance as the independent variable and Fare as the dependent variable. Is the relationship direct or indirect?
2. Compute the correlation coefficient. At the .05 significance level, is it reasonable to conclude that the correlation coefficient is greater than zero?
3. What percentage of the variation in Fare is accounted for by Distance of a flight?
4. Determine the regression equation. How much does each additional mile add to the fare? Estimate the fare for a 1,500-mile flight.
5. A traveler is planning to fly from Atlanta to London Heathrow. The distance is 4,218 miles. She wants to use the regression equation to estimate the fare. Explain why it would not be good idea to estimate the fare for this international flight with the regression equation.
6. Determine the regression equation used to forecast air fare based on distance travelled.
7. Determine and interpret the correlation coefficient and the coefficient of determination.
8. Forecast the air fare for a 2000 mile trip.
9. Write up a short essay analyzing the regression model.
10. Identify at least one additional variable that could be used to forecast air fare.