QI Macros - the All in One Tool for Quality Professionals

SPC Charts - Lean Six Sigma Templates - Statistics - Data Mining

I’ve been using your QI Macros for the last ten years and have always found them the best and lowest cost tool available. The other “stat” and charting programs are way too expensive and complex for most of the QA people that I’ve trained.

- Steve Hoyt
ASQ Program Chair

QI Macros Add-In for Excel Installs a New Menu on Excel's Toolbar

QI Macros add-in for Excel

Tools are Grouped in These Key Categories

statistical formulaStatistical Tools

QI Macros simplifies hypothesis testing and automatically interprets the results for you by answering the questions:

  • "What does the p-value mean?"
  • "Are the means and variance the same or different?"

It's like having a statistician at your side. Run ANOVA, t-tests, f-tests, regression analysis and more. Our Stat Wizard will even determine which tests to run.

fishboneLean Six Sigma Templates

QI Macros contains over 100 fill-in-the-blank templates and tools for all your Lean Six Sigma needs.

  • Perform advanced analysis like Gage R&R, DOE and so on.
  • Calculate sample size, DPMO and rolled throughput yield.
  • Save time using our Automated Fishbone Diagram.
Data Mining Tools

Data Mining Wizard will analyze an entire table of data using PivotTables, control charts and Pareto charts. It will create all of the charts necessary to develop a rock-solid, bullet-proof business case for change.

PivotTable wizard takes up to four columns of data you select and creates a PivotTable with one click.

Word Count wizard analyzes text data from employee and customer comment fields to help you find out what your customers are trying to tell you.

QI Macros is long on Six Sigma capabilities, with some Lean tools and techniques built in as well... Chances are many Green Belts and some Black Belts will be able to do everything they need with QI Macros and Excel...

The familiar Excel interface reduces the learning curve and makes it a viable option for anyone who needs to create control charts, conduct statistical analysis or perform data manipulations.

Heidi Wiesenfelder, Bright Hub