We want to analyze the data below in excel, Once we have the data in column form as shown below, the first step is to click on the “DATA” menu
Click on “Data Analysis” on the far right of the picture below. Select “Regression” and click “OK”
Select the Independent variable (x) range from the excel worksheet, do the same for the dependent variable (y). Since the first row has a label, tick the labels as well as the confidence level boxes (95% is the ideal one). You can decide to have your output within the same worksheet or select “New Worksheet ply”. After click “ok”
Here we have the regression result. SUMMARY OUTPUT Regression Statistics Multiple R 0. 982512 R Square 0. 96533 Adjusted R Square 0. 960997 Standard Error 7. 363787 Observations 10 ANOVA Regression Residual Total Intercept x df SS 1 8 9 Coefficients 133. 7324 -1. 39437 12078. 7 433. 8028 12512. 5 Standard Error 5. 011591 0. 093426 MS F 12078. 7 54. 22535 222. 75 t Stat 26. 68462 -14. 9248 Significance F 4. 01 E-07 P-value Lower 95% Upper 95% Lower 95. 0% Upper 95. 0% 4. 18 E-09 122. 1756 145. 2891 4. 01 E-07 -1. 60981 -1. 17893
Interpretation of the Result
Try out the process on your own This can be applied to data with more than one Independent variable, that is, X 1, X 2, ………. Let me have your comments