The QI Macros SPC software for Mac is an Excel add-in that simplifies the creation of charts and graphs, including Pareto charts, control charts, and scatter plots. It features automated fishbone diagrams and statistical tests, making quality control and analysis easy. Simply choose your data and select a chart from the QI Macros menu.

Not only does QI Macros draw pareto charts, histograms with Cp Cpk, box whisker plots, scatter and control charts, it also contains over 100 Lean Six Sigma fill-in-the-blank templates including an automated fishbone diagram, value stream map, QFD, DOE, FMEA, PPAP forms and MSA Gage R&R.
Moreover, QI Macros performs an array of statistical analysis tests including ANOVA, t-test, F-test, and regression analysis. It also has the ability to clean up nonnumeric data, fix any misalignments and use data in any format, making it highly versatile and flexible.
QI Macros wizards also offer specialized functionality not found in any other statistical process control or six Sigma software. The Control Chart Wizard selects and runs the ideal control chart, while the Pivot Table wizard analyzes data and creates pivot tables effortlessly. The Data Mining wizard combines the power of both the Pivot Table and Control chart wizards and automatically creates control charts and pareto charts with one simple click. For statistical tests, the Statistical Wizard selects and runs the appropriate tests interpreting the results for you.
With over 100, 000 users including 2, 500+ hospitals and numerous manufacturing companies worldwide, QI Macros has become a go-to tool for businesses seeking to mistake-proof their six sigma data and statistical analysis. The software is compatible with PC and Mac, Excel 2010 to 2016 and Office 365.
QI Macros is a single-user perpetual license with no annual fees, and technical support is provided free of charge. Academic and quantity discounts are available. Additionally, users can take advantage of free training resources and a 30-day trial, downloadable from the QI Macros website (qimacros.com).
Version 2018-04: Excel 2016, Office 365 compatible | Data Mining Wizard 2.0 creates a pivot table, control chart, Pareto charts and fishbone diagram | Automated value stream map | MODAPTS template | real time XbarR template parses data from Gages | Eliminated chart title prompts to speed up chart creation
Version 2016.08: Excel 2016, Office 365 compatible | Data Mining Wizard creates a pivot table, generates an XmR chart and defect Paretos | 3 Legged 5 Whys Template, Short Run Control Charts | Enhanced Gantt Chart | Sample Size Calculator | Pooled Standard Deviation now the default estimator for Cp Cpk.