SITEMAP ABOUT
MiC Quality

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
Online Course Instructor
Glen Netherwood
MiC Quality
Online Learning
:: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: INTRODUCTION TO STATISTICS Syllabus    PreviousNext

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:

 

spreadsheet


 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy