Funding for public schools across the United States has been a hot topic for legislatures at the local, state and federal level. Furthermore, such disparities exist based on the location of the schools. This visualization shows the amount spent for salary expenditures for schools and disctricts across states nationwide. Funding includes federal and state expenditure data. Explore to see how funding varies for teachers across the country and how districts in urban or rural areas get support from governments. The dataset included negative numbers (as mentioned in the note below) so averages would've been skewed. Instead as a data metric, median values were used so the data visualization shows the "average" funding/salary expenditure per school. The following horizontal chart sums up schools in their respective districts and gets the total amount including federal funding for salaries.
Note: Schools that did not provide data for these variables had their cell marked with a -9. If there was an EdFacts missing data it was marked with a -8. If there was a system error it was marked with a -7, and if the cell value was too small it was marked with a -2. This impacts the visualization, as the visualization is the sum across all observations that use that variable. However, after viewing the dataset, we have made an educated assumption that if a school did not provide data for one of these variables, they did not provide data for the others, so the proportions should not be significantly different. This is still important to note, as we cannot guarantee this.
Variable Explanations
