.

CORREL Function Dictionary

Function Dictionary Function Examples Function Categories

CORREL          
 
 
Table 1 Table 2
Month Avg Temp Air Cond
Sales
Advertising
Costs
Sales
Jan 20 100 £2,000 £20,000
Feb 30 200 £1,000 £30,000
Mar 30 300 £5,000 £20,000
Apr 40 200 £1,000 £40,000
May 50 400 £8,000 £40,000
Jun 50 400 £1,000 £20,000
       
  Correlation 0.864 Correlation 28%
 =CORREL(D5:D10,E5:E10)  =CORREL(G5:G10,H5:H10)
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 realtionship 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 meaning full result.
The correlation shows that there is an 28% realtionship between the data.
Syntax                
=CORREL(Range1,Range2)
Formatting              
The result will normally be shown in decimal format.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download