(Answered) : Sunlight Company Planning Manufacture New Lightbulb Estimated Mean Lifetime Run 36 500 Hou Q30984932

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

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

b. Use COUNTIF to find the number of lightbulbs expected to lastfewer than 32,000 hours. Then,