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

W

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
 
M

Max

Plot a line graph. Right-click anywhere on the line > Choose "Add TrendLine"
then make the options in the dialog ..
 
S

Stan Brown

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

You can get our attention without shouting.

Right-click on the graph of data points, "Add trendline".
 
B

Bernard Liengme

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
 
Top