FreeStatisticalTools.com
Correlation and regression

Correlation Coefficient Calculator

Measure the strength and direction of relationships between variables. Choose Pearson for linear relationships, Spearman or Kendall for ranks and monotonic trends.

Free · No sign-upReplaces SPSS · ExcelWorks with your data
Updated · By Bibin Xavier

Data 90 × 12

Paste from Excel, or drop a CSV, TSV or Excel file here.
Example data 90 rows, 12 variables. Data stays in this browser tab.
IDtext · 90 levelsGrouptext · 3 levelsGendertext · 2 levelsAgenumericHours_StudynumericAnxietynumericMotivationnumericPre_ScorenumericPost_ScorenumericExam_ScorenumericPassednumeric · codedSatisfactionnumeric · coded
S001ControlMale2311.2294.660626712
S002WorkshopFemale233.9283.554705402
S003OnlineFemale1810.132455576603
S004ControlMale2613.6413.552555903
S005WorkshopFemale229.7273.656636504
S006OnlineFemale207.9323.865826502
S007ControlFemale206.328372836103
S008WorkshopMale228293.164726213

Variables and options

Variables 4 selected · min 2
Results update automatically when you change an option.

Results

90 rows · example data
Table 1

Correlation matrix (r)

Variable1234
1. Exam_Score—
2. Hours_Study.36***—
3. Motivation.40***.65***—
4. Anxiety-.35***.20.04—

Note. * p < .05. ** p < .01. *** p < .001. Pairwise deletion of missing values.

Table 2

Pairwise details

Pairnr95% CItpStrength
Exam_Score – Hours_Study90.362[.167, .529]3.64< .001moderate
Exam_Score – Motivation90.398[.209, .559]4.07< .001moderate
Exam_Score – Anxiety90-.348[-.518, -.152]-3.48< .001moderate
Hours_Study – Motivation90.650[.511, .755]8.02< .001strong
Hours_Study – Anxiety90.201[-.007, .391]1.92.058weak
Motivation – Anxiety90.041[-.168, .246]0.38.704negligible

Note. Confidence intervals use the Fisher z transform.

Hours_Study by Exam_Score

Interpretation

Exam_Score and Hours_Study show a moderate positive correlation (r = .36), which is statistically significant. Higher values of one tend to go with higher values of the other. Correlation does not establish cause.

Exam_Score and Hours_Study were significantly correlated, r(88) = .36, p < .001.

How to cite this tool

Using these results in a thesis, journal article, report or class assignment? Please cite this free tool so others can find it. It keeps the site free.

APA 7

Xavier, B. (2026). Correlation Coefficient Calculator [Web application]. FreeStatisticalTools.com. https://freestatisticaltools.com/correlation-calculator/

BibTeX

@software{xavier_correlation_2026,
  author = {Xavier, Bibin},
  title = {Correlation Coefficient Calculator},
  publisher = {FreeStatisticalTools.com},
  year = {2026},
  url = {https://freestatisticaltools.com/correlation-calculator/},
  note = {Web application}
}

Suggested sentence for your methods section: “The analysis was carried out with the free Correlation Coefficient Calculator tool on FreeStatisticalTools.com (Xavier, 2026).”

What is a correlation coefficient?

A correlation coefficient measures the strength and direction of the relationship between two variables. This calculator builds a full correlation matrix with significance stars and gives the confidence interval and test for every pair.

When to use a correlation coefficient

Use Pearson’s r for two continuous, roughly normal variables with a linear relationship. Use Spearman’s ρ or Kendall’s τ for ordinal data, outliers or curved but monotonic trends. A point-biserial correlation is Pearson’s r with one variable coded 0/1.

Assumptions

  • Pearson: linearity, no extreme outliers, approximate bivariate normality.
  • Spearman and Kendall: a monotonic relationship.

How to use this tool

  1. Enter your data. Paste columns from Excel, Google Sheets or SPSS with variable names in the first row, or upload a CSV or Excel file. The example data shows the expected layout.
  2. Choose the variables. Select the variables.
  3. Set the options. Fill in coefficient.
  4. Read the results. Results update automatically. Read the plain-English interpretation, then use Copy table to paste APA-style tables into Word and Copy for the results sentence.

How to report a correlation coefficient in APA style

“Study hours were positively correlated with exam scores, r(88) = .47, p < .001.”

Frequently asked questions

Pearson or Spearman correlation?

Use Pearson’s r for continuous variables with a linear relationship and no extreme outliers. Use Spearman’s ρ for ordinal data, outliers or monotonic but curved relationships.

How do I interpret r?

By Cohen’s guidelines, |r| = .10 is weak, .30 moderate and .50 strong. The sign shows the direction of the relationship.

How do I calculate a point-biserial correlation?

Code the binary variable as 0 and 1 and run Pearson’s r; the result is the point-biserial correlation.

Related tools

Browse all categories