I don't think this qualifies as a homework question, as I can work around it; please move if necessary.(adsbygoogle = window.adsbygoogle || []).push({});

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?

**Physics Forums | Science Articles, Homework Help, Discussion**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Uncertainties and LINEST in Excel...

**Physics Forums | Science Articles, Homework Help, Discussion**