If there are a lot of data values it is much easier to create histograms using Excel.
Decide on the size of bins you want to use and create a 'bin range' . This contains the highest value that should go into each bin (the upper boundary).
I have created the 'bin range' in cells G4:G8. To make it clearer I have put the range of values that goes into each bin in cells F4:F8:
To create the histogram select the Data Analysis option under the 'Data' tab:
 |
If you can't see the 'Data Analysis' function, click on this link for help
|
The panel will appear, select 'Histogram':
Specify the 'Input Range', 'Bin Range' and 'Output Range'. I've also checked 'Chart Output. You don't have to specify a bin range, if leave that field blank Excel will calculate suitable values:
After pressing 'OK' Excel will add the frequency table to the spreadsheet:
spreadsheet
