Find estimate of percentage of tires that will exceed value

Reference no: EM13150515

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?

Reference no: EM13150515

Questions Cloud

Describe how a calibration curve could be used : Explain how a calibration curve could be used to determine an unknown quantity

What amount of water could be heated : Assume that the kinetic energy of a 1300 kg car moving at 105 km/h could be converted entirely into heat. What amount of water could be heated from 20.°C to 64°C by the car's energy?

Explain how this method works : In agricultural areas, farmers pay close attention to the weather forecast. Right before a predicted overnight freeze, farmers spray water on crops to protect the plants. Use the properties of water to explain how this method works. Be sure to men..

Required reporting for defined contribution : Write a 700- to 1,050-word executive memo that explains the required reporting for defined contribution, defined benefit, and other postretirement plans. Also include an explanation of what must happen for the two segments to be eliminated

Find estimate of percentage of tires that will exceed value : 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?

Annual demand and supply : Annual demand and supply for the Entronics company is given by:QD = 5,000 + 0.5 I + 0.2 A - 100P, and QS = -5000 + 100P

Literary present or passed tense : When writing the plot for a movie in a paper, does one use literary present or passed tense? In my case, I am writing an essay about the 1978 and 1998 versions of Les Miserables:

Which balloon will deflate faster : Isra fills two identical balloons at identical temperatures. She fills one with O2 gas and the other with O3 gas. Which balloon will deflate faster? Why?

Problem associated to capital loss : On July 10, 2009, Bruce purchased an option to buy 1,000 shares of Omni, Inc. at $30 per share. He purchased the option for $2,000. It was to remain in effect for five months. The market experienced a decline during the latter part of the year, so..

User Account

All Pages