1. Open the data set titled “Student Data” on the IMB
2. Create indicator (dummy) variables for the “gender”, “athlete” and
“major” variables.
3. Create a table of Descriptive statistics for all variables.
4. Calculate the correlation coefficients between all variables.
5. Use Excel to estimate the linear relationship between GPA (Y) and all
of the other variables (Xs). That is, estimate one multiple regression
model.
6. Someone suggests that economics majors that are athletes have
especially high GPAs, and that the effect of both of these variables is
more than the simple sum of the athlete effect and the economics
major effect. Make changes to your data set that will allow you to test
this hypothesis, and create a new multiple regression model to test
for such an effect.
Specifics:
Include a 99% Confidence interval with your regression
Do not worry about “line fit plot” or residuals
docsity.com