Summary: This correlation coefficient calculator computes Pearson, Spearman and p-value with live steps, formulas and a chart. It accepts labeled numeric inputs, works offline through file:// and includes source-backed explanations for students, analysts and researchers.
Correlation coefficient calculator for Pearson r, Spearman rho, t test, p-value, strength interpretation and scatter plot. The calculator works offline, updates instantly and includes a worked example, plain-text formula, MathML, references and structured data.
Default values are loaded. Click any field and edit it; results and chart update automatically.
| Input or setting | Result or interpretation | Use this when |
|---|---|---|
| absolute r below .3 | weak association | association strength |
| absolute r .3 to .5 | moderate association | association strength |
| absolute r above .7 | very strong association | association strength |
r = sum((x_i-mean_x)(y_i-mean_y)) / sqrt(sum((x_i-mean_x)^2) * sum((y_i-mean_y)^2))Pearson r measures linear association from -1 to 1. Spearman rho applies Pearson correlation to ranks.
x=[1,2,3,4,5], y=[2,4,5,4,5]
r about 0.775; t about 2.121; p about 0.124
This page uses the shared statistics core for distribution functions, quantiles and exact integer counting where needed. The formula is shown in plain text so screen readers and search engines can parse it reliably.
Use Load example in the calculator to reproduce this reference result.
{
"tool": "Correlation Coefficient Calculator",
"input": "x=[1,2,3,4,5], y=[2,4,5,4,5]",
"output": "r about 0.775; t about 2.121; p about 0.124",
"formula": "r = sum((x_i-mean_x)(y_i-mean_y)) / sqrt(sum((x_i-mean_x)^2) * sum((y_i-mean_y)^2))"
}| Calculator | Example input | Expected output |
|---|---|---|
| Correlation Coefficient Calculator | x=[1,2,3,4,5], y=[2,4,5,4,5] | r about 0.775; t about 2.121; p about 0.124 |
What does p = 0.03 mean? If the null hypothesis and model assumptions were true, a result at least this extreme would occur about 3% of the time. The American Statistical Association cautions that a p-value alone does not measure effect size, practical importance or the probability that Hâ‚€ is true.3
For most classroom and professional reports, pair the calculator result with the question you are answering. A mean or median summarizes location, but spread explains consistency. A confidence interval estimates plausible values, while a hypothesis test evaluates compatibility with a null model. Regression and correlation describe association, so they should be reported with a chart and residual or outlier review. When a result is statistically significant, still ask whether the effect is large enough to matter in the real setting.
| Statistic | Small | Medium | Large | Use |
|---|---|---|---|---|
| Cohen's d | 0.2 | 0.5 | 0.8 | t-test effect size |
| Cramér's V | 0.1 | 0.3 | 0.5 | chi-square association |
| |r| | 0.10 | 0.30 | 0.50 | correlation strength |
| R² | 0.01 | 0.09 | 0.25 | variance explained |
The conceptual formula is r = Σ(xi − x̄)(yi − ȳ) / √[Σ(xi − x̄)² × Σ(yi − ȳ)²]. In words: you measure how x and y vary together (the numerator), then standardise by how much each varies on its own (the denominator). The result lands between −1 and +1. You need paired data points — each x must have a matching y from the same observation. Manually it's tedious for big datasets; calculators and Excel's CORREL function handle it instantly. Just make sure your x and y lists have equal length.
Pearson measures the strength of a linear relationship between two continuous variables, and it assumes roughly normal distributions. Spearman ranks the data first and then computes Pearson on those ranks, which means it captures any monotonic relationship — even curved ones — as long as y consistently increases or decreases with x. Use Pearson for clean linear data; use Spearman for ordinal data, when outliers are present, or when the relationship looks more like a curve than a straight line. They often give similar values but disagree when the link isn't strictly linear.
A negative r means the two variables move in opposite directions — as x rises, y tends to fall, and vice versa. The closer r is to −1, the stronger and more consistent that inverse relationship. For example, hours spent watching TV and exam scores might show r ≈ −0.6, suggesting more screen time pairs with lower marks. Remember: correlation describes association, not causation. A strong negative r doesn't prove TV causes bad grades — there could be a third factor (study time, sleep) driving both.
Convert r to a t statistic using t = r√(n − 2) / √(1 − r²), with degrees of freedom df = n − 2. Then look up the two-tailed p-value from the t distribution. Example: r = 0.5 with n = 30 gives t = 0.5 × √28 / √0.75 ≈ 3.05, df = 28. That t-value corresponds to p ≈ 0.005, which is statistically significant. Most software (R's cor.test, Python's scipy.stats.pearsonr) returns this p-value automatically. Larger samples make even small r values significant, so context matters.
R² is just r squared, but its meaning is far more useful. It tells you the proportion of variance in y that's explained by its linear relationship with x. So if r = 0.8, then R² = 0.64, meaning about 64% of the variation in y is accounted for by x. The remaining 36% is unexplained — due to other factors or noise. Always between 0 and 1, R² makes interpretation more concrete than r alone. Just don't confuse high R² with a good model: a flawed regression can still have high R².
Make sure your two datasets are paired — each x value matches a specific y value from the same observation, person, or time point. Both lists must be the same length. Drop any row where one value is missing. Then plug them into the Pearson formula, or use a calculator that accepts two columns. In Excel: =CORREL(A1:A20, B1:B20). The order of the lists doesn't change r — correlation is symmetric. If your data are ranks or you suspect outliers, run Spearman as well and compare the two values.
Reach for Spearman in three situations: when your data are ordinal (rankings, satisfaction scores), when the relationship between x and y is monotonic but not linear, or when outliers are skewing your Pearson result. Because Spearman works on ranks, extreme values lose their disproportionate pull. It also handles non-normal distributions gracefully. Example: relating exam rank with study-hour rank for a class of 25. If you're not sure which to use, run both — close values mean the relationship is fairly linear, big differences hint at non-linearity or outliers.
Look at the p-value associated with your r. If p is below your chosen alpha (typically 0.05), the correlation is statistically significant — meaning the observed link is unlikely to be due to random sampling alone. Sample size plays a huge role: with n = 1000, even r = 0.07 can be significant; with n = 10, you need r ≈ 0.63 or higher. Also check the confidence interval for r — if it crosses zero, the correlation isn't significant. And remember: significant doesn't necessarily mean strong or practically important.