best straight line in Excel
 

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!

this is alraeady avble in exce. once a chart is created you get additional
menu <charat
click this menu and click <add trendline
choose <type tab
and click <linear
you get the least square st. line trend


Kelly J. <Kelly wrote in message
...
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!

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

Kelly J. wrote:

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!

"Kelly J." <Kelly wrote in message
...
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
--
David Biddulph