Ask your own question, for FREE!
Computer Science 10 Online
OpenStudy (anonymous):

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

OpenStudy (anonymous):

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 !!

OpenStudy (anonymous):

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

OpenStudy (anonymous):

the line didnt go throught any of my points

OpenStudy (anonymous):

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

OpenStudy (anonymous):

how can i make the line cross through the orgin

OpenStudy (anonymous):

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

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!