Excel Online Activity: Systems Reliability

An electronic missile guidance system at Mguide Inc. consists of components A$,$ B$,$ C$,$ and D$,$ which have reliabilities of $0\mathrm{.}98,0\mathrm{.}92,0\mathrm{.}87,$ and $0\mathrm{.}96,$ respectively $($see the following diagram$).$

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Round your answers to three decimal places.

Open spreadsheet

Questions

a$.$ Compute the reliability of the entire system.

b$.$ Suppose the customer requires a reliability of at least $0\mathrm{.}95.$ Try to find a configuration that meets this requirement using the minimum number of components.

Adding redundancy to increases the reliability to