Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 2. A tire company has produced a new tire with an estimated mean lifetime mileage of 36500 miles. Management also believe that the standard
Problem 2. A tire company has produced a new tire with an estimated mean lifetime mileage of 36500 miles. Management also believe that the standard deviation is 5000 miles and that tire mileage is normally distributed. Use an EXCEL worksheet to simulate the miles obtained for a sample of 1000 tires.
- What is your estimate of the percentage of tires that will exceed 40,000 miles?
- What is your estimate of the percentage of tires that obtain mileage less than 32,000 miles?
- What is your estimate of the percentage of tires that obtain mileage less than 28,000 miles?
- 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 would you recommend for the guarantee? Explain/provide evidence to support your answer.
Please answer this question with Excel sheet and show all of the formula. I promise will give a like! Thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started