Create SPC charts and Six Sigma projects in Microsoft Excel.
QI Macros SPC Software for Excel is an affordable, easy-to-use Excel add-in for all your data analysis needs. It draws Pareto charts, histograms with Cp Cpk, box whisker plots, scatter, and control charts. It contains more than 100 fill-in-the-blank templates such as an automated fishbone diagram, value stream map, QFD, DOE, FMEA, PPAP forms and MSA Gage R&R. It performs statistical analysis tests including ANOVA, t-test, F-test, and regression analysis. This Excel add-in will deliver immediate results in business environments using Grab-It-And-Go Simplicity and mistake-proof selection of data. Your data can be connected or separated or in rows or columns. QI Macros will clean up nonnumeric data, fix any misalignments and use your data as you selected it. QI Macros Wizards contain functionality not included in any other six sigma or statistical process control software. The Control Chart Wizard selects and runs the right control chart for you. The Pivot Table Wizard analyzes your data and creates a pivot table for you. The Improvement Project Wizard combines the power of the Pivot Table and Control Chart Wizards and automatically creates control charts and pareto charts from a data spreadsheet with one click. The Statistical Wizard selects and runs the right statistical tests and even interprets the results for you (e.g., reject or accept the null hypothesis, mean / variances are the same or different). Mistake-proof your six-sigma data and statistical analysis using this powerful tool. QI Macros is compatible with PC and Mac, Excel 2013 to 2021 and Office 365. We have more than 100,000 users at 2,500+ hospitals and thousands of manufacturing companies world-wide. QI Macros is a single-user, perpetual license with no annual fees. There is no charge for technical support. Academic and quantity discounts are available.
Easy to Learn, Use, and Help Everyone Understand Data
jlinnins
Pros
Simple plug in to Excel. This integration makes learning and using a much easier task. The layout and the surprising number of helpful tools, charts, and templates is amazing! You can, literally, do EVERY THING you need to do and document for an improvement project in QI Macros. This enables you to create an Excel workbook for the entire project and have all your data, charts, and documentation in a single file.
Cons
For me, after doing PI work for over 25 years and using probably every statistics/SPC tool out there, the only CON I can think of is that I didn't find this earlier. The QI Macros website is absolutely full of helpful videos, templates, advice, and examples. You cannot beat the value you get with QI Macros.
Summary
Buy it. NOW! You will be glad you did. It really takes the stress out of projects, data collection and analysis, and is so accommodating to your needs to "customize" your charts with annotations, legends, logos, etc. I have it on my home computer and my work computer. It is THE most helpful SPC tool out there. It does everything the "bib boys" do at a fraction of the cost. Again, buy it. NOW! :-)
Excellent quality analysis tool for Excel
lmconsulting
Pros
Integrated with Excel
Reasonable cost
Lots of features
Easy to use (once you understand the terminology)
On line training and tutorials
Cons
Doesn't replace the need to understand quality metrics.
Can be a little overwhelming for quality newcomers, but there are tutorials to help.
Summary
I have been using QI Macros for over 10 years at multiple companies. For Excel users the tool creates multiple charts and graphs, plus it has templates and examples for items like Gage R&R and FMEA. Definitely a must have if you're doing data analysis or involved with quality metrics.
Amazing product
Pros
Saves time, very effective
Cons
can't think of any
Summary
QI Macros is easy to use
smarthu
Pros
The product is easy to install and to use; it's a good alternative to Minitab and uses Excel and your own data. You can redo the charts as many times as needed. There are Control Charts, Histograms and other Capability Analysis tools, Anova and other statistical tools. It has a couple of wizards.
And, the website has tons of information (do a search for whatever chart or information you need) and a support page.
Cons
The product may contain more charts/templates than you need, but you can pick-and-choose which ones you need and which you don't.
Summary
There is a free trial if you go to the website.
Lots of tools, much too complicated and no support
sking114
Pros
There are pros to this excel add-in. There are tons of statistical tools that can you can use on your data sets and it makes things like correlation analysis a breeze.
Cons
Where to begin...
1 - First off there is no instruction manual. They include a 2 page description of some of the tools on their website but that is about it. With over 50 tools in the package it is very difficult to find which one you need. Additionally, if you have any concerns about how the calculations need to be set up or are taking place there is no way to check (add-in encrypted in VBA).
2 - No support: Since there was no manual I had to call QIMacros multiple times to ask a simple question (Are blank cells counted as zeros or not included), and was told "THEY AREN'T SURE BECAUSE THEY AREN'T STATISTICIANS", WHAT??
3 - Not a great output: once you do figure out how to use the product (without any help from QIMacros), the organization and output of the macro is rough at best.
Summary
Overpriced, under explained, no support because staff doesn't understand product.
Overall QIMacros is a nice stat package for excel but at $229 it is overpriced due to the fact that you won't be able to use 90% of the tools in a business setting (without knowing any of the underlying calculation/assumptions) and while there is tech support the staff do not have enough technical training or knowledge to help.
Also, most people will probably only use QIMacros for one or two of the tools (I usually just use the correlation function) and the macros they have programmed are nothing special. My advice is, unless you are a statistician and plans on investing lots of time on the phone trying to understand the product, make you own table or spreadsheet. It'll save you $230, allow you to be confident in your calculations, allow you to have a cleaner output, and you may learn useful information for the future.
10 out of 10
nirmalmthp
Pros
Just awesome.Can't compare any other excel templates with this.
Cons
None..except for.........
Summary
I am using this product since 4 years and am loving its easy interface.