Lean Six Sigma Online Trainging and Certification

EngineRoom^® Data Analysis Software - Feature Tour

EngineRoom is a Microsoft® Excel® software add-in that provides all level of Lean and Six Sigma practitioners with a full suite of powerful and simple-to-use data analysis tools.

The Tools of EngineRoom

EngineRoom is organized in a DMAIC format, with tools arranged as you would use them in the process of completing a Lean Six Sigma project. The table below lists the tools and templates in the latest version of EngineRoom, which works with Excel 2003 and 2007.

PHASE	TOOLS
Define	Affinity Diagram, Cause & Effect Matrix, CTQ Tree, Design Scorecard, Gantt Chart, Pareto, Project Charter, Project Priority Matrix, QFD, RACI (Stakeholder analysis) Template, SIPOC Map
Measure	Box Plots, C Chart, Check Sheet, CUSUM/EWMA Control Charts Templates, Data Collection Plan, Descriptive Statistics, Histogram, Input Screening Report, Measurement Systems Analysis (Variable and Attribute), Normality Test, NP Chart, P Chart, Process Capability, Sample Size Calculator (Parameter estimation), Scatter Plot, Sigma Level, Trend Chart, U Chart, X-bar & R Chart, X-bar & S Chart, XmR Chart
Analyze	Cause & Effect (Fishbone) Diagram, Cause-Effect Matrix, Designs of Experiments (Two-level Full and Fractional, General Factorials), DOE Planning Worksheet Template, Hypothesis Testing (Proportions Z-test, t-tests, Binomial, Chi-Square, F-test, ANOVA, Levene’s Modified, Sign, Wilcoxon Signed Ranks, Mann Whitney Wilcoxon, Kruskal Wallis, Friedman), Logistic Regression, Multiple Regression, Power and Sample Size (Hypothesis tests), Pugh Analysis, Sample Size, Simple Regression
Improve	Corrective Action Matrix, FMEA, Monte Carlo Analysis, Solution Selection Matrix
Control	Control Charts, Control Plan, Project Closeout
Lean Tools	5-Why, A-3 Template, Little’s Law Calculator, Value Stream Map
DFSS Tools	Affinity Diagram, Control plan, CTQC, Designs of Experiments, Design Scorecard, FMEA, Gantt Chart, Monte Carlo, Multiple Regression, Process Capability, Project Charter, Project Prioritizer, Pugh Concept Selection, QFD, Simple Regression

Top Lean Six Sigma Features in EngineRoom

Below are just a few of the useful features you will find in EngineRoom.

	Excel Compatibility Once you have opened Excel, you can easily access the Lean Six Sigma tools and templates of EngineRoom through a pull-down menu (or tab for 2007) titled EngineRoom, which becomes part of Excel. You can switch between the 'Describe-Compare-Model-Plan-SPC-Sample Size' shown to the left and a 'DMAIC' format as desired.
A Common Data Sheet for Variables Because EngineRoom accesses a common, centralized data sheet, it can reference variables by name. This format helps you to avoid the cutting and pasting of arrays commonly required by Excel.
	Simplified Data Entry You can load data into EngineRoom's templates by accessing variable names through a handy dialogue box.
Hypothesis Testing in Plain English^TM This patented interactive wizard makes Hypothesis Testing accessible to all levels of practitioners. The hypothesis wizard uses simplified explanations to provide guidance to the appropriate test and an explanation of the results. View a Flash movie demonstration of the Hypothesis Wizard features
	Design of Experiments for Everyone EngineRoom’s unique, interactive DOE Wizard guides you step-by-step through the process of experimental design creation and analysis. DOE is only available with the latest release of EngineRoom - Version 5.0! Now, with EngineRoom 5.0, the power and efficiency of DOE is available to practitioners of all skill levels to help achieve major breakthroughs in product and process improvements.
Stacked Histograms The Stacked Histogram option allows you to visually compare multiple data sets. EngineRoom automatically generates charts and graphs, which can easily be modified using standard Excel controls.
	Interactive Cause & Effect Diagram Templates for planning and data analysis include an interactive Cause & Effect diagram option. Once created, you can easily customize the Cause & Effect diagram.
Statistical Process Control (SPC) Need SPC? EngineRoom offers a full range of SPC charts that you can easily create using pull-down menus. Because these are Excel charts, you can easily save and share the outputs for viewing by other users who do not (regrettably) own EngineRoom.
	Multiple Regression Made Easy In EngineRoom, we have error-proofed Multiple Regression through the use of dialogue boxes that guide proper model creation. Once you have selected an alpha level, the model will prompt variable selection.
Linked Templates EngineRoom supports Voice of the Customer by linked templates from the Affinity Diagram through to the final Control Plan.

System Requirements for EngineRoom

Check these requirements first to ensure compatibility:

Operating System: Microsoft Windows® 98 or higher
- EngineRoom is not supported on the Apple OS.
Microsoft Excel: English-language version Microsoft Office® 2002 (XP) or higher
- Microsoft Excel should be running locally and not over a network as a distributed application. EngineRoom will not perform correctly if you are running Microsoft Excel over a network.
- EngineRoom for Excel 2007 will not function properly if any previous versions of Excel are installed, so you will need to remove all previous versions of Excel before installing EngineRoom for Excel 2007.
- Macro Security: EngineRoom contains macros. Excel macro security must be set to Medium or lower.
Display Properties Setting: Viewed best with 1024 x 768 screen size
Processor: Pentium or equivalent; 1 GHz or higher
RAM: 1 GB free space minimum
Hard Disk: 10 MB free space
Adobe Acrobat Reader (Free Reader Download from Adobe) - for tutorials
Flash 7 Player (Free Flash Download from Adobe) - for tutorials