Stat Tools

Getting Started with OpEx360 Stat Tools

OpEx360 includes a full Lean Six Sigma statistical toolkit — 90 tools covering every DMAIC phase, from basic descriptive statistics to advanced DOE and SPC. This guide walks you through everything you need to know to run your first analysis in under 5 minutes.

No installation

Runs entirely in your browser — no software to install, no licence required.

Data stays local

Your data never leaves your browser. Nothing is sent to any server.

LSS-native

Every tool is designed for DMAIC workflows, not generic statistics.

How the Tools Work

Client-side computation

All statistical calculations happen in your browser using JavaScript. There is no server processing your data — results are instant and completely private.

Paste-from-Excel data grid

Every tool has a built-in data grid. Copy a column from Excel and paste it directly — the grid parses comma, tab, or newline-separated values automatically.

Plain-language interpretation

Every result includes an interpretation panel that explains what the output means in plain English — including whether your assumptions are met and what to do next.

MBB Coach AI assistant

Click the MBB Coach button (bottom-right) on any tool page to ask questions. The AI provides guidance on methodology, interpretation, and next steps — without seeing your data.

Assumption checker

Tools that require normality or equal variance automatically check these assumptions and show a traffic-light status — green means proceed, amber means check, red means use a non-parametric alternative.

Export to PDF and CSV

Export any analysis as a branded OpEx360 PDF report or raw CSV. The PDF includes your charts, results table, and interpretation — ready for gate reviews and project reports.

Entering Your Data

1

Copy from Excel or any spreadsheet

Select a column (or multiple columns) in Excel and press Ctrl+C (Cmd+C on Mac). Then click inside the data grid in the tool and press Ctrl+V. The grid will automatically detect column separators and populate the rows.

Include the column header row — the grid will use it as the variable name.

2

Type or paste raw numbers

You can also type numbers directly, one per row, or paste a comma-separated list. The grid accepts: newline-separated, comma-separated, tab-separated, and space-separated values.

Minimum sample sizes: most tests need ≥ 5 per group; capability studies need ≥ 30; Gauge R&R needs ≥ 10 parts × 2–3 operators × 2–3 replicates.

3

Label your columns

Click the column header to rename it (e.g. 'Before', 'After', 'Machine A'). Column names appear in charts, results tables, and exported reports.

Use descriptive names — they make your exported reports self-explanatory.

4

Use the Transform panel for non-normal data

If your data is skewed or non-normal, click the Transform button in the data grid. It applies Box-Cox, log, square root, or other transformations and shows a before/after normality comparison.

Box-Cox transformation automatically finds the optimal lambda — you don't need to guess.

DMAIC Tool Map

Search all 90 tools by name, or browse by DMAIC phase below.

DefineWhat is the problem?
Sigma Level / DPMO CalculatorProcess Capability

Start by quantifying the gap between current and target performance. The Sigma Level Calculator converts your defect rate into a sigma score instantly.

MeasureHow is the process performing?
Graphical SummaryCapability SixpackGauge R&RNormality Test

Before analysing causes, verify your measurement system is trustworthy. Run a Gauge R&R — if %Study Variation > 30%, fix the measurement system first.

AnalyseWhat are the root causes?
Hypothesis WizardOne-Way ANOVARegressionBox Plot

Use the Hypothesis Wizard if you're unsure which test to use — it asks 3 questions and recommends the right test based on your data type and question.

ImproveWhat is the best solution?
DOE WizardFull Factorial DesignResponse OptimizerMonte Carlo

New to DOE? Start with the DOE Wizard — it guides you to the right design (Screening, Factorial, or RSM) based on your number of factors and run budget.

ControlHow do we sustain the gains?
I-MR ChartXbar-R ChartEWMA ChartCUSUM Chart

Choose your control chart based on subgroup size: I-MR for individual measurements, Xbar-R for subgroups of 2–8, Xbar-S for subgroups > 8.

Your First Analysis — Step by Step

Follow these 6 steps to complete your first analysis. Click each step to mark it as done.

Step 1

Collect your data

Gather at least 20–30 data points from your process. More data = more reliable results. You can use process logs, measurement records, or export from your ERP/MES system.

Step 2

Open Graphical Summary

Navigate to Measure → Graphical Summary. This single tool gives you a histogram, box plot, normality test, and descriptive statistics in one view — the fastest way to understand your data.

Step 3

Paste your data

Click the data grid and paste directly from Excel or CSV. Each column becomes a variable. Label your columns (e.g. 'Cycle Time', 'Defect Count'). The grid accepts comma-separated, tab-separated, or space-separated values.

Step 4

Run the analysis

Click Analyse. The tool instantly computes mean, median, standard deviation, skewness, kurtosis, and runs a Shapiro-Wilk normality test. The histogram shows your distribution shape with a normal curve overlay.

Step 5

Read the interpretation panel

Every tool includes a plain-language interpretation at the bottom. It tells you what the results mean, whether your assumptions are met, and what to do next — no statistics degree required.

Step 6

Export your results

Click Export CSV to download the raw results, or Export PDF to generate a branded OpEx360 report with your analysis, charts, and interpretation — ready to include in your project charter or gate review.

Green Belt vs Black Belt Tools

Every tool is tagged with a belt level. Here is what that means in practice.

GBGreen Belt

GB tools are designed for practitioners running focused improvement projects. They require no advanced statistical background — the tools guide you through assumptions, interpret results in plain English, and suggest next steps.

Example tools:

Graphical SummaryNormality Test1-Sample t-TestIndependent t-TestOne-Way ANOVAChi-Square TestI-MR ChartProcess Capability

Start with the Hypothesis Wizard — it selects the right GB test for your question automatically.

BBBlack Belt

BB tools are for practitioners leading complex, multi-factor projects. They assume familiarity with statistical concepts and are used for advanced MSA, regression modelling, DOE, and multivariate analysis.

Example tools:

Gauge R&R AIAGTwo-Way ANOVABinary Logistic RegressionFull Factorial DesignCentral Composite DesignEWMA ChartMonte Carlo Simulation

Start with the DOE Wizard to choose the right experimental design for your project.

Next Steps

Browse all 90 tools

Use the sidebar to explore the full toolkit by DMAIC phase. Filter by belt level (GB/BB) or search by name.

Run your first DOE

Not sure which experimental design to use? The DOE Wizard asks 4 questions and recommends the right design for your project.

Set up a control chart

Sustain your gains with SPC. The I-MR Chart is the most versatile starting point — it works for any individual measurement data.

Need help choosing the right test?

Use the Hypothesis Wizard — it asks three questions (data type, number of groups, paired or independent) and recommends the correct statistical test with a direct link to run it. Open Hypothesis Wizard →

MBB Coach

Hi! I'm here to help you choose the right tool and interpret your results.

Master Black Belt Coach — Getting Started
Guidance only · No data shared

Guidance only — your analysis data stays in your browser. Nothing is sent to AI.