Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Control charts
  • Shewhart control charts
  • Shewhart variables control charts

Creating a Xbar-R / S control chart

Plot a Shewhart control chart for data collected in rational subgroups to determine if a process is in a state of statistical control.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Process Control, and then click the type of control chart:
    Option Description
    Xbar-R Plot Shewhart control charts of the mean and range of subgroups.
    Xbar-S Plot Shewhart control charts of the mean and standard deviation of subgroups.
    Xbar Plot a Shewhart control chart of the mean of subgroups.
    R Plot a Shewhart control chart of the range of subgroups.
    S Plot a Shewhart control chart of the standard deviation of subgroups.
    The analysis task pane opens.
  3. In the Process drop-down list, select the quality characteristic variable.
  4. In the Sample size group:
    • If the subgroups are identified by a variable, select Subgroup by identifier variable, and in the Id drop-down list, select the subgroup identifier variable.
    • If the subgroups are a constant size and formed by consecutive number of observations of the process variable, select Subgroup size constant, and in the edit box, enter the number of consecutive observations per subgroup.
  5. In the Control limits drop-down list:
    • To define control limits based on a multiple of the process sigma, select Sigma, and then in the edit box, type the multiple of the process sigma to define the control limits.
    • To define control limits based on the probability distribution, select Probability, and then in the edit box, type the probability that a single statistic exceeds the control limits, assuming the process is in control.
  6. Optional: To specify known process parameters, select the Known process parameters check box, and then in either or both the Mean and Standard deviation edit boxes, type the known value of the parameter.
  7. Optional: To show the process mean and sigma statistics, select the Show process statistics check box.
  8. Optional: To show the center and control limit statistics, select the Show process control statistics check box.
  9. Click Calculate.
Related concepts
Xbar-S chart
Xbar chart
S chart
Xbar-R chart
R chart
Related tasks
Applying phases/stages for each change in a process
Applying rules to a Shewhart control chart
Formatting a control chart
Labeling control chart points
Related reference
Dataset layout
Available in Analyse-it Editions
Quality Control & Improvement edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Compare pairs
  •  Contingency tables
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Reference interval
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Shewhart control charts
  •  Shewhart variables control charts
  •  Xbar-R chart
  •  Xbar-S chart
  •  Xbar chart
  •  R chart
  •  S chart
  •  I-MR chart
  •  I chart
  •  MR chart
  •  Creating a Xbar-R / S control chart
  •  Creating an I-MR control chart
  •  Shewhart attributes control charts
  •  Shewhart control chart rules
  •  Applying rules to a Shewhart control chart
  •  Formatting a control chart
  •  Labeling control chart points
  •  Displaying stratification in a control chart
  •  Applying phases/stages for each change in a process
  •  Time-weighted control charts
  •  Study design
  •  Process capability
  •  Pareto analysis
  •  Study Designs
  •  Bibliography



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.