Frequency Distribution in Excel
Pivot tables in Excel allow you to generate a frequency distribution of your data efficiently. You can also create a histogram by using the Analysis Toolpak in Excel.
We are working with a dataset that contains 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country.
First, insert a pivot table. Next, place each of the following fields into the specified areas.
1. Amount field in the Rows area.
2. Place the Amount field in the Values area of your pivot table.
3. Click on any cell within the “Sum of Amount” column.
4. Right-click the cell, then choose Value Field Settings from the menu.
5. Choose Count and click OK.
6. Next, click any cell within the column labeled Row Labels.
7. Right-click and click on Group.
8. Provide 1 for the Starting at field, 10000 for the Ending at field, and 1000 for the By field.
9. Click OK.
Result:
You can create a PivotChart to quickly compare these numbers.
10. Click any cell inside the pivot table.
11. Click PivotChart in the Tools group on the PivotTable Analyze tab.
The Insert Chart dialog box appears.
12. Click OK.
Result:
4/9 Completed! Learn much more about pivot tables ➝
Next Chapter: Tables