Question: The file 3 5 0 _ Case _ 2 . xlsx contains starting salaries for 4 0 MBA students directly after graduation. These students were

The file 350_Case_2.xlsx contains starting salaries for 40 MBA students directly after graduation. These students were randomly selected from different universities. For each student, the file also lists the number of years of experience prior to entering the MBA program and their overall GPA in the MBA program. Besides, the file contains the overall ranking of the college/school on a 100-point scale (1=lowest, 100=highest). Use Microsoft Excel to answer all the questions below. 1. Provide a numeric example of how this regression equation may be used to predict students starting salaries. (5 points)2. Develop a multiple regression equation for starting salaries using School_Ranking, GPA, and Experience as independent variables. Is this regression equation good for use? Explain. (7+3=10 points)3. If the multiple regression equation in the previous question is not good for use, how would you suggest improving this multiple regression equation? Present the improved multiple regression equation. Give a numeric example of how this improved multiple regression equation may be used to predict students starting salaries. (5+5+5=15 points) Student School_Ranking GPA Experience Salary
1782.92373,590
2563.84987,000
3233.04676,970
4673.20679,320
5563.61779,530
6782.99571,040
7683.78882,050
8893.20578,890
9373.42782,170
10673.05576,120
11483.12477,500
12783.56783,920
13563.01571,800
14253.15677,000
15683.05779,000
1636367
39393.24577,800
17723.16372,800
1876775,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!