The file P10 14V2.xlsx I includes data on the 50 top graduate programs in the United States, according to a recent U.S. News & World Report survey. Columns B, C, and D contain the average starting salary of the students of each university, a ranking score of each university (highest is 100), the average GMAT scores and the average GPA after graduation. Run three separate regressions, each using the Average Salary as the dependent variable and university Score, GMAT, and GPA as single independent variables. Interpret these equations. • Regression Equation with University score as independent variable: [ Select ] Regression Equation with GMAT as independent variable: [ Select ] Regression Equation with GPA as independent variable: [ Select ] • The only variables that is NOT a good predictor of the starting salary at a significance level of 0.05 is [ Select ] . the p-value of the regression coeficient (Beta1) of this valriable is [ Select ] • How much more money can you expect to earn after graduation if your GMAT score is 1 point higher? [Select ]

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Question

Help me

GMAT GPA
Salary verall Score
$145,987
$135,971
$121,544
$131,327
$139,790
$126,552
$129,041
$133,348
$139,593
$115,855
$130,116
$116,633
$129,309
$121,386
$127,450
1
School
Harvard University (MA)
Stanford University (CA)
Northwestem Unive rsity (Kellogg) (IL)
University of Pennsylvania (Wharton)
Massachusetts Institute of Technology (Sloan)
University of Chicago
University of Califomia-Berke ley (Haas)
Dartmouth College (Tuck) (NH)
Columbia University (NY)
Yale University (CT)
New York University (Stem)
Duke Unive rsity (Fuqua) (NC)
14 University of Michigan-Ann Arbor
2
100
720
3.2
3
99
726
3.3
4
93
710
3.2
5
93
714
3.5
92
708
3.4
7
92
713
3.5
89
714
3.1
87
712
3.2
10
86
709
3.4
11
85
718
3.52
12
83
708
3.43
13
82
696
3.4
81
706
3.32
15
University of Califomia-Los Angeles (Anderson)
Came gie Mellon Unive rsity (PA)
University of Virginia (Darden)
Comell University (Johnson) (NY)
University of Texas-Austin (McCombs)
Georgetown University (McDonough) (DC)
80
711
3.5
16
79
690
3.35
17
$124,398
$128,749
$114,732
$105,948
79
693
3.35
18
78
697
3.3
19
74
681
3.39
20
71
678
3.35
21
University of North Carolina-Chapel Hill (Kenan-Flaglei $113,812
70
678
3.3
22
University of Southem Califomia (Marshall)
$104,144
70
692
3.32
23
Emory University (Goizueta) (GA)
$101,170
69
680
3.4
24
Ge orgia Institute of Technology (DuPree)
$108,996
69
681
3.4
25
Indiana University-Bloomington (Kelley)
$103,251
69
663
3.35
26 Washington Unive rsity in St. Louis (Olin)
Ohio State Unive rsity (Fisher)
$110,499
69
681
3.42
27
$94,595
67
674
3.41
28
University of Washington
$102,560
$94,772
67
688
3.38
29
University of Wisconsin-Madi son
65
666
3.36
Arizona State University-Main Campus (W. P. Carey)
30
$96,802
64
676
3.43
31
Brigham Young University (Mariott) (UT)
$99,470
64
673
3.52
32
University of Rochester (Simon) (NY)
$97,683
64
675
3.5
33
Purdue University-We st Lafayette (Kranne rt) (IN)
$91,796
63
662
3.4
34
Texas A&M University-Colle ge Station (Mays)
$87,594
62
643
3.39
University of Minnesota-Twin Citi es (Carl son)
35
$103,005
62
663
3.31
36
University of Notre Dame (Mendoza) (IN)
Vanderbilt University (Owen) (T N)
$98,838
62
677
3.3
37
$110,670
62
656
3.3
38
University of Flori da (Hough)
$89,215
61
687
3.34
39
Rice University (Jones) (TX)
$117,445
60
667
3.29
40
University of Illinois-Urbana-Champaign
$94,514
60
639
3.4
41
Michigan State University (B road)
$106,872
59
642
3.24
42
Penn State University-Unive rsity Park (Sme al)
$108,353
59
646
3.2
43
University of Califomia-Davis
$102,638
$101,625
$89,471
59
675
3.4
44
University of Maryland-Colle ge Park (Smith)
59
660
3.34
45
Boston College (Caroll)
58
661
3.3
46
University of lowa (Tippie)
$82,506
58
653
3.37
47
Boston University
$105,686
57
680
3.38
48
Southe m Methodist University (Cox) TX
$90,840
55
642
3.23
49
Tulane University (Freeman) (LA)
$91,198
54
655
3.3
50
Babson College Olin) (MA)
$98,490
53
630
3.18
51
|University of Texas-Dallas
$72,419
53
651
3.7
Transcribed Image Text:GMAT GPA Salary verall Score $145,987 $135,971 $121,544 $131,327 $139,790 $126,552 $129,041 $133,348 $139,593 $115,855 $130,116 $116,633 $129,309 $121,386 $127,450 1 School Harvard University (MA) Stanford University (CA) Northwestem Unive rsity (Kellogg) (IL) University of Pennsylvania (Wharton) Massachusetts Institute of Technology (Sloan) University of Chicago University of Califomia-Berke ley (Haas) Dartmouth College (Tuck) (NH) Columbia University (NY) Yale University (CT) New York University (Stem) Duke Unive rsity (Fuqua) (NC) 14 University of Michigan-Ann Arbor 2 100 720 3.2 3 99 726 3.3 4 93 710 3.2 5 93 714 3.5 92 708 3.4 7 92 713 3.5 89 714 3.1 87 712 3.2 10 86 709 3.4 11 85 718 3.52 12 83 708 3.43 13 82 696 3.4 81 706 3.32 15 University of Califomia-Los Angeles (Anderson) Came gie Mellon Unive rsity (PA) University of Virginia (Darden) Comell University (Johnson) (NY) University of Texas-Austin (McCombs) Georgetown University (McDonough) (DC) 80 711 3.5 16 79 690 3.35 17 $124,398 $128,749 $114,732 $105,948 79 693 3.35 18 78 697 3.3 19 74 681 3.39 20 71 678 3.35 21 University of North Carolina-Chapel Hill (Kenan-Flaglei $113,812 70 678 3.3 22 University of Southem Califomia (Marshall) $104,144 70 692 3.32 23 Emory University (Goizueta) (GA) $101,170 69 680 3.4 24 Ge orgia Institute of Technology (DuPree) $108,996 69 681 3.4 25 Indiana University-Bloomington (Kelley) $103,251 69 663 3.35 26 Washington Unive rsity in St. Louis (Olin) Ohio State Unive rsity (Fisher) $110,499 69 681 3.42 27 $94,595 67 674 3.41 28 University of Washington $102,560 $94,772 67 688 3.38 29 University of Wisconsin-Madi son 65 666 3.36 Arizona State University-Main Campus (W. P. Carey) 30 $96,802 64 676 3.43 31 Brigham Young University (Mariott) (UT) $99,470 64 673 3.52 32 University of Rochester (Simon) (NY) $97,683 64 675 3.5 33 Purdue University-We st Lafayette (Kranne rt) (IN) $91,796 63 662 3.4 34 Texas A&M University-Colle ge Station (Mays) $87,594 62 643 3.39 University of Minnesota-Twin Citi es (Carl son) 35 $103,005 62 663 3.31 36 University of Notre Dame (Mendoza) (IN) Vanderbilt University (Owen) (T N) $98,838 62 677 3.3 37 $110,670 62 656 3.3 38 University of Flori da (Hough) $89,215 61 687 3.34 39 Rice University (Jones) (TX) $117,445 60 667 3.29 40 University of Illinois-Urbana-Champaign $94,514 60 639 3.4 41 Michigan State University (B road) $106,872 59 642 3.24 42 Penn State University-Unive rsity Park (Sme al) $108,353 59 646 3.2 43 University of Califomia-Davis $102,638 $101,625 $89,471 59 675 3.4 44 University of Maryland-Colle ge Park (Smith) 59 660 3.34 45 Boston College (Caroll) 58 661 3.3 46 University of lowa (Tippie) $82,506 58 653 3.37 47 Boston University $105,686 57 680 3.38 48 Southe m Methodist University (Cox) TX $90,840 55 642 3.23 49 Tulane University (Freeman) (LA) $91,198 54 655 3.3 50 Babson College Olin) (MA) $98,490 53 630 3.18 51 |University of Texas-Dallas $72,419 53 651 3.7
The file P10 14V2.xlsx , includes data on the 50 top graduate programs in
the United States, according to a recent U.S. News & World Report survey.
Columns B, C, and D contain the average starting salary of the students of
each university, a ranking score of each university (highest is 100), the
average GMAT scores and the average GPA after graduation.
Run three separate regressions, each using the Average Salary as the
dependent variable and university Score, GMAT, and GPA as single
independent variables. Interpret these equations.
Regression Equation with University score as independent variable:
[ Select]
Regression Equation with GMAT as independent variable:
[ Select]
Regression Equation with GPA as independent variable:
[ Select ]
• The only variables that is NOTa good predictor of the starting salary at a
significance level of 0.05 is [ Select ]
. the p-value of
the regression coeficient (Beta1) of this valriable is
[ Select ]
• How much more money can you expect to earn after graduation if your
GMAT score is 1 point higher? [Select]
Transcribed Image Text:The file P10 14V2.xlsx , includes data on the 50 top graduate programs in the United States, according to a recent U.S. News & World Report survey. Columns B, C, and D contain the average starting salary of the students of each university, a ranking score of each university (highest is 100), the average GMAT scores and the average GPA after graduation. Run three separate regressions, each using the Average Salary as the dependent variable and university Score, GMAT, and GPA as single independent variables. Interpret these equations. Regression Equation with University score as independent variable: [ Select] Regression Equation with GMAT as independent variable: [ Select] Regression Equation with GPA as independent variable: [ Select ] • The only variables that is NOTa good predictor of the starting salary at a significance level of 0.05 is [ Select ] . the p-value of the regression coeficient (Beta1) of this valriable is [ Select ] • How much more money can you expect to earn after graduation if your GMAT score is 1 point higher? [Select]
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman