I need help computing this in Excel. I'd like to learn by seeing the different steps in excel and not just the answers.

You are working in the training department of a large insurance company and you are charged with the task to determine which training method is best. There are two methods to be evaluated, which are classroom and online training. You recelved data of a sample of 30 trainees (15 from each training method). Before the training, each trainee is given a proficiency exam and at the end of the training each trainee is given the end-of-training exam. The sampled trainees also provided information on the time they spent studying outside of the classroom. The data collection results are orovided to vour left. Develop the multiple regression model that best predicts the score on the end-of training exam. Consider the following options: Model 1: all independent variables (proficiency, study time, method coded) included without interaction term Model 2: all independent variables included with interaction term Final Model: only include independent variables that significantly contribute to the model at a. 05 level of significance provide the analyses outputs in the povided sheets or rename your created sheets accordingly Points possible: 40 For your final model, provide the following information on this sheet: Create a residuals versus predicted y plot and analyze all plots. Provide a statement whether the assumptions are met (including whv) to achieve valid results from the regression model