For graphs how do i put a line of best fit?

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

Guest

I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
AUTOMATICALLY BUT I HAVE NO CLUE HOW TO
 
Plot a line graph. Right-click anywhere on the line > Choose "Add TrendLine"
then make the options in the dialog ..
 
Fri, 20 Apr 2007 20:16:02 -0700 from watevva
I have an assignment that saYS I CAN PUT A LINE OF BEST FIT FOR MY GRAPH
AUTOMATICALLY BUT I HAVE NO CLUE HOW TO

You can get our attention without shouting.

Right-click on the graph of data points, "Add trendline".
 
But if you want to use the values (slope, intercept, r2) in the worksheet
then use the appropriate function SLOPE, INTERCEPT, RSQ - or use LINEST
best wishes
 
Back
Top