1. Introduction Alpha Tire Company wishes to offer a warranty for their tires. In order to perform an assessment of the tires' durability, a sample of 41 newly manufactured tires is selected at random. The mileage at which each tire will fail needs to be determined. Rather than driving the tires around for months until they fail naturally (field test), the tires are installed on a special machine that simulates wear and tear (lab test). The machine operates at high speed, high temperature, and applies high pressure on the tires against a rough surface. As a result, the tires blow up in just a few hours. A conversion formula is then used to compute each tire's simulated mileage. You are asked to advise Alpha Tire Co. on the feasibility of offering a 35,000-mile warranty on their tires. At this time Alpha Tire believes the meant time to failure is 40,000 miles (p= 40,000) with standard deviation of miles to failure to be 3700 or (6 =3700) 2. The data Tire mileage to failure data are provided in Excel file Case3 DATA. The file is posted on Blackboard Learn. (BBL) 3. Sample Statistics in Excel Using Excel functions =average() and =stdev(), compute the sample mean and the sample standard deviation. You may also use the DATA-----DATA ANALYSIS-----DESCRIPTIVE STATISTICS macro in Excel to obtain these statistics. Question #1: Assuming that the tire mileage is normally distributed with u = 40,000 miles and a known o = 3,700 miles compute the probability that a randomly selected tire lasts less than the 35,000 promised by the warranty or we could ask what % would we expect to replace given this policy. Question #2: Assuming that the tire mileage is normally distributed and the mean number of miles to failure is not known and a known o = 3,700 miles. Using your sample of 41 tires as your estimate of the mean (X Bar); what is the upper and lower bound of a 95% confidence interval? Question #3: Assuming that the tire mileage is normally distributed and the mean number of miles to failure is not known nor is o. Using your sample of 41 tires as your estimate of the mean (X Bar) and s = the sample standard deviation; what is the upper and lower bound of a 95% confidence interval? Remember you are estimating the sample standard deviation