Design for Quality and Product Excellence 30
18. Massive Corporation tested five motors in a 900-hour test. Compute the failure rate if three
failed after 200, 475, and 750 hours and the other two ran for the full 900 hours each.
Massive Corporation’s motors have a failure rate of:
= 3 = 3 = 0.00093 failures / hour
[(2 x 900) + 200 +475 + 750] 3225
19. The life of a Cellurific phone battery is normally distributed with a mean of 1,100 days
and standard deviation of 60 days. Using Excel functions (see Chapter 6), determine the
following:
a. What fraction of batteries is expected to survive beyond 1,200 days?
b. What fraction will survive fewer than 995 days?
c. Draw a chart of the reliability function using Excel.
d. What length of warranty is needed so that no more than 10 percent of the batteries will be
expected to fail during the warranty period?
See the Excel file Problem 7.19 in the instructor materials.
a) P(x > 1200) = 1 – P(x < 1200)
Using the Excel NORM.DIST (1200,1100,60,TRUE) = 0.9522