Multiple Regression in Excel


Note: The data analysis could be gotten from the add-in (file > options > add-ins > Go).
2. Choose Regression in the Data Analysis, and click ok.
3. Choose the data you’d want to analyze on X values (1), and Y values (2). Select desired options, under the residuals (3), and press ok (4).
In conclusion, the multiple regression would look something like this:
Template
You can download the Template here – Download
Further reading: Linear Regression Basic concepts Getting started with Excel Cell References