A sample of round trip flight prices from 14 major U.S. cities to Atlanta and Salt Lake City are contained in the file Flights.xlsx. Based on historical data, round trip flight to Atlanta have a...


A sample of round trip flight prices from 14 major U.S. cities to Atlanta and Salt Lake City are contained in the fileFlights.xlsx. Based on historical data, round trip flight to Atlanta have a variance of $2,500 and round trip flight to Salt Lake City have a variance of $5,625.


Are round trips to Atlanta cheaper than round trips to Salt Lake City. Perform a test with a 95% level of confidence.
















































































Departure CityCost to Fly to AtlantaCost to Fly to Salt Lake City
Cincinnati340.1570.1
New York321.6354.6
Chicago291.6465.6
Denver339.6219.6
Los Angeles359.6311.6
Seattle384.6297.6
Detroit309.6471.6
Philadelphia415.6618.4
Washington, D.C.293.6513.6
Miami249.6523.2
San Francisco539.6381.6
Las Vegas455.6159.6
Phoenix359.6267.6
Dallas333.9458.6


Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here