Qi Macros
. CNET Editors' review by: on May 12, 2010 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.
Qi Macros
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.
QI Macros® simplifies statistics, control charts, Pareto charts and histograms in Microsoft Excel. We've been helping companies create improvements in quality, cost.
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. From: The 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.
The 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. 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 nonnumeric data, fix any misalignments 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. CNET TechTracker will now automatically install software without requiring further action by you. (Note: This feature automatically accepts associated EULAs and third party applications on your behalf.) You have selected the following software to Smart Install: CNET TechTracker will attempt to install this software without interrupting you again. If an application requires manual installation, CNET TechTracker will download the installer and prompt you to take further action. Proceed with Smart Install?
16 Control Chart Wizard. 16 c, np, p, u Chart s. 17 X Chart s. 18 Stabil ity Rules. 20 Contr ol Chart Tools Menu. 21 Control Chart Templates.