Question

. In alphabetical order, the six most common last names in the United States are Brown,...

. In alphabetical order, the six most common last names in the United States are Brown, Johnson, Jones, Miller, Smith, and Williams (The world Alamance, 2012). Assume that a sample of 50 individuals with one of these last names provided below

Last Name
Brown
Smith
Miller
Brown
Williams
Williams
Brown
Jones
Miller
Jones
Williams
Jones
Smith
Smith
Miller
Brown
Smith
Jones
Jones
Brown
Williams
Smith
Johnson
Smith
Brown
Jones
Smith
Smith
Williams
Johnson
Williams
Brown
Williams
Brown
Williams
Smith
Johnson
Smith
Miller
Brown
Brown
Smith
Brown
Johnson
Brown
Johnson
Jones
Miller
Smith
Miller

Summarize the data by constructing the following: (Use Excel)

  1. Frequency distribution.
  2. A bar chart.
  3. A pie chart.
  4. Based on these data, what are the three most common last names?

please explain how to do it in excel

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
First Last Q0 Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 L0 L1 L2 L3...
First Last Q0 Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 L0 L1 L2 L3 L4 L5 L6 L7 L8 L9 P0 P1 P2 E0 E1 E2 FI ATT ------------------------------------------------------------------------------------------------------------------------------------------ Kevin Smith 90 100 100 100 98 97 87 100 85 87 89 100 100 100 100 90 100 98 90 100 98 98 98 90 90 98 88 0.00 Morgan Kelly 80 100 65 67 69 71 100 100 100 67 95 85 87 89 100 65 67...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...