Introduction: The scorecard data goes through every institution in the United States from the department of education. It provides an institution’s geography such as state, city, zip code, and coordinates. Each instituion is either public, private for-profit or privat non-profit. There is also a variety of demographics displayed whether the institution is HBCU, Men or Female only. Other important data points include family income, teachers salaries, cost of attendence and more.
This is finding the average family income and cost of attendence by location of institution.
| LOCALE | Average cost of attendace per campus location | Average family income per campus location |
|---|---|---|
| City | 28013.46 | 38232.11 |
| Rural | 19231.09 | 35647.50 |
| Suburb | 27661.11 | 37514.25 |
| Town | 24455.66 | 44758.57 |
| NA | 12268.25 | 34676.90 |
If the SAT average score is higher the cost of attendance will be higher and public scores will be less costly than private schools.
scorecard %>%
## Warning: Removed 5807 rows containing missing values (`geom_point()`).
This graph shows the divide between Private and Public institutions. For both types of schools, they are more expensive as SAT scores rise. However, private schools are typically more expensive.