SPC Software Chart Comparison

QI Macros Charts Make You Look Like an Expert

Create Charts in Minutes that Look Like They Took Hours

Pareto Charts: A key element of a pareto chart is the cumulative line graph which shows the percent contribution of all preceding bars. This helps determine how much each bar or combination of bars represents of the problem. Unfortunately, most SPC software packages miss the point. The pareto charts created by these applications don't display the cumulative percentages at all or display them in a manner that is hard to correspond to the graph.

Box Whisker Plots: A key element of a box whisker plot is the outliers. Outlier points are those that are greater than 1.5 times (Q3 -Q1). Again, most SPC Sofware packages omit these from their box whisker plots.

Pareto Chart
Comparison

QI Macros® $249 USD

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

Minitab® $1,595

Left axis isn't scaled properly and cumulative line graph doesn't extend through the chart as it should.
Cumulative percentages are below - not on the line.

CHARTrunner® $1,290

There is no cumulative line graph so this isn't really a pareto, just a sorted bar chart.

SigmaXL® $299

Pareto background is gray; bars don't touch; left axis isn't scaled properly; and cumulative line graph doesn't extend through the chart as it should. And you can't read the cumulative percentages off of the line.

SPC XL $249

The bars don't touch; and cumulative line graph doesn't extend through the chart as it should. The cumulative percentages are not shown on the line.

Box Whisker Plot
Comparison

QI Macros® $249 USD

Box Whisker Plot in Excel using the QI Macros

Second and Third Quartiles within the box are highlighted using different colors.
Shows all outliers.

Minitab® $1,595
Minitab Box Plot vs QI Macros Box Plot

Second and Third Quartiles within the box are the same color.
Only shows the furthest outlier.

 

CHARTrunner® $1,290

ChartRunner Box Whisker vs QI Macros Box Whisker

Second and Third Quartiles within the box are the same color.
Only shows max and min values not outliers as defined by most SPC texts.

SigmaXL® $299

SigmaXL® Box Whisker vs QI Macros Box Whisker

Second and Third Quartiles within the box are the same color.
Only shows max and min values not outliers as defined by most SPC texts.



SPC XL $249

SPC Excel Pareto vs QI Macros Pareto

Second and Third Quartiles within the box are the same color. Only shows max and min values not outliers as defined by most SPC texts.

What People are Saying...

I have been a fan and advocate for QI Macros for about as long as you have been in business. For the past 10 years I have been an ISO 9000 Consultant and use QI Macros for my data analysis and have had most of my customers buy QI Macros. All of my customers are small companies, QI Macros meets and exceeds their needs at a fraction of the costs of a Mintab or other similar products.

Tom Arneson, Focus Consulting LLC

 

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