kunlez wrote:
How or where do I perform linear regression - in the chart or worksheet?

------------

Lots of possibilities, depending on what you want to get out of it.

The simplest way is to just plot your data on an X,Y chart and then ask Excel to
add the trend line to the data. Right click on the data line of the chart and
select "Add Trend line" and follow your nose through the menus. If you go
through the chart options it will even allow you to display the line equation
it's using on the chart.

The next step up is to use the built in LINEST() function in Excel to add a
column to your chart with the fit-line data and plot that along with the X,Y
data to a chart. This will produce a least squares fit. Ask your Excel help
system for details.

Or you can ask Excel to evaluate the INTERCEPT() and SLOPE() functions and use
those yourself to produce the line values.

Finally, if you want some fit other than least squares, you can write your own
equations and use Solver to find the parameters you've defined.

Good luck...

Bill