Question

What is the procedure for performing regression in Microsoft Excel?
What is the procedure for performing a regression in Microsoft Excel?

Answer 1

Answer:

Run regression analysis

• 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.

hope it helps you

Answer 2

Answer:

1.On the Data tab, in the Analysis group, click the Data Analysis button.

2.Select Regression and click OK.

3.In the Regression dialog box, configure the following settings: Select the Input Y Range, which is your dependent variable. ...

4.Click OK and observe the regression analysis output created by Excel.