Educational Business Articles
  • Home
  • Blog
    • Leadership
      • Leadership Definition
      • Leadership Characteristics
        • Leadership Versus Management
        • Trait Theory
        • Emotional Intelligence
      • Effective Leadership Styles
        • The Six Leadership Styles
        • Authoritarian Leadership
        • Situational Leadership
        • The Managerial Grid
        • Key Leadership Theories
        • Transformational Leadership
      • The Communication Process
        • Running Great Meetings
        • How to improve business communication
        • Barriers to Effective Listening
        • Delegation and Empowerment
        • 6 Professional Presentation Tips
        • 6 Influence Tactics
      • Team Development
        • Setting SMART Goals for Your Team
        • Smart Goal Setting Examples
        • The Johari Window
      • Motivation Theories
        • Maslow’s Hierarchy of Needs
        • Herzberg Motivation Theory
        • Employee Turnover: 3 Steps to Getting it right
        • Psychological Contract
        • Non Monetary Ways to Reward Employees
        • How Important is Employee Engagement?
        • How To Improve Employee Engagement
    • Lean Manufacturing
      • Lean Definitions
      • 7 Wastes
      • Flow
      • Kaizen
      • 3 Critical Business Process Improvement Tools
      • Business Process Reengineering
      • 5 Business Process Improvement Steps
      • Lean Manufacturing Principles
      • 4 Steps to Increasing Workplace Productivity
      • Lean Manufacturing Tools
      • Lean Six Sigma
      • Creating a Lean Culture
    • Problem Solving
      • Decision making models
      • Plan Do Check Act
      • 13 Quality Management Tools
      • DMAIC Methodology: 5 Steps to Eliminate Root Causes
      • A3 Problem Solving: A Simple Tool to Report Problems
      • Why Problem Solving in Business Usually Fails
      • Six Sigma Tools
      • 5 Whys
      • Fishbone Diagram
      • TQM Tools
      • 5 Step Approach
      • FMEA
    • Economics
    • Time Management Skills
    • Change
      • Kotter’s 8 Step Process
      • ADKAR
      • The Change Curve
      • Change Management Issues
      • Other Change Models
      • The Psychological Contract
      • The 7S Model
  • Free eBooks
  • The Blueprint
  • About
  • Contact

The Histogram Graph – What it is and How to Use it

March 8, 2016Lee Candy

In order to explain what a Histogram graph is, it is worth understanding what a frequency distribution is, as the two are mutually exclusive.

A frequency distribution records the number of times each value occurs in a sample being studied.

A Histogram is merely a way of showing that frequency on a bar chart format.

An Example

Frequently, the data collected from a statistical survey or investigation of some sort, result in simply a mass of numbers, like the data below. This isn’t enough. It doesn’t show what the average output is, or what to expect from the process. It isn’t visual enough!

Let’s take another look at the data table below and let’s also assume that this is from a 20 week study, measuring weekly output from a production line:

Raw data table

The next step toward creating a histogram graph is to arrange the data into a frequency distribution, which captures the number of times the above data has been observed (its frequency). In this example, we are looking for the output achieved in a given week, and how many times over a course of 20 weeks, seen below:

frequency distribution

By converting the raw data into a frequency distribution, the data is now becoming clearer – we can start to see a picture of the data: the most frequented output and the least occurring, and so on.

The next step will be to use the data as visually as we can and By converting this into a Histogram, we can see clearly the make up of the process under investigation.

Histogram Graph

We can use the histogram graph to understand the performance of the process: its dispersion of data (its general shape). For a process that is in control, we would expect to see something that reflects a bell shape, like the one above.

We can also understand the probability of output occurring and/or not occurring. (In this case, expect to see the majority of output to be at around 69-70 units per week).

We can also use this distribution to see if the process is stable. If we measure it again for the next 20 weeks, we would expect to see the same shape of graph. If this isn’t the case, then we can investigate what special causes have affected the output this time.

In Summary

Histogram graphs are a good statistical tool, also used in Six Sigma, to understand, visually, the distribution of data in any given sample. We would expect to see a bell shape curve, similar to the illustration above, in processes that are in control.

This allows the observer to predict the typical expected results from the process.

Once the distribution of data is understood, we can measure future data to see if the distribution is still the same. If it isn’t (I.E. Skewed, Bimodal, etc) we can then start to ask pertinent questions as to why and what caused the process output to change. If for the better, understand the factor that has changed it for the greater good and lock it in to sustain this new process!

How to create a Histogram

  • Open excel
  • Enter all data captured into a worksheet – 1 cell per observation
  • Once the sample has been completed, sort the data (so you have them in number order)
  • Count each data set and add up the total number of observations for each set. (E.G. in the example above, there were 5 times the output of 70 for the week was reached, and 4 times for 69, and so on and so forth….)
  • Create a distribution table Similar to the above example. The data set should be in the left column and the number of observations (or frequency) in the right hand column.
  • Highlight the frequency column and select bar chart, adding the horizontal and vertical axis, plus name of graph etc. When happy, click Finish.

There you have it, a histogram of your process/sample!

Return from Histogram Graph to Problem Solving Home Page
Previous postCreating a Lean Culture – It’s Not Just the ‘What We Do’, but ‘How’Next postSmart Goal Setting Examples – 37 Of ‘Em For You To Steal!
Join the VIP List
(It's FREE)

And get the latest leadership & management tips and techniques:

guides, information &, FREE ebooks and templates

Straight to your inbox.

Free Ebooks (Limited Time Only)

Follow Us

Facebook
Twitter
Google+
  • Home
  • About Us
  • Free Guides
  • Blog
  • Contact Us
  • Privacy Policy
Copyright © 2021 Educational-Business-Articles.com | All rights reserved.