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 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 City Cost to Fly to Atlanta Cost to Fly to Salt Lake City Cincinnati 340.1 570.1 New York 321.6 354.6 Chicago 291.6 465.6 Denver 339.6 219.6 Los Angeles 359.6 311.6 Seattle 384.6 297.6 Detroit 309.6 471.6 Philadelphia 415.6 618.4 Washington, D.C. 293.6 513.6 Miami 249.6 523.2 San Francisco 539.6 381.6 Las Vegas 455.6 159.6 Phoenix 359.6 267.6 Dallas 333.9 458.6
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 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 City Cost to Fly to Atlanta Cost to Fly to Salt Lake City Cincinnati 340.1 570.1 New York 321.6 354.6 Chicago 291.6 465.6 Denver 339.6 219.6 Los Angeles 359.6 311.6 Seattle 384.6 297.6 Detroit 309.6 471.6 Philadelphia 415.6 618.4 Washington, D.C. 293.6 513.6 Miami 249.6 523.2 San Francisco 539.6 381.6 Las Vegas 455.6 159.6 Phoenix 359.6 267.6 Dallas 333.9 458.6
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 1GP
Related questions
Question
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 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 City | Cost to Fly to Atlanta | Cost to Fly to Salt Lake City |
| Cincinnati | 340.1 | 570.1 |
| New York | 321.6 | 354.6 |
| Chicago | 291.6 | 465.6 |
| Denver | 339.6 | 219.6 |
| Los Angeles | 359.6 | 311.6 |
| Seattle | 384.6 | 297.6 |
| Detroit | 309.6 | 471.6 |
| Philadelphia | 415.6 | 618.4 |
| Washington, D.C. | 293.6 | 513.6 |
| Miami | 249.6 | 523.2 |
| San Francisco | 539.6 | 381.6 |
| Las Vegas | 455.6 | 159.6 |
| Phoenix | 359.6 | 267.6 |
| Dallas | 333.9 | 458.6 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning