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

Uncertainties and LINEST in Excel...

  1. Nov 28, 2015 #1
    I don't think this qualifies as a homework question, as I can work around it; please move if necessary.

    I am currently doing a lab report on the Magnetic Susceptibility of different samples.

    In one part of this report I have to plot Force vs B^2, which is a linear fit. I have errors which have been propogated through on both the Force and B^2. I need a value for the gradient so I use the LINEST tool on Excel to do a linear regression and find a value for my slope. However the errors bars for Force and B^2 are not incorporated into this linear fit and the error on the slope from the linear regression seems to be separate from these. Is there any way to incorporate the errors from the values of force and b^2 into my linear regression fit?
  2. jcsd
  3. Dec 3, 2015 #2
    Thanks for the post! This is an automated courtesy bump. Sorry you aren't generating responses at the moment. Do you have any further information, come to any new conclusions or is it possible to reword the post?
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook