Summary

CORREL returns the correlation coefficient for two sets of numbers. The result shows how strongly the two sets move together in a linear way, and Excel gives that result on a scale from -1 to 1.

A value near 1 means both sets tend to rise together. A value near -1 means one tends to rise while the other falls. A value near 0 means there is little or no clear linear relationship. That helps a lot with interpretation, but it still does not prove that one variable causes the other.

Syntax

=CORREL(array1, array2)

Each argument is a range or array of numbers. The two sets need to represent matching observations, so the first value in one list should line up with the first value in the other list, the second with the second, and so on.

Arguments

• array1 - [required] The first set of numeric values.
• array2 - [required] The second set of numeric values. It should have the same number of data points as the first set.

CORREL vs Other Functions

CORREL tells you how strong the relationship is. It does not tell you the size of the change, and it does not tell you whether the relationship is causal.

Using the CORREL Function

This function is useful when you have two numeric columns and want to see whether they move together. Common examples are ad spend and sales, study time and scores, temperature and demand, or training hours and error counts. A strong positive result says the two lists tend to move in the same direction. A strong negative result says they move in opposite directions.

Microsoft notes a few rules that matter in real work. Text, logical values, and blank cells inside references are ignored, while zero values are included. If the two arrays do not contain the same number of data points, Excel returns #N/A. If one list is empty, or if either list has a standard deviation of zero, Excel returns #DIV/0!.

One more practical note helps keep the result honest. A high correlation can point to a strong pattern, but it still does not prove that one variable is causing the other. It is a clue, not final proof.

Example 1 - Check a positive relationship

If both lists rise together, the result moves closer to 1.

=CORREL(B1:B3,D1:D3) // Returns 1 when the two lists have a perfect positive linear relationship.

Example 2 - Check a negative relationship

When one list rises while the other falls, the result moves closer to -1.

=CORREL(B1:B3,D1:D3) // A strong negative result means the lists move in opposite directions.

Example 3 - Spot a weak pattern

A result near 0 means there is no strong linear pattern between the two lists.

=CORREL(B1:B3,D1:D3) // A value near 0 suggests a weak or unclear linear relationship.

Example 4 - Review a marketing relationship

This is a simple way to test whether higher spending tends to line up with more users or sales.

=CORREL(B1:B3,D1:D3) // Returns the correlation between ad spend and users.

Conclusion Recap

• Main job: CORREL measures the strength and direction of a linear relationship.
• Result range: The answer is always between -1 and 1.
• What the signs mean: Positive means the lists tend to move together, negative means they tend to move in opposite directions.
• Data rule: The two arrays must contain matching data points.
• Important limit: Correlation helps reveal a pattern, but it does not prove causation.