Use the excel countif function to determine the number of, Ask an Expert

Statistics

Gear tire Company has produced a new tire with an estimated mean lifetime mileage of 36,500 miles. Management also believes that the standard deviation is 5000 miles and that tire mileage is normally distributed. Use a worksheet to simulate the miles obtained for a sample of 500 tires.

A. Use the Excel COUNTIF function to determine the number of tires that last longer than 40,000 miles. What is your estimate of the percentage of tires that will exceed 40,000 miles?

B. Use COUNTIF to find the number of tires that obtain mileage less than 32,000 miles. Then find the number with less than 30,000 miles and the number with less than 28,000 miles.

C. If management would like to advertise a tire mileage guarantee such that approximately no more than 10% of the tires would obtain mileage low enough to qualify for the guarantee, what tire mileage considered in part (b) would you recommend for the guarantee?

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M9440656

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

Regression equations can take the formin the spaces next to

Regression equations can take the form: In the spaces next to the items below place the letter corresponding symbol from the below equation A. Y B. b0 C. b1 D. X 1. Regression line slope: 2. Predicted value: 3. Independe ...

A recent study reported that the prevalence of

A recent study reported that the prevalence of hyperlipidemia is 30% in children 2 to 6 years of age. If 12 children are analyzed what is the probability that at least 3 are hyperlipidemic?

How to calculate the sample space problem consider the

How to calculate the sample space? Problem: Consider the experiment of drawing two cards from a deck in which all picture cards have been removed and adding their values (with ace = 1)

A logging contractor has three feller bunchers on any given

A logging contractor has three feller bunchers. On any given day, each machine has a 90% chance of working. The contractor is considering buying a fourth feller buncher to offset the possibility of none of the machines o ...

What is measured by the numerator of the z-score test

What is measured by the numerator of the z-score test statistic?

1 define and discuss how to develop the free cash flow

1. Define and discuss how to develop the Free Cash Flow forecast? 2. Define and discuss how to develop the Terminal Value? 3. Define and discuss how to develop the Discount Rate?

1 define organizational communication2 what interesting

1. Define organizational communication 2. What interesting about the subject of organizational communication

How does a firm navigate strategic management in the

How does a firm navigate strategic management in the context of an international environment? What complications does an international environment provide? What are the benefits of operating in an international environme ...

During a 52 week period a company paid overtime wages for

During a 52 week period a company paid overtime wages for 16 weeks and hired temporary help for 7 weeks. During 6 weeks the company paid overtime and hired temporary help (a) Are the events? "selecting a week that contai ...

You randomly sample 50 theaters in the united states you

You randomly sample 50 theaters in the United States. You ask those theaters how much they charge for a large popcorn, and you get a sample mean of $6. Then, you make confidence interval using this data with the lower li ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert