QI Macros

Description

Draws pareto charts, control charts, histograms, box and whisker plots and scatter plots for Excel. Includes over 80 fill in the blank templates including QFD, GageR&R, DOE, PPAP and FMEA.

QI Macros turns Microsoft Excel into a power tool for lean Six Sigma and SPC. It draws control charts, pareto charts, histograms, fishbones and more. The four “wizards” slash the Six Sigma learning curve by helping beginners automatically get the right chart or statistic.
QI Macros works right in Excel, no need to move or copy data into another application. Just select your data and choose the chart or wizard from the QI Macros menu. Works in PC (Windows XP, Vista, 7, 8 and 10), Macintosh (OSX) and Excel XL2007-2016.

Key Features:

• Create SPC Charts in Seconds Easily Customise and Share: Just select your data and then select the chart you want from QI Macros menu. QI Macros does the math and draws the chart for you. The output is an Excel chart that you can customise and share with colleagues.
• Conduct Analysis Using Fill in the Blank Templates: QI Macros contains over 100 excel templates enabling you to easily conduct DFSS analysis like Gage R&R, DOE and FMEA. Automated Fishbone documents root cause analysis in seconds.
• Find Hidden Opportunities Using Data Mining Tools: Use QI Macros data mining, pivot table and word count wizards to go from raw data to informative charts in seconds. Stack and restack tools help to easily reorganise your data for analysis.
• Perform Hypothesis Testing and Other Statistical Analysis: Just select your data and then select the statistical test you want from QI Macros menu. QI Macros does the math and even interprets the results for you (e.g accept/reject null hypothesis, means or variances are the same or different.)