Tutorial on Using Excel to Run OLS

Under the Type tab, in the Trendline dialog box choose the Linear Trend/Regression type. Also under the Options tab, select ‘Display equation of chart’ and ‘Display R-squared value on chart, then click OK. The R2 value and regression equation are displayed and a line corresponding to the regression equation is drawn on the chart. ................
................

In order to avoid copyright disputes, this page is only a partial summary.