How to Make a Frequency Table on Microsoft Excel

Written by catherine hewson
  • Share
  • Tweet
  • Share
  • Email

Creating frequency tables, which show the distribution of certain values, is required not only in many college classes, such as Statistics, but also in business. Microsoft Excel 2007 makes the creation of frequency tables pretty easy, but for those who have never made one before, it can be a little confusing. Luckily, by taking a few quick steps in setting everything up, you can avoid a headache when it comes time to make your frequency table.

Skill level:

Things you need

  • Data Analysis Toolpak

Show MoreHide


  1. 1

    Open Microsoft Excel by going to "Start" > "Programs" > "Microsoft Office" > "Microsoft Excel."

  2. 2

    Input your data into the spreadsheet by simply typing in each value, or open your existing spreadsheet where you want to make a frequency table.

  3. 3

    Type in your bins, which help you to organise the data in your Frequency table. You should have at least 5 to 20 bins in order to get a good Frequency table, and the bins must match the range of your sample values. (For more information on bins, please see the link in the Resources section.)

  4. 4

    Click the "Office Orb," located at the top left of the screen, and select "Excel Options." Click "Add-Ins."

  5. 5

    Click the "Go" button located next to "Manage: Excel Add-ins." Click the box located next to "Analysis Toolpak" to select it, and then click "OK." Click "Yes" when prompted to by Excel, and the Analysis pack will begin installing.

  6. 6

    Click the "Data" tab in Excel and select "Data Analysis," located on the right-hand side of the screen. Select "Histogram" and click "OK."

  7. 7

    Click the button located next to "Input Range," and select all the numbers whose frequency you want to find. Click the button located next to "Bin Range," and select the bin numbers you specified in Step 3.

  8. 8

    Select "New Worksheet Ply" for the output and then click "OK". Your Frequency table will appear on the new worksheet.

  9. 9

    Click the New Worksheet Ply to make sure the Frequency table has been successfully created. You've now made a Frequency table in Microsoft Excel.

Tips and warnings

  • Don't abort the installation of the Analysis Toolpak. While the Toolpak generally installs quite quickly, occasionally it takes a little longer than normal, and you'll want to let the installation process run its course, as aborting it can make it harder to install the Toolpak in the future.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.