Transcribed Image Text
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.Essay QuestionsA. 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, find the number with fewer than30,000 hours and the number with fewer than 28,000 hours.C. If management would like to advertise a light bulb guaranteesuch that approximately no more than 10% of the bulbs would lastlong enough to qualify for the guarantee, what is yourrecommendation as far as the life of the lightbulbs, in hours, thatshould qualify for the guarantee?USE MICRSOFT EXCEL AND SHOW FORMULAS