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

Sharing knowledge

It's always good to share the knowledge with other teams and management as successful improvements can encourage other improvements and keep management on-board.

  1. On the Analyse-it ribbon tab, in the Report group, click Clone.

    The dataset worksheet and analysis task pane are displayed.

  2. In the Factor (row) drop-down list, select None.
  3. To highlight the problem we have improved:
    1. On the Analyse-it ribbon tab, in the Pareto group, click Vary color.
    2. Select the Assign Colors check box.
    3. In the Categories grid, under the Color column, alongside Colorimeter drift in the drop-down list, select the color red.
  4. Click Calculate.
    The results are calculated and the analysis report opens.

Training reduced the downtime due to colorimeter drift from 51 hours (60% of downtime) over a six week period to just 26 hours (45%) in the six week period following a new training programme.

Comparative Pareto charts

  •  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
  •  Identifying frequent problems
  •  Investigating stratification
  •  Highlighting the vital few and hiding the trivial many
  •  Monitoring improvements
  •  Sharing knowledge
  •  Process control charts tutorial
  •  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.