best straight line in Excel

[Kelly J.]

Hi,

I'd like to know how to plot the best straight line for a set of data points
in an Excel chart, minimising error using least squares regression method.

Greatly appreciate if anyone could help I know there's such a method, but
can't figure out how to do it.

Thanks in advance!

 

[Jerry W. Lewis]

With the chart selected, use the menu item Chart|Add Trendline and
select linear (from the options page you can choose to also display the
formula and/or R^2 if needed).

Alternately, you could calculate the line's equation in the worksheet
with SLOPE and INTERCEPT functions and use that equation (or the
FORECAST function) to calculate points on the line and plot the line as
an additional data series.

Jerry

 

[David Biddulph]

Hi,

I'd like to know how to plot the best straight line for a set of data
points
in an Excel chart, minimising error using least squares regression method.

Greatly appreciate if anyone could help I know there's such a method,
but
can't figure out how to do it.

Thanks in advance!

Chart menu/ Add Trendline