Statistics add-in software for statistical analysis in Excel
  • Tutorials
  • Process control charts tutorial

Bringing a process under control

Process control charts identify special-causes of variation that need to eliminated to bring the process under control, so the results are predictable and can be used to determine the ability of a process to meet customer specifications.

  1. Open the file tutorials\Copper.xlsx.

    The worksheet is open with some of the data hidden. We will use the additional hidden data later in this tutorial.

  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Process Control, and then click Xbar-R.
    The analysis task pane opens.
  3. In the Process drop-down list, select Copper.
  4. In the Sample size group, select the Subgroup by identifier variable option.
  5. In the Id drop-down list, select Date.
  6. Click Calculate.
    The results are calculated and the analysis report opens.

During the installation period of a new automated colorimeter for controlling the copper content in the plating process control charts can be used to identify special-causes of variation that need to eliminated to make the process perform predictably. The Xbar and R charts plot the mean and range of the copper concentration in the plating pool respectively.

Xbar-R control chart
Inspecting the plots you can see special-cause variation is present in the process:
  • There is a point dated the 03/01 on the R chart with high variation.
  • There are 2 further points dated the 11/01 and 13/02 on the Xbar chart.
Next topic: Identifying stratification

  •  Tutorials
  •  Distribution tutorial
  •  Correlation / PCA tutorial
  •  Compare groups means tutorial
  •  Association in 2-way contingency tables tutorial
  •  Simple linear regression tutorial
  •  Bland-Altman method comparison tutorial
  •  Estimating the precision of a measurement procedure (CLSI EP05-A3)
  •  Evaluating the linearity of a measurement procedure (CLSI EP06-A)
  •  Verifying the precision of a measurement procedure against a performance claim and estimating the bias (CLSI EP15-A3)
  •  Pareto charts tutorial
  •  Process control charts tutorial
  •  Bringing a process under control
  •  Identifying stratification
  •  Identifying special-causes of variation
  •  Identifying shifts (and other patterns)
  •  Revising control limits
  •  Monitoring future production
  •  Process capability tutorial



Version 6.15
Published 18-Apr-2023
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.