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

Study design

Process control and capability analysis study requirements and dataset layout.

Requirements

  • A categorical or quantitative variable.
  • A stratification variable.
  • A subgroup variable.
  • A phase/stage variable.

Dataset layout for individuals or fixed subgroup size

Use a column for each variable (Copper); each row has a single measurement.

Copper
7.96
8.52
9.24
7.96
10.04
8.68
7.46
8.84
8.9
9.28
…

Advanced dataset layout with stratification and phases

Use a column for each variable (Copper), and optionally columns for subgroup (Day), stratification (Operator), phase/stage (Phase); each row has a single measurement.

Day (optional) Operator (optional) Phase (optional) Copper Comments (optional)
1 SNH IQ 7.96  
1 SNH IQ 8.52  
2 JDH IQ 9.24  
2 GMH IQ 7.96  
3 SNH IQ 10.04 Electrode failure
3 SNH IQ 8.68  
… … IQ …  
20 JDH OQ 8.68  
20 SNH OQ 8.76  
21 JDH OQ 8.02  
21 GMH OQ 8.7  
… … OQ …  

Frequency form dataset layout

Use a column for each subgroup (Sample), a column for the subgroup size (Sample size), and a column for the number of cases (Frequency); each row has a the frequency count for each sample.

Sample Sample size Nonconforming units
1 100 7
2 80 8
3 80 12
4 100 6
5 110 10
6 110 12
7 100 16
8 90 10
9 90 6
10 120 20
… … …
Related information
Estimating process capability
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
  •  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.