Trend line wont go through the origin

N

NeoDS

I'm doing my chemistry coursework, but when I enter the data and make a
trendline, the trendline doesn't start at x=0, y=0. how can I do this?
 
B

Bernard Liengme

Look in the Trendline Options tab; you can specify the value required fro
the intercept - in your case 0
To get the slope's value into a cell, do not copy the trendline equation but
rather use the SLOPE function. I am assuming you have a linear expression
(must graphs I used in teaching chem were linear); if no see my website to
learn about LINEST.
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top