Seven Basic Tools of Quality, SPC and Control Charts

Utilize a Pareto chart, a combined bar and line graph, to rank causes in descending order and reveal the cumulative impact of the vital few for targeted improvements.

Create a Pareto chart in Excel by sorting values descending, building a cumulative percentage line, and using a combo chart with bars and a secondary-axis line.

Learn how stratification divides data into categories to reveal variation, plan stratification factors before data collection, and create an Excel stratification chart using a clustered column chart to compare groups.

Explore how a histogram shows the frequency distribution of a variable using intervals and groups. Identify patterns—symmetric unimodal, skewed, bimodal, or multimodal—and note the mean, variation, and the normal curve.

Create a histogram in Excel from 100 observations, using about 10 intervals, with continuous data, and count frequencies via countifs to reveal the frequency distribution.

Uncover root causes with the cause-and-effect (fishbone) diagram, organizing factors into groups like men, materials, machines, methods, and measurements, through team brainstorming.

Create a fishbone diagram in Excel by inserting a main spine arrow and four group boxes, then list causes under each group and show the effect on the right.

Plot data sets on a scatter diagram (x axis for the cause, y axis for the effect) to reveal strong or weak, positive or negative, no relationship, or complex relationships.

Learn to create a scatter diagram in Excel to analyze how temperature relates to film thickness, and identify no, weak, or strong positive relationships.

Learn how to design and use a check sheet to collect data with check marks, track defects by location and time, and support quality control through stratification and standardized data.

Trace the evolution of quality control, distinguish random and assignable variation, and learn to use control charts and the seven basic tools to reduce variability.

Learn statistical process control and control charts that use a central line and three-sigma limits to detect assignable variation and improve quality while reducing spoilage.

Explore how control charts distinguish variable and attribute data, selecting subgroups and chart types by sample size, and interpret patterns to detect external causes and trends.

Learn to construct an X-bar and R chart in Excel using five-sample subgroups, calculate the mean and range, determine UCL and LCL, and interpret out-of-control points.

Learn how to build an x-bar and r chart in excel, calculating ucl and lcl, and interpreting range and mean control using a sample size of five.

Learn to build an x-bar s chart in excel by calculating x-bar, s-bar, and control limits (ucl and lcl) for subgroups of size 11, then identify out-of-control points.

Construct an x bar s chart in Excel by calculating standard deviation to set UCL and LCL for sample size 11, and assess values for in or out of control.

Learn to construct a p chart in Excel for quality control, calculating p-bar, control limits, and handling variable sample sizes in SPC.

Learn to build an np chart in Excel by calculating np and p-bar from 15 subgroups of 150 items, computing UCL and LCL, and plotting the control chart.

Explore the seven basic tools of quality, including histogram, stratification, Ishikawa diagram, and check sheets, and apply data collection, Pareto prioritization, and control charts for improvement.