Does Higher Median Income Mean Higher Test Scores in Indiana?

Data Analysis based on IRS Median Household Income and Indiana Department of Education Data Reports

Brent Thomas, Matt Houser, Chelsea Snedden, Emmanuel Olofinkua

Sources of Data for Analysis:

• IRS Individual Income Tax Statistics by Zip Code, 2017 https://www.irs.gov/statistics/soi-tax-stats-individual-income-tax-statistics-2017-zip-code-data-soi

• Indiana DOE School Corporation Data, 2017 https://www.doe.in.gov/accountability/find-school-and-corporation-data-reports

Data Exploration:

Is there a correlation between higher median income and higher test scores in Indiana? Is there a correlation between Muncie, Fort Wayne, and Indianapolis’ median incomes and test scores? (narrowing the scope)

Hypothesis

Hypothesis: “If there is a correlation between median income and test scores, then the r-value of income to test score ratio will be greater than .5”

Null Hypothesis: “If there is no correlation between median income and test scores in Indiana, then the r-value of income to test score ratio will be 0.”

Data Analysis Process (w/Jupyter Notebook)

https://github.com/emmaolof/FirstProject/blob/master/Fantastic%20Four%20Final%20Project.ipynb

Importing Data: Importing CSVs and merging data

Cleaning Data: Removing duplicates, null, and incomplete values

Correlation Calculations: Statewide, Muncie, Fort Wayne, and Indianapolis

Data Visualizations: Scatterplots, Bar, and Pie Charts with Jupyter Notebook

Making Conclusions: Presenting results based on correlation calculations