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 J.@discussions.microsoft.com> wrote in message
news:51ACFE89-7346-405A-B273-(E-Mail Removed)...
> 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 J.@discussions.microsoft.com> wrote in message
news:51ACFE89-7346-405A-B273-(E-Mail Removed)...
> 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