This license is made for one lean six sigma training class with a maximum of 12 trainees and one trainer. We will register the trainer and the trainer will email equablesolutions (franck.strub@equableus.com) the email addresses of all the trainees who received a copy of the DMAIC Suite version during the training.
The DMAIC Suite is a statistical multilanguages* application under the form of an Excel file with worksheets which enables Lean Six Sigma Black Belts and Green Belts to achieve all their statistical, graphical measures and analysis for the DMAIC phases of their projects. Easy to use and intuitive, documented with examples. Just enter your data and let the software compute, display the graphs and interpret the results on the fly!!
It includes all statistical tools for DMAIC: Measure gage R&R study for both attribute and continuous data, Measure Performance, Stats and graphics for both attribute and continuous data, Analysis of continuous Y with continuous X and attribute X, Analysis of attribute Y with attribute X, Proof of improvement for both attribute and continuous Y, Control cards for SPC and for continuous Y and attribute Y.
Details:
*Available languages: English(default), Spanish, German, French, Chinese
Measure:
 gage R&R study for continuous Y (ANOVA method with % of study variation, % of tolerance, Number of distinct categories)
 gage R&R study for attribute Y (% of agreements of operators repeatability, % of agreements of operators reproducibility, % of agreements of operators repeatability versus a standard, % of agreements of operator reproducibility versus a standard, % of concordant agreements vs standard, % of OK evaluated KO, % of KO evaluated OK)
 Continuous Y performance: (sample max size is 20 000 data)
 graphs: IMR control cards, Histogram with specification limits, box plot with specification limits
 Sample size estimation
 Normality test with p_value calculation and test significance result/interpretation
 Basic statistics
 Process capability with Z long term and short term calculation for both normal and non normal data
 Attribute Y: PPM calculation with pie chart, DPMO calculation with pie chart, Rolled Throughput Yield calculation, OEE calculation, Sample size estimation, Defect categorization with Pareto chart and pie chart
Analysis:
 Continuous Y, Attribute X analysis:
 Up to 5 attribute values for X (5 subgroups of 5000 Y data max)
 Box plot with USL and LSL specification limits and mean line
 For each subgroup:
 Normality test
 Basic statistics
 Process capability with Z long term and short term calculation for both normal and non normal data
 5 subgroups means, medians and variances systematic hypothesis tests with p_value results and tests significance results/interpretations
 Continuous Y, continuous X analysis:
 Simple linear regression with Y=f(X) equation and R_square value displayed on regression graph
 Simple quadratic regression with Y=f(X) equation and R_square value displayed on regression graph
 Simple cubic regression with Y=f(X) equation and R_square value displayed on regression graph
 Y targeting with automatic equation resolution for X adjustment(s)  optional
 Y target and X adjustment(s) display on all regression graphs
 Attribute Y, Attribute X analysis:
 Chi square test with up to 5 attributes for Y and for X table
 Expected frequency and chi square contribution of each cell of the chi square table
 p_value calculation
 Chi square test significance result/interpretation
 Pareto tool and pie chart for attribute factor analysis
Improve:
 Y continuous proof of improvement:
 "Before" and "After" subgroups (20 000 Y data max per subgroup)
 Box plot with USL and LSL specification limits and mean line
 For each "before" and "after" subgroup:
 Normality test
 Basic statistics
 Process capability with Z long term and short term calculation for both normal and non normal data
"Before" and "After" subgroups means, medians and variances systematic hypothesis tests with p_value results and tests significance results/interpretations
 Y attribute proof of improvement:
 Chi square test with up to 5 attributes for Y and 2 attributes ("Before" and "After") for X
 Expected frequency and chi square contribution of each cell of the chi square table
 p_value calculation
 Chi square test significance result/interpretation
Control:
 Continuous Y:
 IMR control card
 XbarR control card
 XbarS control card
 Attribute Y:
 P control card
 U control card
What do you get when ordering the DMAIC Suite?
Once you order and pay the DMAIC Suite, you will be directed to a Download directory where you will find the DMAIC Suite zip file to download to your computer.
First download the file "DMAIC Suite V2 english.zip" to your computer.
Then you will need to unzip this downloaded zip file (usually done by double clicking on it).
Finally you will get an excel file named "DMAIC Suite V2 english.xlsx" on your computer.
You can open the file in Excel by double clicking on it or opening first Excel and then opening the DMAIC Suite V2 english.xlsx file in Excel. The DMAIC Suite contains 15 worksheets. All worksheets come with prefilled data provided for example.
What to do first when working with the DMAIC Suite?
First thing that we recommend you to do is to save as the DMAIC Suite file onto your computer under a different name and keep the original DMAIC Suite V2 english.xlsx file as a backup.
Then you will have to clear all the prefilled data and start to fill the columns with your data. In case of data existing in another excel file, we recommend to copy and paste special values these existing data in the DMAIC Suite model.
For your information, all the blue cells are protected cells. All the white cells are not protected and you can input your data in them. Protected blue cells cannot be erased but they can be formatted and for those which contain formulas, the formulas are visible.
OS Compatibility: Windows, OSX (Apple), Linux since 2012
Excel compatibility: all excel versions supporting .xlsx format (since 2010 version)
The DMAIC Suite Multilanguage bundle license for a training class
 Brands Equable Solutions
 Product Code: sw_bdle_0001
 Availability: In Stock
 $499.00

$479.00
 Ex Tax: $479.00
Related Products
Tags: DMAIC Suite Multilanguage bundle license for a training class