Creating a residual plot in excel linear regression
If you’re interested to learn more about correlation, then I suggest you refer to the What is Pearson Correlation post. Briefly, it is a value that tells you how strong the linear relationship is.Ī value of 0.65 in this case indicates a fairly strong linear correlation between height and weight measures. This is the absolute value of the correlation coefficient between the two variables of interest. In the first table called Summary Output, there are some regression statistics from the test. I’ll now break down the output and go through each in more detail. Interpretation of the linear regression resultsĭepending on the options selected in the set-up window, you will have quite a lot of information in the results sheet.