# 4 Stat Questions (Using Excel)

*label*Mathematics

*timer*Asked: Oct 21st, 2018

*account_balance_wallet*$15

### Question Description

1. A trucking company continuously monitors the tread remaining on its fleet of truck tires. The firm knows that standard deviation is 0.1 cm. Suppose a sample of 80 tires were obtained, and the mean tread was 2.2 cm. Construct a 99% confidence interval. The company's operations manager knows that flat tires occur more often when the tread is below 1.0 cm. At what sample mean (and higher) should the company reasonably expect minimal flat tires, based on a 95% confidence interval?

2. Monthly expenses for an advertising agency were obtained for the previous year. The sample of 12 expenses showed a mean of $196,000, with a standard deviation of $45,000. The office manager is budgeting for monthly expenses, and would like to know if it is reasonable to expect expenses to be below $250,000. Construct a 95% confidence interval to justify if $250,000 is reasonable.

3. An online business consulting firm provides its service on a hourly basis. In the previous 15 months, the business had the following number of hours billed for its services.( Hours billed: 212 389 457 505 740 678 987 573 761 812 933 691 558 575 872)

a. What is the point estimate of the population mean?

b. Construct a 90% confidence interval.

4. As the operator of an e-commerce web site, you are interested in monitoring the average time spent on the site. How large of a sample of usage times should be obtained, provided your allowable error is 30 seconds. Based on a long history, you know the standard deviation of usage times is 5 minutes. Assume a 90% level of confidence.

## Tutor Answer

The solution is attached.Please, give me feedback.

Question 1

Population standard deviation

Sample size

Sample mean

0.1 cm

80

2.2 cm

Standard error

Confidence level

z*

Error Margin

Lower Limit of 99% confidence interval

Upper Limit of 99% confidence interval

0.01118034

99%

2.5758293

0.02879865

2.1712 cm

2.2288 cm

The compan...

*flag*Report DMCA

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors