After selecting the data to be analyzed, click "Insert", select "Scatter Plot", and select a scatter plot type. To generate a graph, we click to select the data in the graph, right-click and select "Add Trend Line". In the options box, select "Linear" for the trend line, then check "Show Formula" and "Show R-squared Value", and click "Close" ". We get the square of the linear correlation coefficient R, and we can get the correlation coefficient by taking the root sign of it.
The specific steps are as follows:
1. First, we open an excel document and select the data for demonstration
2. Select the After analyzing the data, click "Insert," select "Scatter Plot," and choose a scatter plot type.
#3. Generate the graph as shown below. We click to select the data in the graph, right-click and select "Add Trend Line".
#4. In the options box, select "Linear" for the trend line, then check "Show formula" and "Show R-squared value", and click "Close".
5. At this time, you can see in the figure that the square of the linear correlation coefficient R is 0.9924. We can get the correlation coefficient by taking the root sign of it, as shown in the figure As shown, the correlation coefficient is 0.996.
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of Find excel correlation coefficient. For more information, please follow other related articles on the PHP Chinese website!