What Is Correlation Coefficient In Excel. Correl function in excel is used for calculating Correlation Coefficient whose value ranges from -1 to 1 only and it also shows how strongly any 2 values are related. Pearsons correlation coefficient is the test statistics that measures the statistical relationship or association between two continuous variables.
Top courses in Excel Master Microsoft Excel - Excel from Beginner to Advanced. Use the correlation coefficient to determine the relationship between two properties. The calculation can have a value between 0 and 1.
The correlation coefficient falls between -10 and 10.
It is because the range for correlation coefficient is only -1 to 1 which is quite small and the value falling under this range will be less as compared to any other number. The correlation analysis helps to the analyst to determine whether it is possible for the value of one indicator to predict the potential value of the other one. A coefficient of -1 represents a perfect negative correlation. - A correlation coefficient of 1 indicates a perfect positive correlation.
