DATA
One X Y pair per line
Paste two columns from Excel, SPSS, or Google Sheets: X then Y on each line, separated by a space, comma, or tab. A header row is skipped automatically.
CORRELATION COEFFICIENT CALCULATOR
DATA
Paste two columns from Excel, SPSS, or Google Sheets: X then Y on each line, separated by a space, comma, or tab. A header row is skipped automatically.
METHOD
r = Σ(x − x̄)(y − ȳ) ÷ √[Σ(x − x̄)² · Σ(y − ȳ)²], t = r·√(n − 2) ÷ √(1 − r²), df = n − 2The p value comes from the t distribution with n − 2 degrees of freedom. The 95% confidence interval uses Fisher's z transformation: z = atanh(r), SE = 1 ÷ √(n − 3), then back-transformed with tanh.
rₛ = Pearson r computed on the ranks of X and Y (ties get average ranks)Spearman's p value uses the same t approximation as Pearson, which is what SPSS reports. Kendall's tau-b counts concordant and discordant pairs, corrects for ties in both variables, and is tested with a normal (z) approximation.
“A Pearson correlation showed a strong positive relationship between study hours and exam score, r(10) = .97, p < .001, 95% CI [.89, .99].” Report the coefficient without a leading zero, the degrees of freedom (N − 2) in brackets, the exact p value, and ideally the confidence interval. For Spearman write rₛ(10) = .97; for Kendall write τb = .89.
ABOUT THIS TOOL
Measure the strength and direction of a relationship between two variables, with the right coefficient for your data, a confidence interval, a scatter plot with the regression line, and a ready APA sentence.
KEY FUNCTIONS
LEARN THE METHOD
Pick the right statistical test for your thesis in four questions, then see the assumptions to check and a ready-to-edit APA-style sentence for your results chapter.
Get the effect size for any common test in seconds, from raw summary statistics or from a reported t, F, or z value, with benchmarks and APA wording.
Check the normality assumption before a t-test or ANOVA, see the histogram and Q-Q plot, and get advice on what to do if normality is violated.