I need help please, I posted this question before but no one helped me! I need to submit this by midnight

HW 2 In alphabetical order, the six most common last names in the US are Brown, Johnson, Jones, Durvis, Smith and Williams (The world Almanar, 2017) Assume that a sample of 50 individuals with one of these last names provided the following data, as given from Cell A10 through A60 Summarize the data by constructing the following: 1. Frequency and relative frequency distribution /hont; use countifs function or Phot Table refer to the Madaru les crample) 2. A bar chart 3. A pie chart 4. Based on these data, what are the three most common last names? Please present your solution to these questions on the current sheet Last Name Brown Smith Davis Johnson Williams Williams Johnson Jones Davis Jones Williams Jones Smith Smith Davis Johnson Smith Jones Jones Johnson Williams Smith D'AVIS Johnson Smith Jones Jones Johnson Williams Smith Brown Smith Johnson Jones Smith Smith Williams Brown Williams Johnson Williams Johnson Williams Smith Brown Smith Davis Johnson Brown Senith Johnson Brown Johnson Brown Jones Davis Smith Davis MacBook Air