This calculation refers to the correlation coefficient which measures the strength of a linear relationship between two variables. You can also use the equation to make predictions. Excel produces the following Summary Output rounded to 3 decimal places.
For our example well try to fit regression for Weight values which is a dependent variable with the help of Height values which is an independent variable.
Click Data Analysis and find the option for regression in the window that pops up highlight it and click OK. There is little extra to know beyond regression with one explanatory variable. The closer to 1 the better the regression line read on fits the data. How can I get the multiple non-linear regression equation using SPSSExcel.