I am sure you tried to execute regression analysis using the routine that Microsoft embedded in the Data Analysis Excel add-in. Nice and easy, and very intuitive. However, do you really understand every cell from the output? If you do not, this tutorial might come to your rescue.
This tutorial is designed to help you understand and be able to interpret the meaning of every Regression Output cell. Moreover, it will provide you with equations and related Excel functions to reproduce every coefficient and the related statistics from this output and enable you to replicate the Output values.
To read the tutorial go here, and to check the spreadsheet demonstrating how all the calculations are executed, click here.