Please go to the website http://www.ssa.gov/OACT/babynames/ and scroll down to the bottom, "items of interest." Enter your birth year and choose top 1000 popularity on the "Population Names by Birth Year" column.

A.Guys should check male name column and girls should check female name column. Find out the most popular name and calculate the proportion of it out of total. Conduct 95% confidence interval for the proportion of people sharing that name in your cohort.

B.Now, move to the "Popularity of a Name" column. According to the name you chose from A, determine whether there is sufficient evidence to conclude that the name (you chose) is more popular in the year of 2000 (if not working, try 2001, 2002, or 2003, etc.) than it was in your cohort. Use the 5% level of significance. (This question needs all five steps we talked about for hypothesis testing including null/alternate hypothesis)

Note: For this question, use excel for all the numerical work and clearly state your answers.