Browse » Home
Sunday, February 13, 2011
How to Make a Frequency Table on Microsoft Excel
1. Open Microsoft Excel by going to 'Start' > 'Programs' > 'Microsoft Office' > 'Microsoft Excel.'
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. Type in your bins, which help you to organize 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. Click the 'Office Orb,' located at the top left of the screen, and select 'Excel Options.' Click 'Add-Ins.'
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. 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. 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. Select 'New Worksheet Ply' for the output and then click 'OK'. Your Frequency table will appear on the new worksheet.
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.