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

    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

  2. jcsd
  3. Jun 2, 2010 #2


    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!!
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook