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

Study design

Pareto analysis study requirements and dataset layout.

Requirements

  • A categorical variable of failures.
  • 1 or 2 factor variables.

Dataset layout

Use a column for the variable (Failute), an optional column for the factor variable (Operator); each row has the values of the variables for a failure (ID).

ID (optional) Operator (optional) Failure
1 SNH Colorimeter drift
2 SNH Miscellaneous
3 JDH Electrode failure
4 GMH Deformed tubing
5 SNH Reagents
6 SNH Light failure
7 JDH Deformed tubing
8 SNH Colorimeter drift
9 JDH Colorimeter drift
10 GMH Deformed tubing
… … …

Frequency form dataset layout

Use a column for the variable (Failute), an optional column for the factor variable (Operator) and a column for the number of cases (Frequency); each row has the values of the variables and the frequency count.

Failure Operator (optional) Frequency
Colorimeter drift SNH 14
Colorimeter drift JDH 15
Colorimeter drift GMH 22
Deformed tubing SNH 4
Deformed tubing JDH 5
Deformed tubing GMH 5
Electrode failure SNH 1
Electrode failure JDH 2
Electrode failure GMH 3
… … …
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
  •  Process capability
  •  Pareto analysis
  •  Pareto chart
  •  Creating a Pareto chart
  •  Creating comparative Pareto charts
  •  Merging Pareto chart categories
  •  Varying Pareto chart bar colors
  •  Reordering Pareto chart bars
  •  Sorting bars on comparative Pareto charts
  •  Study design
  •  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.