If there are a lot of data values it is
much easier to create histograms using
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: