Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Forced slope linest in EXCEL

  1. Jun 2, 2010 #1
    Hello,

    Does anyone have an idea about how to use fit data with a line while fixing the slope in MS. Excel? Does linest by anyway capable of doing that?

    Thank you

    Lorna
     
  2. jcsd
  3. Jun 2, 2010 #2

    hotvette

    User Avatar
    Homework Helper

    I doubt that linest has the ability to fix the slope, but you don't need it anyway. If you look at the equations for least squares line fit (i.e. y = mx + b), the intercept is calculated by:

    b = avg(y) - m*avg(x)
     
  4. Jun 4, 2010 #3
    Oh yes! Thank you a lot!!

    How would we calculate the error in the y-intercept? would it be zero?

    Thank you!!
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Forced slope linest in EXCEL
  1. Excel - (Replies: 2)

  2. Histogram in EXCEL (Replies: 3)

  3. Excel inputs. (Replies: 7)

Loading...