Statistics add-in software for statistical analysis in Excel

Pareto analysis software for quality improvement One-way and two-way comparative Pareto charts — break down defects by shift, operator, machine, or product line to see not just what is failing, but where and why. Merge, reorder, and colour categories to focus on the vital few.

Try free for 15 days — no credit card required Analyse-it rated 4.9/5 on Capterra

Trusted by 75,000 researchers, analysts, and scientists at leading universities, hospitals, and companies worldwide — for over 30 years.

logo logo logo logo logo logo

Two-way comparative charts

Break defect categories down by a second factor — operator, shift, machine, product line, or time period. See whether a dominant defect type is evenly distributed or concentrated in a specific subgroup. One-way charts identify what fails; two-way charts show where and why.

Merge, reorder, and colour

Merge low-frequency categories into an "Other" bar to reduce clutter. Reorder bars to highlight specific problems rather than defaulting to frequency order. Vary colours to draw attention to priority areas or distinguish subgroups.

Connects to the rest of the DMAIC workflow

Identify the top defect with Pareto, monitor it with control charts, verify the improvement with capability analysis — all in the same workbook. One tool for problem identification through to sustained improvement.

A basic Pareto chart ranks defect categories by frequency and draws a cumulative percentage line. That identifies the vital few — but it doesn't tell you why they're happening. The same defect type may be concentrated on one shift, one machine, or one operator. Without a second dimension, you know where to focus but not where to investigate. Two-way comparative Pareto charts add that dimension, breaking each defect category down by a second factor so the pattern behind the numbers becomes visible.

Analyse-it builds both one-way and two-way Pareto charts directly from your defect log or inspection data. Select the defect category column, optionally select a second factor for comparative analysis, and the chart is built. The 80/20 line is displayed automatically. Merge small categories to keep the chart focused on meaningful problems. Reorder bars when the default frequency ranking doesn't match the story you need to tell — for example, grouping related defect types together. Colour bars to draw attention to the categories that matter most or to distinguish subgroups in a comparative chart. Update the data and the chart updates with it.

Pareto analysis is most useful when it connects to the rest of the improvement workflow. Once you've identified the top defect category, the next step is monitoring it — set up a control chart on the same data to track whether it improves over time. Then run a capability analysis to measure how much room for improvement exists against the specification. Analyse-it includes all three in the same package, so the workflow stays in one workbook rather than being split across separate tools.

75,000 professionals at leading companies, hospitals, and laboratories worldwide have relied on Analyse-it for over 30 years.

What's included

  • Identify the vital few defect categories

    Standard Pareto charts with bars for defect or failure mode frequency and a cumulative percentage line. The 80/20 line displayed automatically to identify the categories that account for most occurrences.

  • Break down defects by a second factor

    One-way and two-way comparative Pareto charts — defect type by shift, complaint category by product line, failure mode by operator. Identify whether a dominant problem is evenly distributed or concentrated in a specific subgroup.

  • Customise charts to tell the right story

    Merge low-frequency categories into "Other" to reduce clutter. Reorder bars to highlight specific problems or group related categories. Colour bars to draw attention to priority areas or distinguish subgroups in comparative charts.

  • Part of the QC and Improvement edition

    Pareto analysis is part of the QC and Improvement edition, which also covers Shewhart, CUSUM, and EWMA control charts with WECO/Nelson/Montgomery rules, process capability analysis (Cp, Cpk, Pp, Ppk, Cpm, Z-benchmark), hypothesis tests, and regression — the complete DMAIC statistical workflow in one package.

  • Analyse-it has helped tremendously. Previously I used Prism and Microsoft Excel, but Analyse-it has made my life so much easier and saved so much time.
    Man Khun Chan, M.Sc., ART
    Test Development Medical Technologist
    The Hospital For Sick Children, Toronto, Canada
  • I purchased Analyse-it and I love it. Thank you so much for the superb and easy to use program. Technical support is the best I have ever seen.
    Addy Alsumidaie, MD, Ph.D.
    Director, Clinical Development
    Johnson and Johnson
  • Using Analyse-it we have improved several of our quality control testing steps, better controlled our decision making and are still undergoing process improvements.
    Laura Smith
    Production manager
    The Binding Site
  • Although we only scratch the surface of Analyse-it’s capabilities, we have a very high volume of use for the statistics we need. It’s saved us time and the reports look professional.
    Michael Savage
    Chemistry Supervisor
    Baptist Hospital East

Trusted by 75,000 researchers, analysts, and scientists at leading universities, hospitals, and companies worldwide — for over 30 years.

Try free for 15 days — no credit card required Analyse-it rated 4.9/5 on Capterra


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.