Home Computer Learn how to use Correl Excel function step by step with Example.

Learn how to use Correl Excel function step by step with Example.

1 min read
0
0
37
1ST.0 2

CORREL

correlation coefficient calculator excel

 

What Does It Do ?

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.

In Table 1 the Monthly temperature is compared against the Sales of air conditioning units.
The correlation shows that there is an 0.864 relationship between the data.

In Table 2 the Cost of advertising has been compared to Sales.
It can be formatted as percentage % to show a more meaningful result.

The correlation shows that there is an 28% relationship between the data.

 
Syntax

=CORREL(Range1,Range2)

 
Formatting
The result will normally be shown in decimal format.
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…