Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer A-D using excel spreadsheet. Numeric Applications 7. The average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13,

Answer A-D using excel spreadsheet. Numeric

image text in transcribed
Applications 7. The average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13, 2012). The average commute times in minutes for 48 cities are as follows: ATAC 28.3 ATA file Albuquerque 23.3 Jacksonville 26.2 Phoenix Atlanta 28.3 Kansas City 23.4 Pittsburgh 25.0 nmute Time Austin 24.6 Las Vegas 28.4 Portland 26.4 Baltimore 32.1 Little Rock 20.1 Providence 23.6 Boston 31.7 Los Angeles 32.2 Richmond 23.4 Charlotte 25.8 Louisville 21.4 -121 Sacramento 25.8 Chicago 38.1 Memphis 23.8 Salt Lake City 20.2 - 2. Cincinnati 24.9 Miami 30.7 San Antonio 26.1 Cleveland 26.8 Milwaukee 24.8 San Diego 24.8 Columbus 23.4 Minneapolis 23.6 San Francisco 32.6 Dallas 28.5 Nashville 10 25.3 San Jose 28.5 Denver 28.1 New Orleans 31.7 Seattle 27.3 Detroit 29.3 New York 43.8 St. Louis 26.8 El Paso 24.4 Oklahoma City 22.0 Tucson 24.0 Fresno 23.0 6 Orlando 27.1 Tulsa 20.1 - & Indianapolis 24.8 Philadelphia 34.2 Washington, DC 32.8 a. What is the mean commute time for these 48 cities? b. Compute the median commute time. c. Compute the mode. d. Compute the third quartile. Sensdorat sonsign

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these Mathematics questions