Question: Is this something that can be calculated in excel? If yes, please include excel formula's/functions. Thanks. The travel-to-work time for residents of the 15 largest

Is this something that can be calculated in excel? If yes, please include excel formula's/functions. Thanks.

The travel-to-work time for residents of the 15 largest cities in the United States is reported in the2003 Information Please Almanac.Suppose that a preliminary simple random sample of residents of San Francisco is used to develop a planning value of 6.41 minutes for the population standard deviation.

Round your answers to nearest whole number.

a.If we want to estimate the population mean travel-to-work time for San Francisco residents with a margin of error of 5 minutes, what sample size should be used? Assume 95% confidence.

b.If we want to estimate the population mean travel-to-work time for San Francisco residents with a margin of error of 2 minutes, what sample size should be used? Assume 95% confidence.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Business and Social Customs Objectives Upon completion of this chapter, you will learn customary verbal expressions of persons of various countries. understand the importance of a knowledge of...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

I need help on the Boulder Public School Case Study . There are three questions asked at the end of the case study. HBSP Product Number TCG239. Rev. Oct. 2015 THE CRIMSON PRESS CURRICULUM CENTER THE...

Wal-Mart Stores This case was prepared by Charles W. L. Hill of the School of Business, University of Washington, Seattle. CI0-1 Introduction In July 1962, Sam Walton opened his first Wal-Mart...

I need help with this project. I have attached all of the instructions and relevant information. The final draft is due August 20th. Course Project: A Financial Statement Analysis A Comparative...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Business and Social Customs Objectives Upon completion of this chapter, you will learn customary verbal expressions of persons of various countries. understand the importance of a knowledge of...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

During the month, Iris Labs Co. has a substantial number of transactions affecting each of the following accounts. State for each account whether it is likely to have (a) Debit entries only, (b)...

Using the information in Figure 4.3 (page 162), find an estimate of the probability that a randomly selected Los Angeles resident (12 years or older) would a. Name one of the top three rated stations...

At the end of 2 0 2 4 Georpe, a 2 0 % parther in the five - person Bush Partnership has an outside basis of $ 3 0 , 0 0 0 including his $ 2 0 , 0 0 0 share of Buah Partnership debt. On January 1 . 2...

Required information Exercise D-10 Record investment in bonds at a discount (LO D-5) (The following information applies to the questions displayed below.] On January 1, Dora purchases 175 of the...