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.