sql-functions

Correation in SQL

The correlation is a statistical measure that shows how closely related are two sets of values. The most used correlation measure used is the Pearson’s Correlation Coefficient. The Pearson’s Correlation Coefficient gives: a value of 1 for a perfect correation. a value of 0 for no correlation. a value of -1 for a perfect negative correlation Examples of Positive and Negative Correlation: Positive Correlation: marketing expenditure and sales, price of a competitor product and sales.