+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Anniebabygirl
    Guest

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

    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?

  2. #2
    Bernard Liengme
    Guest

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

    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

    "Anniebabygirl" <Anniebabygirl@discussions.microsoft.com> wrote in message
    news:3981B2C1-6ECE-4C0D-B090-EDB34624ABAF@microsoft.com...
    >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?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1