FREE MODULE Introduction to Statistics PROCESS IMPROVEMENT AND SIX SIGMA
 ONLINE COURSES FREE TRIAL SIX SIGMA FAQ BROCHURES LICENSES ENROLL
 FREE TRIAL
 :: Online Courses :: Free Trial >> Statistics Module >> Excel Primer :: Six Sigma :: FAQ :: Brochures :: Licenses :: Discounts
 Welcome to MiC Quality MiC Quality Online Learning
 :: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: INTRODUCTION TO STATISTICS

Histograms in Excel

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:

 The Number of Bins Excel Chart