School_District_Analysis

PyCitySchools

Overview of the school district analysis

This analysis was intended to provide a school board with specific statistics for a better understanding of how the schools in the distric compare with eaach other on various metrics. The most important part of this analysis was cleaning the data; once the school board realized that there was an error with some sparsley populated reading and math scores at one of the high schools, it was worth eliminating the data that they thougth to be altered for a better overview of all the schools. The reading and math scores at Thomas High School were replaced with NaN (or Not a Number) for all the ninth grade students. Because the first analysis was conducted with these students included it will be easy to see how the comparison of the 15 schools was impacted.

Results

Using bulleted lists and images of DataFrames as support, address the following questions.

• How is the district summary affected? For camparision the district summary with the ninth grade Thomas High scores included is listed first and the cleaned district summary without the ninth grade scores is listed second. The difference between the number of student is 461; the average math scores and the percentages are slightly lower without all the students.

• How is the school summary affected? The school summary is affected only slightly with Thomas High School at 93.27% passing math and 97.31% passing reading before the ninth graders were removed and 97.02% passing math and 93.19% passing reading after. When comparing the different grades Thomas High cannot be compared to other ninth graders due to the lack of data now. Thomas High went from listing 1635 students in all to 1174.

• How does replacing the ninth graders’ math and reading scores affect Thomas High School’s performance relative to the other schools? Thomas High School remains in the top five schools.

How does replacing the ninth-grade scores affect the following:

• Math and reading scores by grade were impacted by the lack of a number for the 9th graders at Thomas:

• Scores by school spending only had an impact on the reading scores

• Scores by school size These scores were unaffected by the removal of ninth grade math and reading scores at Thomas High because the school still fell within the same size bin of size medium or 1000 to 1999 students.

• Scores by school type were only impacted with a change in the reading scores which went down without the inclusion of the ninth graders. This means without the added reaading scores at Thomas the averages went down.

Summary

Summarize four changes in the updated school district analysis after reading and math scores for the ninth grade at Thomas High School have been replaced with NaNs. Four changes the updated school district analysis had without the coparison of ninth grade scores at Thomas High School were:

1. Thomas High had 461 fewer students to count toward their averages. This brought the total students from 39,170 down to 38,709.
2. The ninth grade scores are replaces with NaN

3. The score percentages are slightly lower without the ninth grade scores.
4. The spending ranges per student changed in the $631 to $645 range