Data Analysis Project

Educational Attainment Chart: https://docs.google.com/spreadsheets/d/1m4YctCZXQlOYMdd7yzjOrhUiajrMbtgt1q4HNu4bcKA/edit?usp=sharing

Educational Attainment Data: https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?pid=ACS_17_1YR_S1501&prodType=table

Employment Status Chart: https://docs.google.com/spreadsheets/d/1Kg1AiXuXR1bIdYx4f_h_xYPgAtpx6944dk7ynbWFTkw/edit?usp=sharing

Employment Status Data: https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?pid=ACS_17_1YR_S2301&prodType=table

The data I found shows educational attainment and employment status in Richmond, Virginia from 2017. I chose these two data sets because I felt as if they connected to each other. I am also from the Richmond area and found it interesting to see who was educated and working.

Each data set had many subcategories, however, I deleted the subcategories to focus on the main age groups and races. This made the data clearer to understand, and made the charts easier to read.

There were columns showing the percentages of males and females who were educated and employed, as well as columns showing the margin of error. These columns were unnecessary, and made the data confusing, therefore, I deleted these columns. Once my data was cleaned up and easy to understand, I made my charts. For each set of data, I made two pie charts. One showing age, and one showing race. I found that the pie charts were easier to read. I chose to make two charts because the graph became very cluttered if I tried to fit all the information on one. The data is clearly shown in the charts, and designed in way that whomever is reading it can see and understand it.