# Correlation

> How closely two things rise and fall together. It runs from -1 to 1.

**Field:** General Knowledge  
**Category:** Math & Statistics  
**Also known as:** Correlation Coefficient, Pearson Correlation

## Think of it like

It is like two kids on swings who go up and down at the same time.

## Definition

Correlation measures how closely two things move together. It is a number from -1 to 1. Near 1, when one goes up the other goes up too. Near -1, when one goes up the other goes down. Near 0, there is no straight-line link at all. A strong correlation does not show that one thing causes the other.

## Example

For 30 days, Lucy's café notes the heat and her cold drink sales. The correlation is 0.82, so hot days and high sales go together.

## Example code

```excel
=CORREL(B2:B31, C2:C31)
0.82
```

A result of 0.82 means the two columns rise together strongly.

## Why it matters

Correlation is often the first clue that two things are linked. It shows where to look next.

## Common mistake

Reading a correlation as a cause. Ice cream sales and sunburn rise together, but ice cream does not burn skin.

## Three principles

- **From -1 to 1.** The sign shows the direction.
- **Strength, not cause.** It never proves one causes the other.
- **Straight lines only.** A curved link can score near 0.

## Related terms

- [Causation](https://learn.benibix.com/term/general/causation)
- [Confounding Variable](https://learn.benibix.com/term/general/confounding-variable)
- [Regression Analysis](https://learn.benibix.com/term/general/regression-analysis)
- [Scatter Plot](https://learn.benibix.com/term/design/scatter-plot)
- [Observational Study](https://learn.benibix.com/term/general/observational-study)

## Told apart from

- [Correlation vs Causation](https://learn.benibix.com/compare/correlation-vs-causation): People see two things rise together and think one causes the other, and that does not follow. Correlation only says they move together. Causation says that changing one changes the other. A hidden third thing can drive both, so you need a fair test with random groups to show a cause.

## Taught in

- [Correlation vs Causation](https://learn.benibix.com/learn/general-math/correlation-vs-causation): Statistics, 8/10

![Three scatter plots side by side. In the first, the dots climb from bottom left to top right, labelled near 1. In the second, the dots are a shapeless cloud, labelled near 0. In the third, the dots fall from top left to bottom right, labelled near -1.](https://learn.benibix.com/diagrams/gen-correlation.svg)

---

Source: https://learn.benibix.com/term/general/correlation
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
