Home / Lean Six Sigma / ANOVA, regression & simulation

Correlation and scatterplot

Find out which process variables move together, how strongly and how surely, before building a regression model or changing a machine setting.

Pre-sizing and estimating tool: results do not replace design, calculations or reports signed by a licensed professional, nor verification against the applicable codes and standards.

CheckRevised 11/03/2026
Data
See what was read
Examples:

Text columns (shift, line, supplier) can color the points by group. Keep the rows in collection order when time is involved.

Pair for the scatterplot

Your inputs stay only on this browser and are not sent anywhere. Untick to delete them.

—Correlation
—

Scatterplot with fitted line, ellipse and LOWESS

Each point is a table row. Direct labels show the slope and the most influential point; tap a point to exclude it from this chart only and watch r and R² change.

Tap the chart to see the values.

Strength of the relationship in words

A −1 to +1 ruler with the usual bands (Evans, 1996), r and ρ with their confidence intervals, and R² as 100 squares.

Tap the chart to see the values.

Matrix plot

Below the diagonal, scatterplots with a line; on the diagonal, histograms; above, the coefficient and p-value in color.

Tap the chart to see the values.

Heat map ordered by affinity

Variables clustered by correlation. Bold: p-value below 0.05.

Tap the chart to see the values.

Strength of every pair

Coefficient and confidence interval for each pair, strongest to weakest.

Tap the chart to see the values.

Pairwise correlations

Pearson with Fisher z CI; Spearman with Bonett–Wright CI; p-value from the t test with N − 2 degrees of freedom.

Correlation matrix

Pair correlation by group

The same pair computed separately within each group of the chosen column.

Next step

Take this page’s results to another calculator with the fields already filled in.

The calculation report gathers this page's inputs, results, equations, assumptions and references, with fields for project, engineer and revision. The full report also includes the charts and interpretations, in color. In the print dialog, choose Save as PDF.

Method, assumptions and references

Equations used

r = Σ(x − x̄)(y − ȳ) ÷ √[Σ(x − x̄)² · Σ(y − ȳ)²]; t = r√(N − 2) ÷ √(1 − r²), two-sided p-value with N − 2 DF
Pearson CI: tanh(atanh r ± z₁₋α/₂ ÷ √(N − 3)) (Fisher)
Spearman ρ = r of the ranks (ties averaged); CI: tanh(atanh ρ ± z₁₋α/₂ · √[(1 + ρ²/2) ÷ (N − 3)]) (Bonett and Wright)
N to detect r with power 1 − β: [(z₁₋α/₂ + z₁₋β) ÷ atanh|r|]² + 3
Ellipse: (x − μ)ᵀ Σ⁻¹ (x − μ) = −2 ln(1 − conf); influential point: |r − r₍₋ᵢ₎| ≥ 0.02 and Cook’s D > 4/N

Assumptions and limits

  • Pearson measures only linear association; its p-value assumes independent pairs and roughly normal data. Spearman requires only a monotonic relationship.
  • Correlation does not prove causation. Missing values are dropped pairwise (each pair uses the rows complete for that pair).
  • Excluding points by tapping is a visual test: it does not change the tables or the main result.

Standards and technical documents

  • Montgomery, D. C.; Runger, G. C. Applied Statistics and Probability for Engineers, 7th ed. Wiley, 2018 (cap. 11)
  • Bonett, D. G.; Wright, T. A. Sample size requirements for estimating Pearson, Kendall and Spearman correlations. Psychometrika 65(1), 2000, p. 23–28
  • Fisher, R. A. On the probable error of a coefficient of correlation deduced from a small sample. Metron 1, 1921, p. 3–32
  • Cleveland, W. S. Robust locally weighted regression and smoothing scatterplots. JASA 74(368), 1979, p. 829–836
  • Evans, J. D. Straightforward Statistics for the Behavioral Sciences. Brooks/Cole, 1996
  • Brownlee, K. A. Statistical Theory and Methodology in Science and Engineering, 2nd ed. Wiley, 1965 (dados de stack loss)
  • ISO 3534-1:2006: Statistics — Vocabulary and symbols — Part 1

U.S. regulations

  • ISO 9001:2015, clause 9.1.3: analysis and evaluation
  • ISO/TR 10017:2003: Guidance on statistical techniques for ISO 9001:2000
  • ASTM E2586: Standard Practice for Calculating and Using Basic Statistics

Frequently asked questions

What does a correlation coefficient of 0.8 mean?

That the two variables have a strong linear relationship in the same direction: when one rises, the other tends to rise. The R² of 0.64 says 64% of one’s variation moves with the other. Check the confidence interval: with 10 pairs, r = 0.8 may be anything from 0.34 to 0.95.

When should I use Pearson and when Spearman?

Pearson measures straight-line association and is the default for roughly normal continuous measurements. Spearman uses the order of the values: it suits curved relationships that always rise or fall, ratings and scores, and is barely affected by extreme values. If they differ by more than 0.1, look at the chart.

Does a high correlation prove that one variable causes the other?

No. Both may depend on a third factor, such as weather, shift or raw material. Correlation shows where to investigate; to measure each factor’s effect, use regression with all of them or a designed experiment.

How much data do I need to trust the correlation?

It depends on the size of r. Confirming r = 0.5 with 95% confidence and 80% power takes about 30 pairs; r = 0.3 takes about 85. The page computes that number for your r in the report card.

What is the point that pulls the line?

The observation that, on its own, changes r the most when removed. Tap it in the chart to see r and R² without it. If it is a special event, such as a cleaning, a start-up or a typo, investigate before excluding it from the data.

How do I paste the data from Excel?

Select the columns with the names in the first row, copy and paste into the table field. Text columns, such as shift or supplier, become groups and can color the points. Rows with an empty cell are left out only of the pair where the value is missing.

Are the results the same as in statistical software?

Yes. r, rho, the p-values and the intervals follow the published formulas (Fisher for Pearson and Bonett and Wright for Spearman) and were checked against published examples and SciPy to the third decimal place.