Histogram Tagged Improvement Insights

Improvement Insights Blog

Posts tagged "Histogram"

Who Sets Your Specification Limits?

A QI Macros customer called to ask how he could figure out the specification limits to give him a Cp/Cpk of 1.33. What’s wrong with this question? The answer is obvious isn’t it?

Posted by Jay Arthur in Improvement Insights, QI Macros, Six Sigma.

11/1/18 QI Macros Webinar

Over 50 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the brand new features introduced just last month in the October 2018 version of the software.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar attendees.)



If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the “Find Tool” search feature or the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

10/9/18 QI Macros Webinar

Over 90 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the brand new features introduced in the October 2018 version of the software.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar attendees.)



If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the “Find Tool” search feature or the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

9/13/18 QI Macros Webinar

Almost 100 people signed up for this webinar, with Jay Arthur demonstrating some of the more useful features of QI Macros.

Some of the attendees were familiar with the software and already use it, some had not yet begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions typed in by webinar attendees.)



If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

8/14/18 QI Macros Webinar

Another great webinar where Jay Arthur shows some of the capabilities of QI Macros to a group of folks who signed up and attended.

Some were familiar with the software and already use it, and some had not yet begun to use it; all were interested in learning new ways that QI Macros can help them with their Quality Improvement efforts. (You can hear him answering questions typed in by webinar attendees.)



If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

Data Visualizations that Really Work

The June, 2016 HRB article by Scott Berinato examines how to use charts and diagrams to express ideas and statistics. I agree with Anmol Garg, Tesla data scientist quoted in the article, “You can’t find anything looking at spreadsheets and querying databases. It has to be visual.”

Bernato says: “Convenient is a tempting replacement for good, but it will lead to charts that are merely adequate or, worse, ineffective.” He separates visualizations into four components: idea generation, idea illustration, visual discovery and everyday dataviz. Simple line, bar and pie charts are great for idea generation and illustration, but terrible for visual discovery and dataviz.

Posted by Jay Arthur in QI Macros, Six Sigma, Statistics.

Create a Histogram in Excel Using the QI Macros

Use a histogram to determine the distribution of measurable data and the capability (i.e., the level of performance the customers can consistently expect) of the process. Process capability is determined using your data and the customer’s upper specification (USL) and lower specification limits (LSL).
Its easy to create a histogram in Excel using the QI Macros.  See

http://www.youtube.com/user/QIMacros#p/a/u/2/tqlFKtmAxbU

Posted by Jay Arthur in QI Macros.