Question: how to do a linear regression in excel?
Answer: On the Data tab, in the Analysis group, click the Data Analysis button.
Select Regression and click OK.
In the Regression dialog box, configure the following settings: Select the Input Y Range, which is your dependent variable. ... 
Click OK and observe the regression analysis output created by Excel.