Data Correlation in Calc/text/scalc/01/statistics_correlation.xhpAnalysis toolpack;correlationcorrelation;Analysis toolpackData statistics;correlation
Correlation
Calculates the correlation of two sets of numeric data.Choose The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables.A correlation coefficient of +1 indicates a perfect positive correlation. A correlation coefficient of -1 indicates a perfect negative correlationFor more information on statistical correlation, refer to the corresponding Wikipedia article.The following table displays the results of the correlation of the sample data above.