How to Create Frequency Distribution for Executions by Year in Excel

1. Open a new Excel 2010 worksheet. Select cell 'A1' and enter the years for your data into column 'A.' When you have all the years entered, select cell 'B1' and enter in the corresponding number of executions in column 'B.'
2. Click on cell 'C1.' Enter in the bin ranges that you want to sort the frequency by into column 'C.' These numbers will represent the top end of the ranges. If you enter '50,' '75' and '100,' your frequency distribution will have three categories: the executions per year that range between 0 and 50, the executions per year that range from 51 to 75, and the executions per year that range from 76 to 100. Enter as many bin range numbers as you need.
3. Click the 'Data' tab at the top of the screen. Select the 'Data Analysis' button from the toolbar. Select 'Histogram' from the list of options that appear and click 'OK.'
4. Place your cursor into the 'Input Range' field. Select cell 'A1' and hold down the mouse button. Drag the mouse to the last cell that holds information in column 'B' and release the button.
5. Place your cursor into the 'Bin Range' field. Select cell 'C1' and drag the mouse down until you reach the last cell that holds data in that column.
6. Place a check next to 'Chart Output' if you want to get a graphical representation of the frequency distribution. Place a checkmark next to 'Cumulative Percentage.' Click 'OK' to create the frequency distribution. It will appear as a new worksheet on the bottom of the Excel window. Click on the worksheet to see the frequency distribution and its associated histogram.