Correl
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
=COMBIN(HowManyItems,GroupSize)
Formatting
No special formatting is required.
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
=COMBIN(HowManyItems,GroupSize)
Formatting
No special formatting is required.
| 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 | ||