This function examines two sets of data to determine the degree of relationship between the two sets.The result will be a decimal between 0 and 1.The larger the result, the greater the correlation.
Syntax:
=CORREL(Range1,Range2)
Example:
the Monthly temperature is compared against the Sales of air conditioning units.
The correlation shows that there is an 0.866 relationship between the data
Syntax:
=CORREL(Range1,Range2)
Example:
the Monthly temperature is compared against the Sales of air conditioning units.
The correlation shows that there is an 0.866 relationship between the data
No comments:
Post a Comment