SunLight Company is planning to manufacture a new lightbulb with an estimated me

Question

SunLight Company is planning to manufacture a new lightbulb with an estimated mean lifetime run of 36,500 hours. Management also believes that the standard deviation is 5,000 hours, and that the lifetime hours are normally distributed.

1.Use Excel to simulate the hours obtained from a sample of 500 lightbulbs, and use the COUNTIF function to determine the number of bulbs that last longer than 40,000 hours. What is your estimate of the percentage of bulbs that will exceed 40,000 hours?

2. Use COUNTIF to find the number of lightbulbs expected to last fewer than 32,000 hours. Then, find the number with fewer than 30,000 hours and the number with fewer than 28,000 hours.

3.If management would like to advertise a light bulb guarantee such that approximately no more than 10% of the bulbs would last long enough to qualify for the guarantee, what is your recommendation as far as the life of the lightbulbs, in hours, that should qualify for the guarantee?

Explanation / Answer

Question number wise answers:

Excel computation:

like this for 500 observations

Formula:

Number %age_actual %age_theoritical Q1. More than 40,000 hrs= 109 21.80% 24.20% Q2. Fewer than 32000 91 18.20% 18.41% Fewer than 30000 49 9.80% 9.68% Fewer than 32002 22 4.40% 4.46% Q3. Recommendation for life time guarantee 30092 Hrs

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.