How to manage your process using statistical Excel Tools

Calculate overall yield and uncover the hidden factory through first time yield analysis of packaging, inspection, and rework, revealing 70.7 percent first time yield and 27.9 percent hidden factory.

Explore how to map a three-step process with a flowchart, track scrap and rework, and compute first-time yield or throughput yield to reveal true process performance.

Identify complexity in processes, enable communication, and guide quality improvement by capturing current work and evolving to a final map created by those closest to the process, using Microsoft Bisio.

Learn how to create basic to cross-functional process flowcharts in Excel using built-in templates, customize shapes and connectors, update data through refresh, and export the diagram with Snipping Tool.

Learn to build flowcharts in Excel using shapes, including rectangles and diamonds for steps and decisions, add connectors, customize color and text, and group items for flexible diagrams.

Identify continuous and attribute data in statistical process control, and learn how data type choices—measurements, fractions, and pass/fail counts—shape analysis in Excel tools.

Compare the center and spread of distributions by calculating the mean from samples across three machines. Use standard deviation to assess variation; a lower value means more consistent sugar percent.

Learn descriptive data analysis in Excel by creating a histogram and a box plot from 50 samples to explore moisture percentage, particle size, and density and identify data distribution.

Explore histogram and boxplot analyses to assess data distribution, detect outliers, and distinguish normal vs non-normal shapes while relating mean and standard deviation to specification limits for quality improvement.

Explore hypothesis testing in Excel by comparing a sample mean to a target with the data analysis toolpak and t-test, interpreting p-values to assess if the target is met.

Learn when to use c chart or p chart for defect data, set control limits, and choose appropriate charts based on data type and sample size, with root cause analysis.

learn to create control charts in excel using formulas, including calculating mean and standard deviation, and plotting upper and lower control limits with three standard deviations.

Explore free Excel templates for statistical process control, including run charts, P charts, and descriptive statistics with normality tests, to assess data normality and automatically compute control limits.