Pages

Thursday, August 21, 2014

Analyzing Median Income and School Rating in Kansas City Metro

Data Plot

I had been exploring the schools around the kansas city metro area. I thought of using R to analyse the school rating in the area and see if there is any link between school rating and median income of the population by zipcode. I used US census - ACS data API for median income data and Eduction.com data API to retrieve school rating data. I found this as a good resource to help me get to my objective.

In the process, I gained good insight into working with data API in R, choropleth map and overlaying different kind of information in single map.

Data Plot

plot of chunk unnamed-chunk-1

Conclusion

Eduacation.com API data does not have test rating information for the school at many zip codes. From the overlay of income and rating data (when available), it looks like the zip codes with lower median income has lower school rating. There are outliers too. At this point however, I can not conclude though if I see any pattern in median income and school rating. There could be other factors that affect the school ratings in an area.

This report is generated using knitr package in R

No comments:

Post a Comment