solved some questions require excel, others require just typing onto word
some questions require excel, others require just typing onto word document1—provide excel work for the following:The guidance system of a ship is controlled by a computer that has three major modules. In order for the computer to function properly, all three modules must function. Two of the modules have reliabilities of .97, and the other has a reliability of .99. a. What is the reliability of the computer? b. A backup computer identical to the one being used will be installed to improve overall reli-ability. Assuming the new computer automatically functions if the main one fails, determine the resulting reliability. c. If the backup computer must be activated by a switch in the event that the first computer fails, and the switch has a reliability of .98, what is the overall reliability of the system? (Both the switch and the backup computer must function in order for the backup to take over.)2— Determine the availability for each of these cases: a. MTBF = 40 days, average repair time = 3 days b. MTBF = 300 hours, average repair time = 6 hours3—solve the following:A product engineer has developed the following equation for the cost of a system component: C = (10P)2, where C is the cost in dollars and P is the probability that the component will oper-ate as expected. The system is composed of two identical components, both of which must operate for the system to operate. The engineer can spend $173 for the two components. To the nearest twodecimal places, what is the largest component probability that can be achieved?4—List and briefly explain: a. The dimensions of service quality b. The determinants of quality5—-Use the dimensions of quality to describe typical characteristics of these products and services: a. A television set b. A restaurant meal (product)6—-Describe the quality–ethics connection.