Excel Sheet
Here is the link to my excel sheet, and I got my data from Data.gov
Picture of Chart
Identification of Trend
The data records the names and ethnicities of babies that were born in 2011 in New York City, the chart then shows the amount of babies with this name and where its popularity ranking. The trend that I noticed in this graph is that the girls’ names tended to have higher popularity rankings than the boys’ names, no matter the ethnicity.
Methods
To make this graph. I used excel to import my data. The original chart originally had about 69,000 names but I narrowed it down to 1,934 by using only babies who were born in 2011, and by cutting out repeat names and names that were misplaced in the wrong grouping. For example, the ethnicity and genders of the baby names tended to be grouped together, but throughout the chart there would be random white female names in the wrong group. Once I cleaned up the chart, I made a pivot table which was how I noticed that the girl names rank higher in popularity than the boys’. After that, I made a bar graph based on the pivot table.
