Analyzing Birth Data
Grades: 5, 6, 7, 8, 9, 10
Learning Target: Students will analyze United States birth data and discover social trends. Students will learn how to generate a pivot table in Excel and visualize data in different ways.
- Create a copy of this spreadsheet. Births-in-united-states.xlsx
- Data about your birth date.
- When were you born?
- What day of the week was it?
- How many people were born in the US on your day.
- One paragraph describing the social and economic conditions of the year you were born. (See links below.)
- Use the dataset to generate a pivot table with related data and a graph of your choice connected to that new pivot table.
- Provide analysis of the data, answering the following questions. (Can you use the pivot chart as evidence to support your answers?)
- Why are there two or more bands in the scatterplot?
- Why does the data ‘make waves’, display periodic crests and troughs?
- Notice the peak in the data on 9/5/2007. Why have births in the US been declining since then?
- Please cite your sources. (Students may get help from friends. However, please submit your own work and your own personalized analysis.)
What is a Pivot Table?
A pivot table is a table of statistics that summarizes the data of a larger table. This summary might include sums or averages which the pivot table groups together in a meaningful way.
How to Create a Pivot Table in Excel
- Select columns A through E.
- Select Insert > PivotChart
- Select table/range: Births!$A:$C
- Choose a “New Worksheet”
- Click OK.
- Within the New Sheet you now will build the pivot table.
- Select all three columns (Day, DOB, Births)
- Follow the instructions. Please do not use the “Filters” section.
- Now you will need to decide how you want to organize your data.
- Insert a graph for your new pivot table.
- Use your graph(s) as evidence to support your analysis in (D).
Tools to help your research:
- I can look for and make use of structure.