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.
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 non-numeric 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.
What's new in this version:
- Histogram with Weibull Analysis
- Capability Suite Macro
- X Chart
- R/S Chart
- Histogram with Cp and Cpk
- Probability Plot
- Values Plot
- Capability Plot
- Capability Suite Templates
- XmR Five Pack
- XbarR Six Pack
- XbarS Six Pack
- Stability Analysis Tools
- Green Up/Green Down to show "good" out of control points
- Show/Hide Rules to show ru... See all new features »