SNote:Solve it by Excel

External Problem One of a well-known company located in Buraidah planning to train 50 staffs in quality assurance program, which you are responsible for. Through getting ready for the coaching set up, you always contact different coaching organizations to produce you with offers for conducting these training. Accordingly, you have to decide which offer is to be accepted. The recent two offers received from different training institution for conducting this training course are stated in the table below: Training institution Name Mode of delivery No of days No of hours/day Cost AAU Training Company Hands-on 7 8 Same MUA Training Company Theory and Hands-on For Hands-on Course: Each day of the course will affect the performance of each employer with minimum effectiveness or enhancement of 0.75% and maximum effectiveness of 3%. This is definitely according to each employer background. For the Theory and Hands-on Course: Each full day (8 hours) of the course will affect the performance of each employer with minimum effectiveness or enhancement of 0.75% and maximum effectiveness of 4 %. However, the number of actual training hours per each practical training day ranged between 5 and 7 hours. 1. Establish a predictive model, similar to that presented in chapter 1, to find out which of the two training course is supposed to be chosen. Consider the following notes and directions: a) Use random generator to estimate the model parameters b) Remember that ultimately you want to have maximum effectiveness from your choice. c) The model should result to a figure similar to Fig. 1.6. d) Justify your choice by evaluating the Robustness and Sensitivity of the results. II. If the effectiveness of the Hands-on course was increased by 50% [i.e. ranged between 1.23 (min) to 4.5 (max)] while the effectiveness of the Theory and Hands-on course remains the same, is your decision will remain the same?. If not what is your new decision and its Robustness and Sensitivity. External Problem One of a well-known company located in Buraidah planning to train 50 staffs in quality assurance program, which you are responsible for. Through getting ready for the coaching set up, you always contact different coaching organizations to produce you with offers for conducting these training. Accordingly, you have to decide which offer is to be accepted. The recent two offers received from different training institution for conducting this training course are stated in the table below: Training institution Name Mode of delivery No of days No of hours/day Cost AAU Training Company Hands-on 7 8 Same MUA Training Company Theory and Hands-on For Hands-on Course: Each day of the course will affect the performance of each employer with minimum effectiveness or enhancement of 0.75% and maximum effectiveness of 3%. This is definitely according to each employer background. For the Theory and Hands-on Course: Each full day (8 hours) of the course will affect the performance of each employer with minimum effectiveness or enhancement of 0.75% and maximum effectiveness of 4 %. However, the number of actual training hours per each practical training day ranged between 5 and 7 hours. 1. Establish a predictive model, similar to that presented in chapter 1, to find out which of the two training course is supposed to be chosen. Consider the following notes and directions: a) Use random generator to estimate the model parameters b) Remember that ultimately you want to have maximum effectiveness from your choice. c) The model should result to a figure similar to Fig. 1.6. d) Justify your choice by evaluating the Robustness and Sensitivity of the results. II. If the effectiveness of the Hands-on course was increased by 50% [i.e. ranged between 1.23 (min) to 4.5 (max)] while the effectiveness of the Theory and Hands-on course remains the same, is your decision will remain the same?. If not what is your new decision and its Robustness and Sensitivity