How do you construct frequency distribution?

Answer 1

To construct a frequency distribution you can use pivot tables and easily create a frequency distribution in Excel. You can also use the Analysis Toolpak to create a histogram. The first step is to insert a pivot table. Next, drag the following fields to the different areas: Amount Field to the Row Labels area and amount Field (or any other field) to the Values area. Next, click any cell inside the Amount column then right click and click on Group. Enter 0 for Starting at, 10000 for Ending at, and 1000 for By followed by clicking OK. To easily compare these numbers, create a pivot chart. To do this click any cell inside the pivot table. On the Insert tab, in the Charts group, click Column and select one of the subtypes. For example, Clustered Column.

Answer 2

show the relative frequency distribution