how do I find the equation of a line using a scatter plot?

G

Guest

I am taking a chem lab and right now we are studying rate laws using
kenetics. we had to graph the results of our experiment and then find the
equation of the line. such as y=mx+b but i cant fiugre out how to do it. or
if i am supposed to put a trend line in the graph, but if that is what I am
supposed to do how do I find the equation of it?
 
B

Bernard Liengme

First: to make trendline. Right click on the data in the chart; use Add
trendline; specify Linear; on Options tab, check shoe equation

Secondly:To get slope and intercept:
Let's say you x-values are in A2:A11 and y-values in B2:B11
for slope use formula =SLOPE(A2:A11, B2:B11)
for intercept use INTERCEPT(A2:A11, B2:B11)
 

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

Similar Threads

Equation of a straight line on excel 1
Mixing scatter plot with a category plot 2
Adding a linear equation to my groovy scatter plot. 10
Excel 2007 Scatter Plot Freak Out! 3
Graphs (equation of a line) 1
Scatter plot 1
scatter plot 2
How do I determine the slope of a logarithmic scale data plot? 1

Top