Hi,

In the chart:
Right-click on any data-point in the chart -- "Add Trendline" -- Linear
regression is the default selection; click on the "Options" Tab and check
"Display ewquation on Chart" -- "OK".

In the worksheet:
Enter the following equations in two cells.
=SLOPE(your y-range, your x-range); [ e.g., =SLOPE(B2:B101,A2:A101)]
=INTERCEPT(your y-range, your x-range); [e.g., =INTERCEPT(B2:B101,A2:A101)]

In the worksheet (if you need regression statistics too)
Select an 2 column X 5 row area, enter the following formula, and confirm
with CTRL-SHIFT-ENTER.
=LINEST(your y-range, your x-range,,1); [e.g.,
=INTERCEPT(B2:B101,A2:A101,,1)]
The formula will return the regression statistics along with the values for
the slope and the y-intercept (Look in Excel Help for details about what
those values mean).

Regards,
B. R. Ramachandran



"kunlez" wrote:

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