How to Construct Best Fit, Min and Max Slope Lines with Error …
Jun 13, 2007 · Error bars and slope error ?? Homework Statement I have to construct a graph with three lines. The middle line is 'best fit', one line is 'max slope'...
Uncertainty when using a line of best fit • Physics Forums
Sep 21, 2004 · I was just wondering if somebody knows how you find the uncertainty of a value obtained from a line of best fit. In my case I had to estimate the charge left on a capacitor, but …
Finding periodic best-fit equation for data set? • Physics Forums
Oct 10, 2013 · The discussion revolves around finding a periodic best-fit equation for a dataset resembling sin (x)+x. The original poster is using Excel to create a model with parameters A, …
How does excel calculate the best fit line? - Physics Forums
Aug 14, 2012 · The higher the order, the more accurate, hence the more the equation changes each time a data point is moved. All in all I need to find how excel models the best fit line and …
How Do You Create a Line of Worst Fit in Excel? - Physics Forums
Feb 27, 2012 · How would I go about creating a line of worst fit in excel? Would I create a different row for the uncertainties?
Is There a Way to Fit Lines of Worst Fit Using Statistical Packages?
Sep 5, 2008 · I recently completed an experiment for university level physics and am currently doing the analysis of the data. This data has been transformed to fit a...
Understanding the Best Fit Line: What Does It Mean?
Oct 1, 2008 · best fit line? DOes that mean you draw a line/curve connecting the dots? Or does that mean you draw a line in between the dots leaving some above and some below? or does …
Formula that will give the equation for the line of best fit of a data …
Aug 7, 2014 · Is there a formula that will give me the equation for the line of best fit of a data set, the line being a 6th degree polynomial? I know how to graph the table and add a line of best fit …
Fitting data to a Gaussian Distribution in Excel - Physics Forums
Jun 24, 2015 · Hey everyone, I'm hoping I can get some input on this. As some of you may recall, I'm currently in an internship at Fermilab, and I've hit a snag in plotting my data. I'm measuring …
Spring Constant from Best Fit Line - sqrt (m) versus T
Sep 10, 2012 · Homework Statement Construct a plot of T versus \\sqrt{m}. Fit a straight line through your data and use Eq. (3.2.3) to obtain the spring constant k from the slope, as well as …