In: Accounting

# In alphabetical order, the six most common last names in the United States in 2018

In alphabetical order, the six most common last names in the United States in 2018 are Brown, Garcia, Johnson, Jones, Smith, and Williams (United States Census Bureau website). Assume that a sample of 50 individuals with one of these last names provided the following data:

Summarize the data by constructing the following:
1. Relative and percent frequency distributions
2. A bar chart
3. A sorted bar chart
4. A pie chart
5. Based on these data, what are the most common last names? Which type of chart makes this most apparent?

## Solutions

##### Expert Solution

Part 1:

The given data can be summarized by relative and percent frequency distribution as,

 Names Frequency Relative frequency Percent frequency Brown 7 7/50 = 0.14 14 Garcia 6 8/50 = 0.12 12 Johnson 10 10/50 = 0.2 20 Jones 7 7/50 = 0.14 14 Smith 12 12/50 = 0.24 24 Williams 8 8/50 = 0.16 16 Sum 50 1 100

Part 2:

We construct the bar chart by using the step by step procedure in excel as below:

• Enter the frequency distribution in the excel sheet.
• Select the data
• Go to Insert tab > Charts > Select Insert Clustered column chart.

The output will be displayed as below:

Part 3:

We construct the sorted bar chart by using the step by step procedure in excel as below:

• Enter the frequency distribution in the excel sheet.
• Sort the frequency in ascending order.
• Select the data
• Go to Insert tab > Charts > Select Clustered column chart

The output will be displayed as below:

Part 4:
We construct the pie chart by using the step by step procedure in excel as below:
• Enter the frequency distribution in the excel sheet.
• Select the data
•  Go to Insert tab > Charts > Select Insert Pie or Doughnut chart
The output will be displayed as below:

Part 5:
The most common last names are,
Smith, Johnson, and Williams.
The bar chart and sorted bar chart make it more apparent.

Answers can be found in the Explanation section.

## Related Solutions

##### reactivity order
1) arrange Pb, Mg, and Zn in order of their activities listing most active  2)  arrange Cu, Ag, and Zn in order of their activities listing most active
Lueckenhoff Corporation uses a job-order costing system with a single plantwide predetermined overhead rate based on direct labor-hours. The company based its predetermined overhead rate for the current year on total fixed manufacturing overhead cost of $497,000, variable manufacturing overhead of$2.40 per direct labor-hour, and 70,000 direct labor-hours. The company has provided the following data concerning Job T498 which was recently completed: Number of units in the job 40 Total direct labor-hours 80 Direct materials $950 Direct labor... ##### what was the earnings per common share Net Income for the period totaled OMR75,000,preferred dividends paid totaled OMR10,000 and common dividends paid totaled OMR30,000.If there 100,000 common shares outstanding throughout the year.What was the earnings per common share (a)44.50 OMR (b)0.35 OMR (c)0.65 OMR (d) 4.50 OMR ##### Rank the following structures in order of decreasing electrophile strength. Rank the following structures in order of decreasing electrophile strength. ##### Rodriguez Corporation issues 9,000 shares of its common stock for$190,400
Rodriguez Corporation issues 9,000 shares of its common stock for $190,400 cash on February 20. Prepare journal entries to record this event under each of the following separate situations. The stock has a$18 par value. The stock has neither par nor stated value. The stock has a \$9 stated value.
##### Based on formal charges, draw the most preferred Lewis structure for ClO3-?
Based on formal charges, draw the most preferred Lewis structure for ClO3-? Draw the molecule by placing atoms on the grid and connecting them with bonds. Include lone pairs of electrons an formal charges.
##### The two most basic inventory questions answered by the typical inventory model are:
The two most basic inventory questions answered by the typical inventory model are: A) timing of orders and cost of orders. B) order quantity and cost of orders. C) timing of orders and order quantity. D) order quantity and service level. E) ordering cost and carrying cost.
##### Which dietary component does the body most commonly use for energy?
Which dietary component does the body most commonly use for energy? a) Proteins b) Carbohydrates c) Vitamins d) Fats
##### True or False: Most conducting materials have different resistances at different temperatures.
True or False: Most conducting materials have different resistances at different temperatures.
##### As in most areas of biology, the study of mitosis and the cell cycle involves a lot of new terminology.
Mitosis and cell cycle terminology As in most areas of biology, the study of mitosis and the cell cycle involves a lot of new terminology. Knowing what the different terms mean is essential to understanding and describing the processes occurring in the cell. Drag the terms on the left to correctly complete these sentences. Not all the terms will be used.