How to Make an Age

1. Type or paste in a spreadsheet the list of ages for males, with one row per age. For example, you might type '10,' '15,' '50' and '24' for the ages of four different people. In practice, however, your list should include at least 30 ages.
2. Write on paper a list of between five and 20 age ranges. For example, write '0 to 5' for the first age range that includes ages zero to five years old.
3. Type in the first cell to the right of the topmost age from Step 1, the maximum age of the first age range on your paper. For the example in the previous step, this age is '5.'
4. Use the previous step's instructions to enter the maximum age of the remaining ranges, below the previous step's cell.
5. Click and drag on the cell immediately to the right of those of the previous step. This action selects those cells.
6. Click the 'fx' symbol to the left of the large text box above the spreadsheet grid, then double-click the 'Frequency' item from the dialog box that appears.
7. Click the small square button for selecting cell ranges, located to the right of the upper text box on the following screen. Drag on the list of raw ages from Step 1.
8. Click the square button to the right of the lower text box, then use the previous step's instructions to select the Step 3 and 4 cells holding the age ranges.
9. Click 'OK' to insert the 'Frequency' function, then click in the formula bar above the spreadsheet grid. Press 'Control,' 'Shift' and 'Enter' simultaneously to fill the cells next to the age range cells with the 'Frequency' function. This action tells you how many males are in each age range.
10. Use Steps 1 through 9 to compute the frequency distribution for females. Enter the raw female data anywhere on the same spreadsheet as the raw male data. However, make sure that the column containing the frequency distribution for females is directly to the right of the male frequency distribution.
11. Drag across both male and female frequency distributions to select them, then click the 'Insert' menu heading. Click the 'Column' button in the 'Chart' panel, then click the top left chart type from the bar chart gallery that appears. Excel now creates the histogram based on your frequency distributions for males and females.