The Core grade point is the eventual dependent variable in a regression analysis. Look at the correlations between all variables. Is multicollinearity likely to be a problem? Why or why not?

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

The Core grade point is the eventual dependent variable in a regression analysis. Look at the correlations between all variables. Is multicollinearity likely to be a problem? Why or why not?

A
D
E
F
H
K
L
M
N
Updating: Static
Variable: Core
6
7
8 Multiple Regression for Core
Multiple
Adjusted
Std. Err. of
Rows
R-Square
Outliers
9 Summary
R
R-square
Estimate
Ignored
10
11
0.6114
0.3738
0.3476
0.461129728
12
Degrees of
Sum of
Mean of
p-Value
13 ANOVA Table
Freedom
Squares
Squares
14 Explained
10
30.33330635
3.033330635
14.26505695
< 0.0001
15 Unexplained
239
50.82110955
0.212640626
16
17
Standard
Confidence Interval 95%
Coefficient
t-Value
p-Value
Error
18 Regression Table
Lower
Upper
19 Constant
-0.583025976 0.300012688
-1.943337731
0.0531
-1.174032792
0.00798084
20 A201
0.124402851
0.052925071
2.350546727
0.0196
0.020143669
0.228662034
21 A202
0.13511894
0.051752908
2.610847287
0.0096
0.033168847
0.237069033
22 E201
0.096060229
0.051409462
1.868532088
0.0629
-0.005213296 0.197333753
23 E202
0.002535941
0.048802715
0.051963105
0.9586
-0.09360245
0.098674332
24 E270
0.204375044
0.052640529
3.882465604
0.0001
0.100676391
0.308073697
25 K201
0.11956978
0.055476683
2.15531596
0.0321
0.010284076
0.228855484
26 L201
0.122039052
0.048209266
2.531443893
0.0120
0.027069719
0.217008385
27 M118
0.00045447
0.044811392
0.010141832
0.9919
-0.087821257 0.088730196
28 M119
0.135365547
0.043238529
3.130669599
0.0020
0.050188266
0.220542829
29 w131
0.043647511
0.051675834
0.844640657
0.3992
-0.058150752 0.145445773
30
Transcribed Image Text:A D E F H K L M N Updating: Static Variable: Core 6 7 8 Multiple Regression for Core Multiple Adjusted Std. Err. of Rows R-Square Outliers 9 Summary R R-square Estimate Ignored 10 11 0.6114 0.3738 0.3476 0.461129728 12 Degrees of Sum of Mean of p-Value 13 ANOVA Table Freedom Squares Squares 14 Explained 10 30.33330635 3.033330635 14.26505695 < 0.0001 15 Unexplained 239 50.82110955 0.212640626 16 17 Standard Confidence Interval 95% Coefficient t-Value p-Value Error 18 Regression Table Lower Upper 19 Constant -0.583025976 0.300012688 -1.943337731 0.0531 -1.174032792 0.00798084 20 A201 0.124402851 0.052925071 2.350546727 0.0196 0.020143669 0.228662034 21 A202 0.13511894 0.051752908 2.610847287 0.0096 0.033168847 0.237069033 22 E201 0.096060229 0.051409462 1.868532088 0.0629 -0.005213296 0.197333753 23 E202 0.002535941 0.048802715 0.051963105 0.9586 -0.09360245 0.098674332 24 E270 0.204375044 0.052640529 3.882465604 0.0001 0.100676391 0.308073697 25 K201 0.11956978 0.055476683 2.15531596 0.0321 0.010284076 0.228855484 26 L201 0.122039052 0.048209266 2.531443893 0.0120 0.027069719 0.217008385 27 M118 0.00045447 0.044811392 0.010141832 0.9919 -0.087821257 0.088730196 28 M119 0.135365547 0.043238529 3.130669599 0.0020 0.050188266 0.220542829 29 w131 0.043647511 0.051675834 0.844640657 0.3992 -0.058150752 0.145445773 30
A business school committee was charged with studying admissions criteria to the school. Until
that time, only juniors were admitted. Part of the committee's task was to see whether freshman
courses would be equally good predictors of success as freshman and sophomore courses
combined. Here, we take “success" to mean doing well in I-core (the integrated core, a
combination of the junior level finance, marketing, and operations courses, F301, M301, and
P301). The file Business School contains data on 250 students who had just completed I-core. For
each student, the file lists their grades in the following courses. Except for Core, each value is a
grade point for a specific course (such as 3.7 for an A-). For Core, each value is the average
grade point for the three courses comprising Core.
• M118 (freshman)-finite math
M119 (freshman)-calculus
K201 (freshman)-computers
W131 (freshman)–writing
E201, E202 (sophomore)-micro- and macroeconomics
L201 (sophomore)–business law
A201, A202 (sophomore)-accounting
E270 (sophomore)-statistics
Core (junior)-finance, marketing, and operations
Transcribed Image Text:A business school committee was charged with studying admissions criteria to the school. Until that time, only juniors were admitted. Part of the committee's task was to see whether freshman courses would be equally good predictors of success as freshman and sophomore courses combined. Here, we take “success" to mean doing well in I-core (the integrated core, a combination of the junior level finance, marketing, and operations courses, F301, M301, and P301). The file Business School contains data on 250 students who had just completed I-core. For each student, the file lists their grades in the following courses. Except for Core, each value is a grade point for a specific course (such as 3.7 for an A-). For Core, each value is the average grade point for the three courses comprising Core. • M118 (freshman)-finite math M119 (freshman)-calculus K201 (freshman)-computers W131 (freshman)–writing E201, E202 (sophomore)-micro- and macroeconomics L201 (sophomore)–business law A201, A202 (sophomore)-accounting E270 (sophomore)-statistics Core (junior)-finance, marketing, and operations
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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