EZ Study

Actuarial Biology Chemistry Economics Calculators Confucius Engineer

Easily generate frequency distribution

Question: Most of time we don't need the complex pretty graph, a simple bar frequency distribution chart is enough. How can we easily generate that in excel?

Answer: We can easily make the bar frequency distribution chart in following steps:
generate the frequency distribution table

First, we need to insert a pivot table, select the column you want to generate the frequency distribution. Next, drag the following fields to the different areas.

1. column "Value_Output" Field to the Row Labels area.
2. For the Values tab: change from sum to count.

3. Next, click any cell inside the Range column.

4. Right click and click on Group.

generate the frequency distribution table

5. Enter some reasonable starting value as "Starting at",
some reasonable ending value for "Ending at", and some reasonable number for By.

6. Click OK.

7. Click any cell inside the pivot table.

8. On the Insert tab, in the Charts group, click Column and select one of the subtypes. For example, Clustered Column.

You can download the following excel to test.

Related links:

Continue to Highly Persuasive Secrets--Part III   Statistics   Excel Analytics

Back to Highly Persuasive Secrets--Part V   Interview Question and Answers