Homework SourseAn air travel service samples domestic airline flights to ex
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.
Compute the correlation of distance and fare? (Round your answer to 3 decimal places.)
State the decision rule for 0.025 significance level: H0: r ? 0; H1: r > 0. (Round your answer to 2 decimal places.)
Compute the value of the test statistic. (Round your answer to 2 decimal places.)
At the 0.025 significance level, is it reasonable to conclude that the correlation coefficient is greater than zero?
What percentage of the variation in Fare is accounted for by Distance of a flight? (Round your answer to the nearest whole number.)
Determine the regression equation. (Round your answers to 5 decimal places.)
How much does each additional mile add to the fare? (Round your answer to 5 decimal places.)
Estimate the fare for a 1,500-mile flight. (Round your answer to 2 decimal places.)
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. Origin Destination Distance Fare Detroit, MI Myrtle Beach, SC 636 $261 Baltimore, MD Sacramento, CA 2,395 285 Las Vegas, NV Philadelphia, PA 2,176 347 Sacramento, CA Seattle, WA 605 335 Atlanta, GA Orlando, FL 403 324 Boston, MA Miami, FL 1,258 164 Chicago, IL Covington, KY 264 148 Columbus, OH Minneapolis, MN 627 111 Fort Lauderdale, FL Los Angeles, CA 2,342 329 Chicago, IL Indianapolis, IN 177 320 Philadelphia, PA San Francisco, CA 2,521 324 Houston, TX Raleigh/Durham, NC 1,050 287 Houston, TX Midland/Odessa, TX 441 188 Cleveland, OH Dallas/Ft.Worth, TX 1,021 262 Baltimore, MD Columbus, OH 336 309 Boston, MA Covington, KY 752 181 Kansas City, MO San Diego, CA 1,333 246 Milwaukee, WI Phoenix, AZ 1,460 254 Portland, OR Washington, DC 2,350 348 Phoenix, AZ San Jose, CA 621 339 Baltimore, MD St. Louis, MO 737 166 Houston, TX Orlando, FL 853 207 Houston, TX Seattle, WA 1,894 275 Burbank, CA New York, NY 2,465 101 Atlanta, GA San Diego, CA 1,891 116 Minneapolis, MN New York, NY 1,028 253 Atlanta, GA West Palm Beach, FL 545 188 Kansas City, MO Seattle, WA 1,489 236 Baltimore, MD Portland, ME 452 209 New Orleans, LA Washington, DC 969 228 Picture Click here for the Excel Data File (b-1) Compute the correlation of distance and fare? (Round your answer to 3 decimal places.) Distance and fare .15 (b-2) State the decision rule for 0.025 significance level: H0: r ? 0; H1: r > 0. (Round your answer to 2 decimal places.) Reject H0 if t > 2.00 (b-3) Compute the value of the test statistic. (Round your answer to 2 decimal places.) Value of the test statistic 1.89 (b-4) At the 0.025 significance level, is it reasonable to conclude that the correlation coefficient is greater than zero? H0. There enough evidence to conclude that a positive correlation exists. (c) What percentage of the variation in Fare is accounted for by Distance of a flight? (Round your answer to the nearest whole number.) Percentage of variation 85 % (d-1) Determine the regression equation. (Round your answers to 5 decimal places.) The regression equation is Fare = 1.59 + .0758 Distance. (d-2) How much does each additional mile add to the fare? (Round your answer to 5 decimal places.) No. of additional miles $ (d-3) Estimate the fare for a 1,500-mile flight. (Round your answer to 2 decimal places.) 1,500-mile flight fare $
| 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. |
Solution
