The other important part of the entire output is a table of coefficients. Or in another language, information about the Y variable is explained 95.47% by the X variable. In this case, the R Square value is 0.9547, which interprets that the model has a 95.47% accuracy (good fit). One important part of this entire output is R Square/ Adjusted R Square under the SUMMARY OUTPUT table, which provides information, how good our model is fit. However, interpreting this output and make valuable insights from it is a tricky task. Till here, it was easy and not that logical.
You can download this Regression Analysis Excel Template here – Regression Analysis Excel Template #1 – Regression Tool Using Analysis ToolPak in Excelįor our example, we’ll try to fit regression for Weight values (which is a dependent variable) with the help of Height values (which is an independent variable). But why should you go for it when excel does calculations for you?
There is actually one more method which is using manual formula’s to calculate linear regression.
Linear relationship means the change in an independent variable(s) causes a change in the dependent variable. This means these are the variables using which response variables can be predicted.