linear regression
 

Can anyone point me in the right direction of how to use Excel to do simple
regression? Thanks. Jason.

linear regression
 

Jason --

One easy way is inside the chart function.
1) Create the XY chart showing the data points.
2) Right-click on one of the data points in the chart.
3) Click 'Add Trendline'.
4) On the 'Type' tab, make sure that the 'linear' trendline is selected.
5) On the 'Options' tab, make sure that the 'Display equation' is selected,
and the 'Display R-squared' is selected.
6) Click 'OK'.

Or do you need to have the formulas in the spreadsheet itself?

"Jason - MR" wrote:

Can anyone point me in the right direction of how to use Excel to do simple
regression? Thanks. Jason.