## Introduction:-

CORREL function in excel is a statistical function. It is used to find correlation between two variables and gives correlation coefficient having value between +1 and -1. A value of +1 means a perfect directly proportional relation is present and a value of -1 means a perfect inversely proportional relation is present. It is a worksheet function and can be entered into the cell in which value is required.

## Syntax:-

*=CORREL(array1, array2) *

## Arguments:-

Array1: 1^{st} range of values

Array2: 2^{nd} range of values

## Keynotes:-

- If the arguments contain text, empty cell, logical values etc. then they are ignored but cell having 0 as value is not ignored.
- If arguments contain different set of data points, #N/A error is displayed.
- If any of the argument is empty, #DIV/0! Error value is displayed.
- Equation used for correlation coefficient is:

Here bar over x and y represents there average values.

## Examples

- In this example, various values are entered in Column A and Column B , and a correlation between values of Column A and column B are found using the formula =CORREL(A4:A9, B4:B9) which gives 0.9426332927 as the result.