Using the data in the tables as a basis please calculate the following. You MUST use Excel to solve this problem. Please turn in a hard copy of your work (not turning hard copy in results in a 0 for this assignment) • What type of probability distribution function best models the Time to Failure? What type of probability distribution function best models the Corrective Maintenance Time? What is the estimated failure rate and MTBF? • What is the reliability over 100 hours? • What is the mean corrective time? 601 594 600 594 594 26.9 23.2 25.7 27.0 24.1 591 625 576 581 585 19.1 29.3 25.0 27.9 20.4 605 563 612 560 586 25.7 30.3 22.4 29.7 27.0 593 584 609 549 567 22.7 26.3 26.4 23.2 18.6 591 586 584 556 596 24.3 19.0 23.3 28.2 27.2 580 573 626 627 582 28.7 28.5 27.7 20.2 21.9 595 544 568 602 599 26.6 22.7 22.8 22.5 26.6 587 578 593 606 597 19.6 25.6 28.0 20.2 28.0 555 578 578 577 616 25.2 27.2 19.3 17.0 27.6 598 590 560 615 541 35.8 27.6 21.3 23.4 26.6 Table 1 Time to Failure (hours) Table 2 Corrective Maintenance Time (hours)