CORREL
TheCORREL
formula returns the correlation coefficient between two sets of data. This coefficient represents the strength of the linear relationship between the two sets of data, with values ranging from 1 (perfect negative correlation) to 1 (perfect positive correlation).
 How to use
CORREL
formula?  Examples of using
CORREL
formula CORREL
formula not working? Similar formulas to
CORREL
Usage
Use the CORREL
formula with the syntax shown below, it has 2 required parameters:
 data_y (required):
An array or range containing the yvalues of the data set.  data_x (required):
An array or range containing the xvalues of the data set.
Examples
Here are a few example use cases that explain how to use theCORREL
formula in Google Sheets.
Finding the correlation between two sets of data
By using the CORREL
formula, you can easily calculate the correlation coefficient between two sets of data. This helps you determine if there is a strong or weak relationship between the two sets of data.
Evaluating the strength of a linear relationship
The CORREL
formula is frequently used in statistical analysis to evaluate the strength of a linear relationship between two sets of data. This helps determine if there is a significant correlation between the two sets of data.
Determining the direction of the relationship between two sets of data
The sign of the correlation coefficient returned by the CORREL
formula indicates the direction of the relationship between the two sets of data. A positive value indicates a positive relationship, while a negative value indicates a negative relationship.
Common Mistakes
CORREL
not working? Here are some common mistakes people make when using the CORREL
Google Sheets Formula:
Incorrect data range
One common mistake is selecting the wrong data range for either data_y or data_x. Make sure the ranges selected only include the data you want to analyze.
Not entering data ranges
Another mistake is not properly entering the data ranges for data_y and data_x. Make sure to use the correct syntax and separate the ranges with a comma.
Data ranges with different sizes
A mistake that can occur is when the data ranges for data_y and data_x have different sizes. Make sure the ranges are equal in size and have the same number of rows or columns.
Related Formulas
The following functions are similar to CORREL
or are often used with it in a formula:

PEARSON
The
PEARSON
function calculates the correlation coefficient between two sets of data points,data_y
anddata_x
. This coefficient indicates how closely related the two sets of data are. A high correlation coefficient indicates a strong positive correlation, while a low coefficient indicates a weak or negative correlation. This function is commonly used in statistical analysis and data visualization. 
SLOPE
The
SLOPE
formula calculates the slope of the linear regression line that best fits the input data. It is commonly used in statistics to analyze trends and predict future values based on past performance. 
INTERCEPT
The
INTERCEPT
function calculates the point where the line of best fit for a set of data intercepts the yaxis. This function is commonly used in regression analysis to find the constant b in the equation y=mx+b where m is the slope of the regression line.
Learn More
You can learn more about the CORREL
Google Sheets function on Google Support.