SunLight Company is planning to manufacture a new lightbulb with an estimated mean lifetime run of...

80.2K

Verified Solution

Question

Accounting

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 Questions
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, 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

Answer & Explanation Solved by verified expert

3.9 Ratings (438 Votes)

Formula sheetABCDEFGHI2A3Mean lifetime36500hours4Standard Deviation5000hours56BulbLife See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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