FUNCTION CORREL
This function returns the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties.
For example, you can examine the relationship between a location's average temperature and the use of air conditioners.
How does it work?
=CORREL(array1,array2)
Where...
Array1 is a cell range of values.
Array2 is a second cell range of values.
For example, you can examine the relationship between a location's average temperature and the use of air conditioners.
How does it work?
=CORREL(array1,array2)
Where...
Array1 is a cell range of values.
Array2 is a second cell range of values.
Comments
Post a Comment
Your Valuable Comments are Appreciated