The data is given below in pictures and also provided with a link in the comments, please look there. thank you! I will upvote. Show

The data is given below in pictures and also provided with a link in the comments, please look there. thank you! I will upvote.

2) The Dean of an M.B.A. program has asked you to review their quantitative criteria for admission. The admissions department currently uses three quantitative variables in the admissions process and measures student success in the program with their grade point average. You take a random sample of 100 recent graduates and record the following variables: MBA Grade point average on a 4.0 scale (MBA GPA), Undergraduate Grade Point Average on a 4.0 scale (UG GPA), Score on the GMAT (GMAT), and Years of Work experience between completing Bachelors Degree and beginning the MBA program (Years Worked). These data appear in the worksheet titled GPA data in workbook Chp 15 HW data on Moodle. a) Use Excel to fit the multiple regression model MBA GPA as the dependent or Y variable and the other three variables as independent variables. Is the model statistically significant at = 0.05? Are all three independent variables statistically significant at = 0.05? b) Fit the regression model using MBA GPA as the dependent or Y variable and GMAT and Years Worked as independent variables. Is the model significant at a = 0.05?