1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Creating a Y = kx + m plot in excel

  1. Nov 19, 2008 #1
    1. The problem statement, all variables and given/known data
    Values for t
    1,2
    3,4
    7,15
    9,32
    12,28
    15
    18,39
    21,45

    Values for ln(V-Vt)
    3,6
    3,57
    3,54
    3,51
    3,48
    3,45
    3,42
    3,39

    ln V = 3,63

    2. Relevant equations
    ln (V-Vt) = ln V - k''t

    Teacher Quote: "If ln (V-Vt) is plotted against t in a diagram a straight line will form with the k'' as the slope."


    3. The attempt at a solution

    I marked the t-values as X and ln(V-Vt) as Y and excel drew a plot that completely changed the values of Y, making them ten times as big to fit the X values.
     
  2. jcsd
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Can you help with the solution or looking for help too?
Draft saved Draft deleted



Similar Discussions: Creating a Y = kx + m plot in excel
Loading...