hi please help. I know the math for this excel sheet, I'm only stuck at the "what would you do" question. i know for the conclusion the answer is component 4, but I'm not sure about the what would you do question in part b.

the original question is this:

thank you

B C D E F G H J K L M N 0 Pa P Q a. Reliability of robot = Probability that all four major components will function (Use Rule 1): = .98 x 95 x .94 x.90 = b. What would you do? Given: If Component 1, Backup has a reliability - 98 Probability that Component 1 or Backup will function (Use Rule 2): 98 + [(1-98) x 98] - X (number from below) Reliability of robot Probability that all four major components will function (Use Rule 1): = =insert number from answer above) x.95 x 94 x.90 = Given: If Component 2, Backup has a reliability-.95 a 1 Problem 6 2 3 4 4 5 5 6 6 7 8 8 9 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 27 Probability that Component 2 or Backup will function (Use Rule 2): .95 + [(1 - 95) x.95] = Reliability of robot = Probability that all four major components will function (Use Rule 1): = .98 x insert number from answer above) x .94 x .90 = . Given: If Component 3, Backup has a reliability = .94 Probability that Component 3 or Backup will function (Use Rule 2): =.94 + [(1 - 94) x.94] = .94 +.0564 = Reliability of robot = Probability that all four major components will function (Use Rule 1): = .98 x 95 x(insert number from answer above) x.90 = Given: If Component 4, Backup has a reliability = 90 Probability that Component 4 or Backup will function (Use Rule 2): = 90 + [(1 - 90)x.90] =.90 +.09 = . Reliability of robot = Probability that all four major components will function (Use Rule 1): =.98 x.95 x 94 x(insert number from answer above) Conclusion: Add the Backup to Component Xthis leads to the highest reliability: na but will be added Theblu will be liabilitarf 02 A B D E F G H I J K L M N 0 Pa P Q Conclusion: Add the Backup to Component Xthis leads to the highest reliability: One backup component will be added. The backup will have a reliability of 92. Probability that Component 1 or Backup will function (Use Rule 2): = .98 + [(1 - 98)x.92] =.98 +.0184 = | Reliability of robot = Probability that all four major components will function (Use Rule 1): =(insert number from answer above) x.95 x 94 x.90 = = Probability that Component 2 or Backup will function (Use Rule 2): =.95 + [(1 -,95) x .92] =.95 +.0460 = Reliability of robot = Probability that all four major components will function (Use Rule 1): = .98 x (insert number from answer above) x.94 x.90 = Probability that Component 3 or Backup will function (Use Rule 2): = .94 + [(1 - 94) x.92] =.94 +.0552 Reliability of robot = Probability that all four major components will function (Use Rule 1): = .98 x 95 x (insert number from answer above) x.90 = 35 36 37 c. 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 Probability that Component 4 or Backup will function (Use Rule 2): = 90 + [(1 - 90) x.92] =.90 +.0920 = Reliability of robot = Probability that all four major components will function (Use Rule 1): = .98 x 95 x 94 x (insert number from answer above) = Conclusion: What would you do, which component would lead ot the highest reliability 6. One of the industrial robots designed by a leading producer of servomechanisms has four major components. Components' reliabilities are.98, 95, 94, and .90. All of the components must function in order for the robot to operate effectively. a. Compute the reliability of the robot. b. Designers want to improve the reliability by adding a backup component. Due to space limitations, only one backup can be added. The backup for any component will have the same reliability as the unit for which it is the backup. Which component should get the backup in order to achieve the highest reliability? c. If one backup with a reliability of .92 can be added to any one of the main components, which component should get it to obtain the highest overall reliability