QETools

Description

QETools is an Excel-based Add-in of statistical and SPC tools. QETools provides high value statistical analysis software and solutions to support Six Sigma and Design for Six Sigma Continuous Improvement Efforts. The company was formed initially by University of Michigan researchers to provide a highly functional, user-friendly, Excel-based add-in tool for Six Sigma practitioners. The QETools add-in allows users to Quickly and Easily learn and apply the various problem solving TOOLS and statistical analysis methods. QETools software focuses on providing data analysis tools and problem solving templates commonly used in Six Sigma Green Belt projects. QETools also provides a Six Sigma analysis roadmap to help users work through the DMAIC problem solving process.

Tools and templates are available directly within Excel via the QETools menu. File types are native Excel files and can be easily shared.

Data Manipulation

-Subset

-Split

Six Sigma Methods & Templates

-DMAIC Tool Roadmap

-Project Charter Template

-SIPOC

-Cause & Effect Diagram

-Cause & Effect Matrix

-FMEA Table

-Process Control Plan - Manufacturing & Transactional

-QFD-House of Quality

-Pugh Matrix

-Scorecard

-TRIZ Contradiction Analysis

Descriptive Statistics and Process Capability

-Basic Descriptive Statistics

-Frequency Analysis

-Ordinal Data Analysis

-Sigma Level, DPMO and PPM Converters

-Process Capability Summary - Normal & Non-Normal

-Rolled Yield Analyzer

Graphical Tools

-Run Chart

-Pareto Analysis

-Histogram

-Dot Plot

-Frequency Bar Graph

-Box Plot (single- or multi-)

-Scatter Plot

-Distribution ID

-Individual Values Plot

SPC

-X-Bar / Range, X-Bar / S, Individual / Moving Range, P/NP/U/C/G Charts

Tabulation

-One-Way Tabulation (text or data)

-Cross Tabulation

-Cross Tabulation with Chi-Square Analysis

-Binary Cross Tabulation with Pareto

Measurement Systems

Gage R&R

Paired (Repeated) Measurements

Attribute Matching

Plus, Regression/Correlation, Hypothesis Tests and Tolerance Analysis