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.
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 Data Mining 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 2010 to 2019 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.