Returns the Pearson product-moment correlation coefficient of two data sets.
תחביר
PEARSON(array1, array2)ארגומנטים
array1חובה
An array or range of independent variable values.
array2חובה
An array or range of dependent variable values.
The PEARSON function measures the linear relationship between two variables. It returns a value between -1 and 1, where 1 indicates a perfect positive correlation, -1 indicates a perfect negative correlation, and 0 indicates no linear correlation.
=PEARSON({1,2,3}, {4,5,6})→1The two sets have a perfect positive linear relationship.
Prepare your data
Ensure you have two columns or rows of numeric data with the same number of observations.
Enter the function
Type =PEARSON( and select your first range, followed by a comma and your second range.
In Excel, the PEARSON and CORREL functions are mathematically identical and return the same result.