Each week the Wall Street Journal and Harris Interactive track the opinions and experiences of college recruiters for large corporations and summarize the results in the Business School Survey. Data have been gathered for the top 10 business schools from a list of 76 and is summarized below. Please complete the questions below and upload this document and your EXCEL document to the portal in CANVAS. School Ranking Enrollment (# of full-time students) Annual Tuition ($) Mean GMAT % with Job Offer Average Salary ($) Dartmouth 1 503 38,400 704 89 119,800 Michigan 2 1873 33,076 690 91 105,986 Carnegie Mellon 3 661 38,800 691 93 95,531 Northwestern 4 2650 38,844 700 94 117,060 Yale 5 468 36,800 696 86 104,018 Pennsylvania 6 1840 40,458 716 92 117,471 California Berkeley 7 1281 21,512 701 92 112,699 Columbia 8 1796 38,290 709 95 126,319 North Carolina 9 855 16,375 652 86 92,565 Southern California 10 1588 37,558 685 82 88,839 Is the average salary influenced by the school’s Mean GMAT scores and ranking? Part 1 1)What is your dependent variable? Please label accordingly 2)What is/are your independent variable (s)? 3)Using Excel, run a simple linear regression using each independent variable and develop a simple linear regression equation for each independent variable. Please provide the linear regression equation and whether or not the model is useful.
Each week the Wall Street Journal and Harris Interactive track the opinions and experiences of college recruiters for large corporations and summarize the results in the Business School Survey. Data have been gathered for the top 10 business schools from a list of 76 and is summarized below.
Please complete the questions below and upload this document and your EXCEL document to the portal in CANVAS.
|
School |
Ranking |
Enrollment (# of full-time students) |
Annual Tuition ($) |
|
% with Job Offer |
Average Salary ($) |
|
Dartmouth |
1 |
503 |
38,400 |
704 |
89 |
119,800 |
|
Michigan |
2 |
1873 |
33,076 |
690 |
91 |
105,986 |
|
Carnegie Mellon |
3 |
661 |
38,800 |
691 |
93 |
95,531 |
|
Northwestern |
4 |
2650 |
38,844 |
700 |
94 |
117,060 |
|
Yale |
5 |
468 |
36,800 |
696 |
86 |
104,018 |
|
Pennsylvania |
6 |
1840 |
40,458 |
716 |
92 |
117,471 |
|
California Berkeley |
7 |
1281 |
21,512 |
701 |
92 |
112,699 |
|
Columbia |
8 |
1796 |
38,290 |
709 |
95 |
126,319 |
|
North Carolina |
9 |
855 |
16,375 |
652 |
86 |
92,565 |
|
Southern California |
10 |
1588 |
37,558 |
685 |
82 |
88,839 |
Is the average salary influenced by the school’s Mean GMAT scores and ranking?
Part 1
1)What is your dependent variable? Please label accordingly
2)What is/are your independent variable (s)?
3)Using Excel, run a simple linear regression using each independent variable and develop a simple linear regression equation for each independent variable. Please provide the linear regression equation and whether or not the model is useful.
Part 2
4)Using Excel, run a multiple regression using ALL independent variables and answer the remaining questions based on your MULTIPLE REGRESSION OUTPUT ONLY. Include this output of the multiple
5)Develop a multiple regression equation
6)What is the proportion of variation in your dependent variable due to your independent variables?
7)What is the strength of the linear relationship between your dependent and independent variables?
8)What is the total variability in your dependent variable around the mean?
9)What is the variability in your dependent variable about the regression line?
10)What is your test statistic (please format this correctly)?
11)What is the p-value for your regression model?
12)Is this model useful? If so, what is the average salary when then school’s Mean GMAT score is 695 and their ranking is 5?
13)Do you reject or fail to reject your null hypothesis? Explain what your decision means.
Step by step
Solved in 3 steps with 2 images
