Skip to content
DA-HW4-Xinyu Wu
Share
Explore

icon picker
Problem 3

Student Application

Question:

1. Application Prediction Model

ASSUMPTION:
Create the model based variables of gender, GPA, SAT, distance to campus, household income, in-state status, and source.
Create prediction based on a female student with 3.0 GPA, 1050-1100 SAT, 100 miles from campus, $100,000 household income, in state, and source of Collegeboard-Senior search.
FOUND:
The application probability is about 10.58%.

2. Dummy Variable - Gender/State/InState

Gender : two variables have been created
Screen Shot 2022-03-06 at 15.59.24.png
State: 24 variables have been created
Screen Shot 2022-03-06 at 15.59.55.png
Screen Shot 2022-03-06 at 16.00.02.png
Screen Shot 2022-03-06 at 16.00.12.png
Screen Shot 2022-03-06 at 16.00.27.png
Screen Shot 2022-03-06 at 16.00.38.png
Screen Shot 2022-03-06 at 16.00.46.png
InState: 2 variables have been created
Screen Shot 2022-03-06 at 16.01.26.png

3. Model Interpretation & Recommendation

Interpretation:
Based on the predictors that have been chosen, there are few factors have strong relationship between application status which are gender, SAT score from 1360 to 1530, distance to campus, household income, and in state status.
As one unit increase of distance to the campus, the application value would be decreased by 0.0051.
As one unit increase of household income, the application value would be decreased by 1.201*10^(-5).
If the students is in the state, the application value would be increased by 0.494.
Recommendation:
Target students who live close to the campus and research on neighborhoods and communities.
Target students whose family have relatively low income.
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.