Correlation (Pearson / Spearman / Kendall)
Correlation (Pearson / Spearman / Kendall) is one of the statistical analyses applied automatically in MerQur. This page illustrates — on a Social, Humanities & Admin Sciences sample dataset — how the analysis is run, what the MerQur output looks like, and how the result is reported in APA 7 format.
🎯 What is it for?
Correlation (Pearson / Spearman / Kendall) automatically performs all required assumption checks (normality, homogeneity of variance, etc.) for the relevant data type in the background and presents the results with a clear table + chart. Automatic interpretation in the APA 7 standard, effect sizes such as Cohen’s d/η²/R², and 95% confidence intervals are reported.
📌 When is it used?
- Statistical analysis of measurements in the Social, Humanities & Admin Sciences domain
- To produce APA 7-compatible result tables for academic publications
- Hypothesis testing and decision-making processes
- Undergraduate / master’s / PhD theses after the appropriate method has been selected
📐 Assumptions
- Appropriate scale — Variables must be at the measurement level required by the analysis (nominal/ordinal/interval/ratio)
- Independent observations — Observations must come from individuals independent of one another
- Sufficient sample size — The minimum n requirement for the analysis must be met
- Outlier check — Outliers must be detected and evaluated
If assumptions are violated, MerQur automatically suggests a non-parametric or robust alternative.
🛠 How to do it in MerQur
Load the data. Select the sample file from File → Open. MerQur auto-detects column types.
Select the analysis. From the left side select Correlation (Pearson / Spearman / Kendall).
Panel assignments (form fields in the program):
- Columns:
[ogrenci_id, motivasyon, calisma_saat, +3 daha] - method:
pearson
Optional settings. Effect size ✓ · 95% confidence interval ✓ · Assumption checks (automatic).
▶ Run — click the button. Results are produced automatically as a table + chart.
📄 Export to Word. APA 7-formatted report with italic statistical symbols.
📊 Sample Dataset — Social, Humanities & Administrative Sciences
ℹ Note: The scenario, MerQur output and interpretation below were produced by actually running the real example dataset in MerQur. Numeric results on your own data will differ; the goal is to show how the analysis is set up and interpreted end-to-end.
🎬 Example File
This analysis is demonstrated on the following example dataset for Social, Humanities & Administrative Sciences:
Sosyal_Beseri/33_correlation_5degisken.xlsx
🎬 Scenario
We examine all pairwise correlations among five continuous variables. For relationship direction and strength, the correlation matrix is appropriate.
⚙️ Variable Selection
- Variables: motivation
- Variables: study_hour
- Variables: GPA
- Variables: anxiety
- Variables: satisfaction
- >> ADVANCED PARAMETERS (optional in the form — what they do):
- p-values are now produced for ALL methods (Pearson/Spearman/Kendall), not only Pearson.
- Hypothesis direction (two-sided / right / left).
- Multiple-comparison p-adjustment across pairs: Bonferroni / Holm / FDR (Benjamini-Hochberg).
- Confidence interval for r via Fisher z (Pearson/Spearman) or Kendall SE.
Data Preview (First 5 Rows)
| student_id | motivation | study_hour | GPA | anxiety | satisfaction |
|---|---|---|---|---|---|
| 1.0 | 4.19 | 25.9 | 3.26 | 1.8 | 4.25 |
| 2.0 | 3.81 | 15.5 | 3.25 | 1.49 | 5.0 |
| 3.0 | 4.06 | 24.2 | 3.29 | 1.32 | 4.77 |
| 4.0 | 4.03 | 30.7 | 3.45 | 1.24 | 4.82 |
| 5.0 | 3.78 | 23.3 | 3.03 | 2.04 | 3.22 |
n = 180 · Columns: student_id, motivation, study_hour, GPA, anxiety, satisfaction
📈 MerQur Output
💬 Interpretation
We computed all pairwise Pearson correlations among five continuous variables (motivation, study hours, GPA, anxiety, satisfaction): none exceeded the 0.75 strong threshold — the variables move largely independently. This too is a valuable finding: most measures carry different information, none substitutes for another. The correlation matrix summarizes the direction and strength of relationships at a glance; in education research it is the first step in spotting overlap among indicators (multicollinearity risk) and seeing which variables truly give separate signals. >> ADVANCED PARAMETERS (optional in the form — what they do): – p-values are now produced for ALL methods (Pearson/Spearman/Kendall), not only Pearson. – Hypothesis direction (two-sided / right / left). – Multiple-comparison p-adjustment across pairs: Bonferroni / Holm / FDR (Benjamini-Hochberg). – Confidence interval for r via Fisher z (Pearson/Spearman) or Kendall SE.
⚠ Common Mistakes
- Misidentifying the data type (e.g., loading a categorical variable as numeric)
- Skipping assumption checks and going straight to the p-value
- Failing to report effect size — APA 7 requires both p and effect size
- Failing to apply a Type I error correction (Bonferroni/Tukey) in multiple comparisons
- Not switching to a non-parametric alternative when n is insufficient
📹 Video Walkthrough
Watch the video below for an end-to-end walkthrough of this analysis on a Social, Humanities & Admin Sciences file.
▶ Correlation (Pearson / Spearman / Kendall) — video walkthrough
A complete end-to-end walkthrough of this analysis in MerQur, narrated on screen. Narration is in Turkish.
🎓 Education Sciences · 🧪 Natural Sciences & Mathematics · 🏛 Architecture, Planning & Design · ⚙ Engineering · 🏥 Health Sciences · 🏃 Sport Sciences · 🌾 Agriculture, Forestry & Aquatic
📚 If You Used This Analysis, Cite MerQur
If you performed this analysis using MerQur in a scientific study, please use the citation below as part of your academic citation obligations (APA 7):
Örücü, Ö. K. (2026). MerQur: Integrated Academic Data Analysis & Reporting Platform [Computer software] (Version 1.0.0). https://doi.org/10.53463/merqur.2026001
For BibTeX, RIS, EndNote and the English citation form: all citation formats →
- American Psychological Association. (2020). Publication manual of the American Psychological Association (7th ed.).
- Field, A. (2018). Discovering statistics using IBM SPSS Statistics (5th ed.). Sage.
- Cohen, J. (1988). Statistical power analysis for the behavioral sciences (2nd ed.). Lawrence Erlbaum.