Category Archives: Applied Knowledge

Quality Management: Knowledge Pack

Here is a list of all articles related to the seven Quality Management Tools. From Run Chart to Flow chart, from scatter chart to Pareto chart.

Quality Management Tools - List of articles

  1. Quality Management 1. Fishbone (Cause and Effect) Diagram
  2. Quality Management 2. Check Sheet
  3. Quality Management 3: Run Charts
  4. Quality Management 4: Histograms (any version of Excel)
  5. Quality Management 4: Histogram using Pivot Table
  6. Quality Management 4: Histogram (using Excel 2016)
  7. Quality Management 5: Pareto Chart
  8. Quality Management 5: Histogram and Pareto
  9. Quality Management 6: Scatter Diagram
  10. Quality Management 7 – Flowcharts

Quality Management 5: Pareto Chart

Pareto chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.

Pareto chart Quality Management

Continue reading Quality Management 5: Pareto Chart

Quality Management 3: Create Run Charts in Excel

Run charts are simple line charts drawn against time. The idea is to visualize the pattern and trend of captured data. The data could be about defects, issues, observations or variability. Let us see how to manage this using Excel.

Create run charts in Excel

Photo credit: tudedude / Foter / CC BY-NC-SA

Continue reading Quality Management 3: Create Run Charts in Excel