Dallas 333.90 (a) Compute the mean price for a round-trip flight into Atlanta and the mean price for a round-trip flight into Salt Lake City. (Round your answers to two decimal places.) Atlanta Salt Lake City Is Atlanta less expensive to fly into than Salt Lake City? If so, what could explain this difference? O Yes, half of the departure cities are close to Atlanta and the other half are near Salt Lake City O Yes, Atlanta is generally farther than Salt Lake City to the departure cities O Yes, Atlanta is generally closer than Salt Lake City to the departure cities O No, Atlanta is not less expensive to fly into than Salt Lake City (b) Compute the range, variance, and standard deviation for the round-trip of cost of flights to Atlanta. (Round your answers to two decimal places.) range variance standard deviation Compute the range, variance, and standard deviation for the round-trip of cost of flights to Salt Lake City. (Round your answers to two decimal places.) range variance standard deviation What does this information tell you about the prices for flights into these two cities? The prices for round-trip flights into Atlanta are ---Select--- v the prices for round-trip flights into Salt Lake City. This could be explained by --Select- v relative nearness to the departure cities.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Round-Trip Cost ($)
Departure City
Atlanta
Salt Lake City
Cincinnati
339.10
569.10
New York
321.60
355.60
Chicago
292.60
464.60
Denver
340.60
218.60
Los Angeles
359.60
310.60
Seattle
383.60
296.60
Detroit
310.60
470.60
Philadelphia
416.60
617.40
Washington, D.c.
292.60
512.60
Miami
250.60
523.20
San Francisco
538.60
382.60
Las Vegas
455.60
159.60
Phoenix
358.60
267.60
Dallas
333.90
458.60
(a) Compute the mean price for a round-trip flight into Atlanta and the mean price for a round-trip flight into Salt Lake City. (Round your answers to two decimal places.)
Atlanta
$
Salt Lake City
$
Is Atlanta less expensive to fly into than Salt Lake City? If so, what could explain this difference?
O Yes, half of the departure cities are close to Atlanta and the other half are near Salt Lake City
O Yes, Atlanta is generally farther than Salt Lake City to the departure cities
O Yes, Atlanta is generally closer than Salt Lake City to the departure cities
O No. Atlanta is not less expensive to fly into than Salt Lake City
Transcribed Image Text:Round-Trip Cost ($) Departure City Atlanta Salt Lake City Cincinnati 339.10 569.10 New York 321.60 355.60 Chicago 292.60 464.60 Denver 340.60 218.60 Los Angeles 359.60 310.60 Seattle 383.60 296.60 Detroit 310.60 470.60 Philadelphia 416.60 617.40 Washington, D.c. 292.60 512.60 Miami 250.60 523.20 San Francisco 538.60 382.60 Las Vegas 455.60 159.60 Phoenix 358.60 267.60 Dallas 333.90 458.60 (a) Compute the mean price for a round-trip flight into Atlanta and the mean price for a round-trip flight into Salt Lake City. (Round your answers to two decimal places.) Atlanta $ Salt Lake City $ Is Atlanta less expensive to fly into than Salt Lake City? If so, what could explain this difference? O Yes, half of the departure cities are close to Atlanta and the other half are near Salt Lake City O Yes, Atlanta is generally farther than Salt Lake City to the departure cities O Yes, Atlanta is generally closer than Salt Lake City to the departure cities O No. Atlanta is not less expensive to fly into than Salt Lake City
Dallas
333.90
458.60
(a) Compute the mean price for a round-trip flight into Atlanta and the mean price for a round-trip flight into Salt Lake City. (Round your answers to two decimal places.)
Atlanta
$
Salt Lake City
24
Is Atlanta less expensive to fly into than Salt Lake City? If so, what could explain this difference?
O Yes, half of the departure cities are close to Atlanta and the other half are near Salt Lake City
O Yes, Atlanta is generally farther than Salt Lake City to the departure cities
O Yes, Atlanta is generally closer than Salt Lake City to the departure cities
O No, Atlanta is not less expensive to fly into than Salt Lake City
(b) Compute the range, variance, and standard deviation for the round-trip of cost of flights to Atlanta. (Round your answers to two decimal places.)
range
$
variance
standard deviation
$
Compute the range, variance, and standard deviation for the round-trip of cost of flights to Salt Lake City. (Round your answers to two decimal places.)
range
variance
standard deviation
$
What does this information tell you about the prices for flights into these two cities?
The prices for round-trip flights into Atlanta are --Select--
v the prices for round-trip flights into Salt Lake City. This could be explained by --Select--
relative nearness to the departure cities.
Transcribed Image Text:Dallas 333.90 458.60 (a) Compute the mean price for a round-trip flight into Atlanta and the mean price for a round-trip flight into Salt Lake City. (Round your answers to two decimal places.) Atlanta $ Salt Lake City 24 Is Atlanta less expensive to fly into than Salt Lake City? If so, what could explain this difference? O Yes, half of the departure cities are close to Atlanta and the other half are near Salt Lake City O Yes, Atlanta is generally farther than Salt Lake City to the departure cities O Yes, Atlanta is generally closer than Salt Lake City to the departure cities O No, Atlanta is not less expensive to fly into than Salt Lake City (b) Compute the range, variance, and standard deviation for the round-trip of cost of flights to Atlanta. (Round your answers to two decimal places.) range $ variance standard deviation $ Compute the range, variance, and standard deviation for the round-trip of cost of flights to Salt Lake City. (Round your answers to two decimal places.) range variance standard deviation $ What does this information tell you about the prices for flights into these two cities? The prices for round-trip flights into Atlanta are --Select-- v the prices for round-trip flights into Salt Lake City. This could be explained by --Select-- relative nearness to the departure cities.
Expert Solution
Step 1

We can calculate such measures in excel easily.

To Calculate mean in excel, we use =average () command.

For Variance we use =var() command.

And =stdev() command to find standard deviation.

We know that Range = maximum observation-minimum Observation

So we find maximum Observation value by using =max() command. 

For minimum we use =min() command. 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Research Ethics
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman