Paste two lists of paired values to get Pearson's correlation coefficient r and r² — the strength and direction of their linear relationship — with a live scatter plot, the sums, and the working shown.
A very strong positive linear relationship — as one variable changes, the other tends to rise together.
r² = 0.992 means about 99% of the variation in Y is explained by its linear relationship with X.
Pearson’s correlation coefficient, written r, is a single number from −1 to +1 that summarizes how tightly two variables follow a straight line together. The sign gives the direction; the magnitude gives the strength.
The computing formula needs only five sums and the count of pairs — no means or deviations required.
Line up each x with its matching y. Count the pairs to get n. Both lists must be the same length.
Add up the X values, the Y values, each product xy, and the squares x² and y².
The numerator captures how X and Y vary together; the denominator scales it by how much each varies on its own.
Divide the numerator by the denominator. The result is r, always between −1 and +1.
Textbooks show two equivalent forms. The computing form (top) is easiest by hand; the definitional form (bottom) shows what r really is — covariance divided by the product of the standard deviations.
The same procedure produces a positive, negative, or near-zero coefficient depending on how the data move together. Each tab computes r from real numbers.
A very strong positive linear relationship — as one variable changes, the other tends to rise together.
There is no universal cutoff, but these widely taught bands turn an abstract r into a verdict. They apply to the absolute value, so they hold for negative correlations too.
Drag the slider to any value of r to read off its strength and direction instantly.
Thresholds are a common rule of thumb; acceptable strength depends on the field — a 0.4 is notable in social science but weak in physics.
One number that screens for relationships across science, finance, and machine learning.
r is powerful but easy to misread. These are the traps that catch people most often.
The Pearson r on this page is the most common coefficient, but it has close relatives for different situations.

The mean is the average of a set of numbers: add them all up and divide by how many there are. This guide shows the formula, a worked example, and how the mean differs from the median and mode.

Use STDEV.S or STDEV.P in Excel, choose the right one for your data, and check the result against a worked example.

A friendly, beginner-focused guide to understanding and calculating range in statistics. Learn what range means, how to compute it, real-life applications, and common mistakes to avoid.