close

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?

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)

--
Bernard V Liengme (he taught Intro Chem for 38 years!)
www.stfx.ca/people/bliengme
remove caps from email

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()