CORREL

Formulas / CORREL
To calculate the Pearson correlation coefficient between two sets of data. The Pearson correlation coefficient measures the linear relationship between two variables, indicating the strength and direction of the association.
CORREL(array1, array2)
  • array1 - a range of cell values
  • array2 - a range of cell values

Examples

  • =CORREL(B4:B22,C4:C22)

    In order to calculate the correlation coefficient between two sets of numbers, the function above may be used. This will return a correlation coefficient of 0.6642909.

  • =CORREL(F3:F23,G3:G23)

    The CORREL function can be used to determine the relationship between two sets of data. For example, this function may be used to determine the relationship between two columns of data. This will return a correlation coefficient of 0.89011522, indicating a strong positive correlation between the two sets of data.

  • =CORREL(A4:A20, B4:B20)

    In this example, to determine the strength of the relationship between two columns of data, the function will return a correlation coefficient, which can be used to determine the strength of the relationship between the two sets of data.

Summary

The CORREL function calculates the correlation coefficient between two cell ranges to determine the relationship between two properties. It is used to measure if changes in one property will result in changes in the other.

  • The CORREL function calculates the correlation coefficient between two cell ranges, which measures the relationship between two properties. It will throw a #DIV/0! error if the standard deviation of the cell ranges is zero.
  • The correlation coefficient is used to determine if two properties are related - increasing or decreasing the values in one property should lead to increasing or decreasing the values in the other property.
  • The correlation coefficient is not useful if the two cell ranges have different numbers of data points.

Frequently Asked Questions

What is the CORREL function?
The CORREL function is a statistical function in Sourcetable that calculates the correlation coefficient between two variables. The correlation coefficient measures the strength of the relationship between two variables.
When was the CORREL function introduced?
The CORREL function was introduced in Excel 2007 and is available in all later versions of Excel.
Is the CORREL function the same as the PEARSON function?
Yes, the CORREL function is the same as the PEARSON function, except that it returns a correlation coefficient.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.