Home » Categories » CHARTrunner

CR: Histogram bars beyond specification lines

Revision Date: 2005-09-19

Problem:

Occasionally, SQCpack and CHARTrunner will show histogram bars beyond the specification lines. This may happen despite the fact that a careful review of the data shows no values beyond the specifications. How can this be?

Solution:

Consider that each bar on a histogram is like a bucket. As the software evaluates each data point, it has to decide which bucket to throw the data into. Imagine that each bucket has a label on it that reads something like this: in this bucket put each value that falls between 5.1 and 5.5. The size of each bar on the histogram is a count of the number of data values that were put into that particular bucket.

Next, imagine that your upper specification is 5.4. The last bar (on the right) might show that 3 data points are in this bucket. Well, these three data points might be 5.1, 5.2, and 5.3 – ALL of these are below the upper specification, however the last bucket on the histogram is for data points up to 5.5. This is what can make a histogram bar appear beyond the specifications.

If this is unflattering to your process, you may want to use the custom cells feature. This allows you decide how many buckets to use and what label to put on each bucket. By adjusting these values, your histogram bars can usually be made to appear within the specifications – assuming your data is within the specifications.

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: Making an X-bar chart with a single data column
Viewed 2076 times since Fri, Nov 9, 2007
CR: Grouping counts by date in Excel
Viewed 2170 times since Fri, Nov 9, 2007
CR: Unable to fully display settings and windows
Viewed 1919 times since Fri, Jan 22, 2010
CR: A simple query pattern for summarizing raw data
Viewed 2915 times since Tue, Oct 6, 2009
CR: Formatting an Excel Date
Viewed 2450 times since Fri, Nov 9, 2007
CR: Charting counted incidents
Viewed 1935 times since Thu, Feb 23, 2012
CR: CR1.5 - My control chart data lines are not printing
Viewed 2183 times since Fri, Nov 9, 2007
Cr: Charting elapsed time
Viewed 2450 times since Fri, Nov 9, 2007
CR: Collating sequence not supported
Viewed 2626 times since Tue, Dec 11, 2007
CR: Error “External table is not in the expected format” using Excel 2007 workbook
Viewed 4036 times since Wed, Oct 14, 2009