how to find data analysis tool in excel 2004

Pitch Perfect ( Lean & Six Sigma Review) Learning the ins and outs of capability analysis by examining a baseball pitcher’s performance.įish(bone) Stories ( Quality Progress) Today’s technology makes it easier than ever to communicate complex concepts more clearly, which is why older, 'analog' quality methods should be digitized. You can also search articles, case studies, and publications for quality tool resources. Cause-and-effect diagram template (Excel).Just download the spreadsheets and begin entering your own data. These templates will help you get started using the seven basic quality tools. Stratification: A technique that separates data gathered from a variety of sources so that patterns can be seen (some lists replace stratification with flowchart or run chart). Scatter diagram: Graphs pairs of numerical data, one variable on each axis, to look for a relationship. Pareto chart: A bar graph that shows which factors are more significant.

Histogram: The most commonly used graph for showing frequency distributions, or how often each different value in a set of data occurs. Comparing current data to historical control limits leads to conclusions about whether the process variation is consistent (in control) or is unpredictable (out of control, affected by special causes of variation). Quality pros have many names for these seven basic tools of quality, first emphasized by Kaoru Ishikawa, a professor of engineering at Tokyo University and the father of 'quality circles.' Start your quality journey by mastering these tools, and you'll have a name for them too: indispensable.ĭiagram (also called Ishikawa or fishbone diagrams): Identifies many possible causes for an effect or problem and sorts ideas into useful categories.Ĭheck sheet: A structured, prepared form for collecting and analyzing data a generic tool that can be adapted for a wide variety of purposes.Ĭontrol chart: Graph used to study how a process changes over time. 'The Old Seven.' 'The First Seven.' 'The Basic Seven.' Quality Glossary Definition: Seven tools of quality

How to find data analysis tool in excel 2004