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. | |||||||||||