QI Macros SPC Excel
QI Macros SPC Software is an SPC Excel add-in for control charts, histograms, Six Sigma documentation and statistical analysis.
QI Macros SPC Software is an SPC Excel add-in for control charts, histograms, Six Sigma documentation and statistical analysis.
QI Macros wizards contain functionality not included in any other six sigma or statistical process control software. The Data Mining Wizard creates a pivot table of data, and generates an XmR chart and defect Paretos. 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:
New Data Mining Wizard creates a pivot table of data, and generates an XmR chart and defect Paretos with one click. Made Pooled Standard Deviation the default estimator for Cp and Cpk. Sbar/c4 and Rbar/d2 can still be used by changing the estimator field. Enhanced Gantt Chart Template 3 Legged 5 Whys Template Short Run Control Charts Consolidated in one Template Standard Work Template for Lean. Sample Size Calculator expanded...