How to Do a Frequency Distribution in Excel 2007

1. Click the 'Data' tab and then click 'Data Analysis.'
2. Click 'Histogram' and then click 'OK.'
3. Type 'A1:A2' into the 'Input Range' box, where A1 and A2 represent the actual range of cells on your worksheet where your input data is. For example, if your range of data is in A1 to A10, type 'A1:A10'
4. Type 'B1:B2' into the 'Bin Range' box where B1 and B2 represent the range of cells where your bin data is located. Bins represent the groups you want your data to fall into. For example, if you want your data to fall into bins of 1-10 and 11-20 and those values are located in cells C1 and C2, then type 'C1:C2' into the Bin Range box.
5. Click 'New Workbook' under 'Output Options,' then click the 'Chart Output' check box. Click 'OK.' Excel will create your frequency distribution table in a new workbook along with an embedded chart.