best straight line in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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. said:
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!
Click to expand...

Chart menu/ Add Trendline
 
Back
Top