Click the 'Office Orb,' located at the top left of the screen, and select 'Excel Options.' Click 'Add-Ins.'ĥ.
(For more information on bins, please see the link in the Resources section.)Ĥ. 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. Type in your bins, which help you to organize the data in your Frequency table. 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.ģ.
Open Microsoft Excel by going to 'Start' > 'Programs' > 'Microsoft Office' > 'Microsoft Excel.'Ģ.
