Simple Linear Regression through Data Analysis Toolpak
Embedded Files
Single RegressionThe following are the steps to find linear regression using Scatter Diagram.1. Select Data Menu2. Click Data Analaysis3. Data Analysis window will appear4. Select Regression and Click Ok.5. A window will open6. Feed the dependent variable (b2:b16) in the input Y Range7. Feed the independent variable (a2:a16) in the input X Range8. Choose Lables.9. Select Output Range in which the result to be placed.
Page updated
Report abuse