Compressor failure data

A reliability engineer wants to predict warranty claims that are caused by defective refrigerator compressors. The engineer collects and analyzes monthly failure data for the previous year.

You can use this data to perform a warranty analysis and to demonstrate Pre-Process Warranty Data and Warranty Prediction.

Worksheet column Description
Ship The number of refrigerators that are shipped monthly
Month1 The number of compressor failures that were detected in the first month from the first shipment
Month2 The number of compressor failures that were detected in the second month from the first and second shipment
Month3 The number of compressor failures that were detected in the third month from the first 3 shipments
Month4 The number of compressor failures that were detected in the fourth month from the first 4 shipments
Month5 The number of compressor failures that were detected in the fifth month from the first 5 shipments
Month6 The number of compressor failures that were detected in the sixth month from the first 6 shipments
Month7 The number of compressor failures that were detected in the seventh month from the first 7 shipments
Month8 The number of compressor failures that were detected in the eight month from the first 8 shipments
Month9 The number of compressor failures that were detected in the ninth month from the first 9 shipments
Month10 The number of compressor failures that were detected in the tenth month from the first 10 shipments
Month11 The number of compressor failures that were detected in the eleventh month from the first 11 shipments
Month12 The number of compressor failures that were detected in the twelfth month from the first 12 shipments
Start time The start time of the warranty claim interval, in months (in the pre-processed data set)
End time The end time of the warranty claim interval, in months (in the pre-processed data set)
Frequencies The frequencies of claims in the first 12 months and the frequencies of units that still survived (in the pre-processed data set)

Columns 1-13 contain the data in the expanded Nevada format. For instance, in Month 4, there are 0 claims for the first three shipments, and 1 claim for the fourth shipment.

Columns 14-16 are provided after you perform the pre-process step so that your data are summarized.