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. Flights.xlsx is shown below 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 Are round trips to Atlanta cheaper than round trips to Salt Lake City. Perform a test with a 95% level of confidence.
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
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.
Flights.xlsx is shown below
| 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 |
Are round trips to Atlanta cheaper than round trips to Salt Lake City. Perform a test with a 95% level of confidence.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
