We investigated educational outcomes as a factor contributing to the state of Chicago's labor market. Specific educational outcomes we looked at were attendance rates, AP course participation, graduation rates, and SAT scores.
Shown are the correlation coefficients between unemployment rate by zip code and the different data pulled from cps high schools, organized by zip code. Between all the coefficients, there is not a single strong correlation shown between any of the variables, with most of them being around negative or positive 0.3. This correlation coefficient, referred to as r, ranges from -1 <= r <= 1. When looking at correlation, in order to determine a somewhat significant correlation, the r value needs to be less than -0.5, or greater than 0.5. Since none of the r values found fit that definition, it is safe to say that there is little to no correlation between labor participation the data we got from high schools.
We worked on 2 topics including education and the demographics in Chicago. For education, we found which zip codes had the schools that spent the most money on their students. We also compared the amount of money spent per student by school to the SAT scores of that school and made a graph. In regards to the demographics, we found the average population by race for each zip code and saw the effects of redlining that are still around today.
The data that was collected for the schools was from Chicago Public Schools. The zip code that spent the most money was 60636 (6th ward), with an average of around $45,000 spent per student. Looking at this data caused us to search for and find if there is a correlation between the amount of money spent per student and the SAT score of that school. After making a scatter plot, most of the data points were in the upper left corner which would be low money spent per student and high SAT scores.
For demographics, we found the average population of white and black people in each zip code. The dataset that we used was from the City of Chicago Data Portal and it gave different population counts for each zip code. We found that on average, each zip code has a population of around 38,000 African Americans and 35,000 White people. Also, we found out that zip codes on the South Side usually have a higher population of African Americans than zip codes on the north side.