EXCEL 97: Two-Way Plots including Regression using Add Trendline

A. Colin Cameron, Dept. of Economics, Univ. of Calif. - Davis

This September 1999 help sheet gives information on For considerable detail on the basics of chart making see The presentation here is much shorter.
 

TWO-WAY SCATTERPLOTS

A two-way scatter plot has one variable (say Y) on the vertical axis and one variable (say X) on the horizontal axis.
This is done by choosing the Chart Wizard and the XY scatter plot option.

Then customize the chart in the usual way.
 

TRENDLINE FOR TWO-WAY SCATTERPLOTS

A separate trendline (or regression line) can be added after the chart is created by

This adds a trendline to the data.
This trendline is actually two-variable regression.
To obtain the formula for the regression line, which is then displayed on the chart, in Add Trendline choose options and select Display equations on chart.
To obtain the R-squared for the regression line, which is then displayed on the chart, in Add Trendline choose options and select Display R-squared on chart.
For more detailed regression output use Tools | Data Analysis | Regression or more detailed Excel commands.
 

For further information on how to use Excel go to
     http://www.econ.ucdavis.edu/faculty/cameron