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: CHARTrunner and Open Office
Viewed 2431 times since Fri, Nov 9, 2007
CR: A custom query for Length of Stay data
Viewed 2581 times since Fri, Nov 9, 2007
CR: Charting counted incidents
Viewed 2031 times since Thu, Feb 23, 2012
CR: Background on out-of-control test rules
Viewed 2325 times since Fri, Nov 9, 2007
CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula
Viewed 3759 times since Fri, Nov 9, 2007
CR: General Filtering Tips
Viewed 2231 times since Fri, Nov 9, 2007
CR: Show every date on the chart
Viewed 2243 times since Thu, Jan 31, 2008
CR: CR1.1 - Charts in the Chart Workspace do not print all of the charts
Viewed 2070 times since Fri, Nov 9, 2007
CR: Charting pass-fail data as a p-chart
Viewed 4525 times since Fri, Feb 29, 2008
CR: Unable to fully display settings and windows
Viewed 1970 times since Fri, Jan 22, 2010