Print
Statistical Reference Guide
Pareto analysis
Merging Pareto chart categories
Merge categories to reduce clutter and see the vital few rather than the trivial many.
You must have already completed either of the tasks:
Creating a Pareto chart
Creating comparative Pareto charts
Activate the analysis report worksheet.
On the
Analyse-it
ribbon tab,
in the
Pareto
group, click
Combine
.
The analysis task pane, the
Categories
panel opens.
To merge all the categories with a frequency less than a threshold:
In the
Combine
group, select the
Threshold
option.
In the
Less than value / %
edit box, type the frequency count or relative frequency % threshold.
In the
Name
edit box, type the name of the newly merged category.
To merge a fixed number of smallest categories:
In the
Combine
group, select the
Last
option.
In the
Categories / %
edit box, type the number of categories to merge, or the % of categories.
In the
Name
edit box, type the name of the newly merged category.
To merge specific categories:
In the
Combine
group, select the
Custom
option.
In the
Categories
grid, click to select the first category, and then hold down SHIFT and click to select the last category to make a contiguous selection, or hold down CTRL and click to select additional categories to make a discontiguous selection.
Click
Merge
.
In the
Categories
grid, under the
Name
column, alongside the category in the edit box, type the name of the newly merged category.
Click
Recalculate
.
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
Products
Store
Support
Blog
About us
Download trial
Search
Sign in
Contact us
Analyse-it Software, Ltd.
The Tannery, 91 Kirkstall Road,
Leeds, LS3 1HS,
United Kingdom
Home
Products
Blog
Contact us
Privacy policy
® Copyright Analyse-it Software, Ltd. 2024.
All rights reserved.
MSA (Measurement System Analysis) software
Measurement System Analysis software
Reference interval software
ROC curve software
Sensitivity & Specificity analysis software
Method comparison software
Bland-Altman software
Deming regression software
Passing Bablok software
Method Validation software
Statistical Process Control (SPC) statistical software
SPC software
Six Sigma statistical software
Excel SPC addin
Excel Statistical Process Control (SPC) add-in
Pareto plot software software for Excel
Pareto plot add-in software for Excel
Pareto chart add-in software for Excel
Control chart Excel add-in
Process Capability statistical software
Capability Analysis add-in software
Principal Component analysis addin software
Excel PCA add-in
Excel ANOVA add-in
ANCOVA software
Multiple Regression analysis add-in software
Multiple Linear Regression statistical software
Excel model fitting software
Excel statistics analysis addin software
Excel statistical analysis addin software
Statistics software
Statistical analysis software
Last update 4:09:23 PM
AnalyseIt.Public 4.0.9096.31831 Production US Remote database