Saturday, February 19, 2011

How to Perform Linear Regression in an Excel Spreadsheet


Excel 2003
1. Highlight your chart data by clicking at the top left of the data and then dragging the mouse to the bottom right.
2. Graph a scatter plot from your data. Click on the 'Insert' menu, then click on 'Chart' to start the Chart Wizard. Click on 'XY (Scatter)' in the Chart Type box.
3. Add a trend line to the graph. Click on 'Chart' and then click on 'Add Trendline.' A pop-up window will appear.
4. Click on the 'Linear' Trend/Regression Type icon.
5. Click on the 'Options' tab, then check the 'Display equation on chart' box.
6. Click on 'OK' to display the regression line on your chart.
Excel 2007 or Excel 2010
7. Highlight your chart data by clicking at the top left of the data and then dragging the mouse to the bottom right.
8. Click on 'Insert,' then click on 'Scatter.' Click on the first scatter graph icon on the left.
9. Click on 'More Trendline Options.'
10. Click the 'Linear' radio button, then click the 'Display Equation on Chart' check box.
11. Click on 'Close.' Excel will insert the regression line into your chart.

Blogger news