Question
How do I create an excel sheet for this question: The life of a Lapstrake Battery Co. battery for laptop computers is normally distributed with
How do I create an excel sheet for this question:
The life of a Lapstrake Battery Co. battery for laptop computers is normally distributed with a mean of 1,800 days and standard deviation of 50 days. Using the Excel functions (see Chapter 6), determine the following:
a.What fraction of batteries is expected to survive beyond 1930 days?
b.What fraction will survive fewer than 1725 days?
c.Draw a chart of the reliability function using Excel.
d.What length of warranty is needed so that no more than 5 percent of the batteries will be expected to fail during the warranty period?
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