Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I don't understand what I'm doing wrong for c & d. c. I put in the following formula to find the mode: =MODE(U17:U64) = 22

image text in transcribed

I don't understand what I'm doing wrong for c & d.

c. I put in the following formula to find the mode: =MODE(U17:U64) = 22 It's wrong I don't get it.

d. I put in the following formula to find the Variance: =VARA:U17:U64 = 21.29974734

The following data set is about commute times across the nation.

Albuquerque 21.9
Atlanta 26.9
Austin 23.2
Baltimore 30.7
Boston 30.3
Charlotte 24.4
Chicago 36.7
Cincinnati 23.5
Cleveland 25.4
Columbus 22
Dallas 27.1
Denver 26.7
Detroit 27.9
El Paso 23
Fresno 21.6
Indianapolis 23.4
Jacksonville 24.8
Kansas City 22
Las Vegas 27
Little Rock 18.7
Los Angeles 30.8
Louisville 20
Memphis 22.4
Miami 29.3
Milwaukee 23.4
Minneapolis 22.2
Nashville 23.9
New Orleans 30.3
New York 42.4
Oklahoma City 20.6
Orlando 25.7
Philadelphia 32.8
Phoenix 26.9
Pittsburgh 23.6
Portland 25
Providence 22.2
Richmond 22
Sacramento 24.4
Salt Lake City 18.8
San Antonio 24.7
San Diego 23.4
San Francisco 31.2
San Jose 27.1
Seattle 25.9
St. Louis 25.4
Tucson 22.6
Tulsa 18.7
Washington, D.C. 31.4

image text in transcribed

(a) What is the mean commute time (in minutes) for these 48 cities? (Round your answer to three decimal places.) minutes (b) What is the median commute time (in minutes) for these 48 cities? minutes (c) What is the mode (in minutes) for these 48 cities? (If there is more than one mode, list all modes as a comma separated list.) minutes (d) What is the variance of commute times for these 48 cities? (Round your answer to three decimal places.) x (e) What is the standard deviation of commute times (in minutes) for these 48 cities? (Round your answer to three decimal places.) minutes (a) What is the mean commute time (in minutes) for these 48 cities? (Round your answer to three decimal places.) minutes (b) What is the median commute time (in minutes) for these 48 cities? minutes (c) What is the mode (in minutes) for these 48 cities? (If there is more than one mode, list all modes as a comma separated list.) minutes (d) What is the variance of commute times for these 48 cities? (Round your answer to three decimal places.) x (e) What is the standard deviation of commute times (in minutes) for these 48 cities? (Round your answer to three decimal places.) minutes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Introduction To Financial Accounting

Authors: Anne Marie Ward, Andrew Thomas

7th edition

77138449, 978-0077132682, 77132688, 978-0077138448

More Books

Students also viewed these Accounting questions