The excel sheet is provided below.

Use the comment section for questions.

SELECTED SOCIAL CHARACTERISTICS IN THE UNITED STATES in the United States using Census data

Part 1: Gathering Data and Displaying Descriptive Statistics (25 points)

In this part of the project, you will be learning about how to use Excel in greater depth. You will also use data provided to give descriptive statistics, and transferring the data into readable form on Excel in the form of raw data, graphs, etc.

Part 1: Gathering Data and Displaying Descriptive Statistics

In this part of the project, you will be learning about how to use Excel in greater depth. You will also use data provided to give descriptive statistics, and transferring the data into readable form on Excel in the form of raw data, graphs, etc.

1. Download the SELECTED SOCIAL CHARACTERISTICS IN THE UNITED STATES 2011-2015 American Community Survey 5-Year Estimates Excel File. https://docs.google.com/spreadsheets/d/1-B9ChcShozhvn-zpbUobnO3ILgHDvxcu/edit?usp=sharing&ouid=104876281919584228275&rtpof=true&sd=true. Link to the excel file
2. C reate at least one graph in Excel that contains the statistics given in the Census Table. You will have to get creative with how you c reate your graph! Think about what type of data is given in the table (There are categories, with counts given for each category)
3. Make sure that the graph(s) are labeled with the appropriate titles and information within the graphs.
4. Upload the completed Excel file with descriptive statistics and graph. (25 points)