As helpful as a Pareto chart is, it isn’t practical when working with reams of data and hundreds of groupings. A Pareto table, on the other hand, can analyze large data sets and point you to improvement.
If you are like me, you may find yourself writing a fair number of MS Excel macros to automate repeatable tasks. One day it dawned on me, however, that several of the aspects of writing macros were repeatable tasks themselves. When writing a macro I would often start by: Creating a data structure that would…
TaaG (trends at a glance) analysis is a fast way to compare trends of subsets of data across large data sets. It is an ideal tool to use in the Measure and Control phases of DMAIC (Define, Measure, Analyze, Improve, Control) projects. The value of TaaG analysis is best understood by way of example. Suppose…