Mastering the 7 Basic Quality Improvement Tools (Accredited)

Discover the cause and effect diagram (Ishikawa or fishbone diagram) as a tool for root cause analysis, including problem statements, top-level categories, brainstorming, data-driven validation, and Excel demonstrations.

Learn to build a cause and effect diagram (fishbone) through team brainstorming, using whiteboards or Excel, and present a tree or fishbone diagram with subcauses.

See how a check sheet collects data to turn observations into pattern based decisions, with a water bottle defects example, and note its shift from manual inspection to database analysis.

Learn how to convert automated data from a database into a check sheet using Excel pivot tables, tally defects by capacity, and visualize counts.

Apply the Pareto chart to identify the vital few causes driving most defects in water bottles, using stratification to focus on high-impact issues and the 80/20 rule.

Demonstrate creating a pareto chart in excel by copying pivot data to a numeric range, selecting defects and frequencies, then inserting the pareto chart.

Explore how scatterplots reveal relationships between two variables, plotting independent on the x-axis and dependent on the y-axis, with best-fit lines and r-squared insights.

Analyze histograms as frequency distributions of continuous data to reveal center, spread, and shape, and compare samples such as male vs female tips using bin ranges.

Learn to create a tip histogram in Excel using the data analysis toolpak, set up bins, and generate a chart, with guidance on older vs newer Excel versions.

Demonstrates creating an overlapping histogram in Excel to compare tip data by gender using pivot tables and charts, adjusting transparency to reveal stratified distributions.

Learn how run charts and control charts—two of the seven basic quality tools—analyze time-sequenced measurements, interpret variation with control limits, and distinguish common versus special causes.

Learn how the x bar r chart uses subgroups of five to compute means and ranges, and how to set control limits to detect variation and special causes.

Demonstrates creating a run chart in Excel from data, including calculating a fixed-average column, adjusting axis from 80–120, and styling the line and average line for clear time sequence measurements.

Learn to create an x bar r control chart in excel from data preparation to calculating x bar and range for five measurements per subgroup, using constants A2, D3, D4.

Learn to construct X bar and range charts in Excel by plotting X bar, upper and lower control limits, and using line charts with markers removed for clean control charts.

Learn how to use flow charts, the seventh basic quality tool, to map process flow with symbols, including swim lane and cross-functional designs, and create charts in Excel.

Learn to build flow charts using Excel and draw.io, mastering common symbols like start, process, decision, and arrows, and save diagrams as XML or PNG.

Learn how stratification splits data from multiple sources to reveal hidden patterns, enabling targeted improvements by bottle size such as 300 ml, 500 ml, and 1000 ml.

Apply the seven basic quality tools to a case study of painting defects in an industrial product, aiming to reduce rework and waste.

Collect data with a checklist, identify defects, and apply Pareto analysis, fishbone diagrams, run charts, scatterplots, and control charts to reduce painting defects such as peeling and brush marks.

Assess a control chart from the seven basic quality tools to determine if the process can reliably produce items within the 92 to 106 mm range (average 99 mm).

In this case study, the x bar r chart uses averages of five items; control limits apply to averages, while individual values spread wider, indicating the process is not good.

Explore the seven basic quality tools, including cause-and-effect diagrams, check sheets, histograms, Pareto charts, scatter diagrams, flowcharts, and run charts, to solve quality problems.