Question

Hey does anyone know how to draw a best fit line on excel

Answer 1

Right click on your data points and select add trendline and then you can choose linear.
you can also choose display R-squared value. The closer it is to 1 the better your data fits !!

Answer 2

plez give me a sec so i can do it. have a couple more qs

Answer 3

the line didnt go throught any of my points

Answer 4

well it depends on your data points and how many points you have

Answer 5

how can i make the line cross through the orgin

Answer 6

select option set intercept =0 (it is above the "display R-square option)