Compare SigmaXL® to QI Macros®

QI Macros Wins on Price, Ease of Use, and Features

QI Macros Wins on Price

Quantity

SigmaXL®

QI Macros®

QI Macros Savings per License

1

$299 USD

$249 USD

$50

2 to 9

$269

$219

$50

10 to 20

$254

$199

$55

21 to 49

$239

$199

$40

50 to 99

$224

$179

$45

100 to 249

$209

$169

$40

250+

call

call

call

QI Macros is a technically reliable and very cost effective solution for our college; and very intuitive to use. The performance of this Excel add-in compares very well to other software that costs much more.

- Truett
Adjunct Instructor, Quality Manager


QI Macros is Easier to Use Than Sigma XL - Here's Why:

 

QI Macros

Sigma XL

Foundation it Was Built On

Clean Sheet

Mimics Minitab

First Step to Create a Chart:

Select the Data or the Chart?

 

Select Data

Analyze Data and Select Chart

qimacros Make Calculations and Draw Chart

Analyze Data and Select Chart

Point to Data

qimacros Make Calculations and Draw Chart

Why It Matters

Most users have data BUT don't know which chart to use.

qi macros is easy to use

choose control chart

QI Macros is a fantastic tool. It allows me to do things that once took 30-60 minutes down to 2-3 minutes. It's also very user-friendly and easy to operate.

- Wade Johnson
Carlson Craft Business Solutions

Ease of Use Step-by-Step Comparison

QI Macros

SigmaXL

1. In Excel, select your data

create spc chart step 1

1. In Excel, select the chart you want.

2. Click on QI Macros Menu and select the desired chart or the Control Chart Wizard if you are not sure.

qimacros-step2-xmr

2. In the Sigma XL window, define the data range in your spreadsheet.

3. QI Macros will do the math and draw the chart for you.

create spc chart step 3


Better yet, if you don't know which chart to use for your data, QI Macros control chart wizard can analyze your data and select the right chart for you.

 

3. Here is where SigmaXL gets ugly.

You have to define up to seven different items like numerator, denominator, data labels, chart title, etc. In comparison, the QI Macros contain code to determine most of this for you.

View larger image

4. QI Macros gives you more time to focus on the chart and what it tells you.

4. SigmaXL will do the math and draw the chart for you.

As you can see, there is a complicated additional step to achieve the same result. And, as we know from Lean, extra steps mean additional chance for error and more importantly: delay.

Most people find step 3 confusing.
How do I select my data? What column do I select to do what? Does it really need to be this hard?

QI Macros Charts Look Better and Are More Comprehensive

QI Macros Chart Examples

Pareto Chart

Bars over 20% of the total are shaded.
Bars have no space between them.
Cumulative line shows percent from 0% - 100%

Box and Whisker Chart

Second and Third Quartiles are distinguished using colors.
Shows all outliers.

Sigma XL Chart Examples

Pareto Chart

No special shading of bars.
Bars have space between them which looks like a bar chart.
Cumulative line doesn't extend through the chart as it should.

Box and Whisker Chart

Second and Third Quartiles within the box are the same color.
Outliers not shown.

QI Macros Features Not in Sigma XL

Wizards to Automate Data Analysis and Select the Right Charts or Statistical Tests

Because QI Macros has you select your data first, it can help you analyze it and run the right chart or test. Sigma XL and other competitors CANNOT do this since they make you select the chart first.

  • Data Mining Wizardcombines the power of the pivottable and control chart wizards to turn a table of raw data into the first steps of an improvement story with just one click
  • Chart Wizardchooses and runs all possible charts from your data
  • Control Chart Wizardchooses and runs the correct control chart from your data
  • Statisticschooses and runs all possible hypothesis tests
  • PivotTable - shortcut to Excel Pivottables - just select up to four columns of data and we organize your pivot table for you

I was very well impressed with the functionality of QI Macros Data Mining Wizard. This certainly saves time and cuts down the chart populating process substantially. I will be recommending this tool to my colleagues here at work and within the ASQ leadership community.

- Data Analyst
Medical Device Manufacturer 

Automated control chart dashboards: 

Just drop your data sets into the data input sheet and click on the "Create Charts" macro button to create a control chart dashboard for all of your measures.

Fill-in-the-blank chart templates: 

QI Macros contain more than 40 chart templates including all attribute and variable control charts, pareto, scatter, box whisker charts, histograms and more. Just drop your data into the yellow input area and your charts are built in the same spreadsheet.

Every two weeks I have to update 600 control charts for more than 30 hospitals in our system. I used to spend three days updating these charts. Once we created the charts using QI Macros Control Chart Dashboards, and utilized automation including stability analysis, we reduced the time it takes to update the charts to just three hours. QI Macros Control Chart Dashboards save me valuable time that I can use for other important projects. Thanks for making this process quicker and easier. 

- Mary Ayuso
Adventist Health System

No matter the criteria - QI Macros come out on top.

Purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!