QI Macros SPC Software for Excel allows you to analyze data in a variety of formats, including histograms with Cp and Cpk, Pareto charts, scatter plots, box whisker plots, and all variable and attribute control charts.
Since this program integrates itself into Microsoft Excel's interface, you should have no problem using it. It appears as an extra tab at the top of your Excel window. The tab itself is broken into seven categories: Statistical Tools, Fill-in-the-Blanks Templates, Data Transformation, Capability Charts, Control Charts, Improvement Charts, and Other Charts. Each transforms your inputted data for the best analysis. We entered random numbers into the cells of our spreadsheet and tested the macros by clicking through the options. The g chart function quickly placed our random numbers into a chart, complete with built-in macros and a graph that changed with our data. We then took those same numbers and clicked the Box Whisker chart option. Again, the program placed our numbers into an attractive chart that graphed our entered data. The program doesn't include a Help feature through its interface, but it does offer assistance through its Web site, should you need it. Despite not being too familiar with some of the chart concepts, we were still able to quickly jump in and see our data come to life.
QI Macros SPC Software for Excel installs and uninstalls cleanly. We highly recommend this handy macros program for anyone in need of a way to display and analyze data.
QI Macros SPC Software for Excel draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more. Just select your data and then select the chart you want from the QI Macros menu.
QI Macros contains over 90 fill in the blank templates including QFD, Gage R&R, DOE, PPAP, FMEA and templates for control charts, histograms, pareto and other charts. The automated fishbone diagram makes root cause analysis a snap.
This Excel add-in is easy to use and delivers immediate results using Grab-It-And-Go Simplicity and mistake-proof selection of data. Your data can be connected or separated or in rows or columns. The QI Macros will clean up non-numeric data, fix any mis-alignments and use your data as you selected it.
The QI Macros wizards contain functionality not included in any other six sigma or statistical process control software. The Chart Wizard selects and runs possible charts for you. The Control Chart Wizard selects and runs the right control chart for you. The Control Chart Dashboards simplify monthly reporting. The PivotTable Wizard simplifies analyzing complex transaction files. 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 analysis and statistical calculations using this powerful tool.
What's new in this version:
- Automated Ishikawa Fishbone Diagram
- Fixed Limit Control Chart Macro
- Economic Order Quantity Template
- Remember and Apply Custom Excel Chart Formats for Re-use
- Time Value Map Template
- Post Hoc (ANOVA1)