Software
General
These utility programs were written for use in the Methods of Experimental Physics and Modern Physics Lab courses here at the University of Minnesota.  They maybe used for personal use but they are the property of the Regents of University of Minnesota and may not be sold or otherwise distributed without written approval.

 

LSQ Fit
This Microsoft Excel spreadsheet by Kurt Wick uses a Least Squares Fit to calculate the best fit to a straight line.  It determines the slope and intercept of the line, their uncertainties and the total and the reduced Chi Squares of the fit.  Additional instructions are included in the program and you will need Microsoft Excel Version 97 or newer to run this program.

For more information on Least Squares Fitting see also the Notes on Statistics at this server.

If you have problems reading these files, right click on the hyperlink below and select Save Target As...  Save them to your computer and then try to open them by double clicking on them:
http://mxp.physics.umn.edu/resources/Images/LSQFit.XLS

 

LSQ Fit 2nd Order
This Microsoft Excel spreadsheet by Kurt Wick uses a Least Squares Fit to calculate the best fit to a second degree polynomial.  It determines the various coefficients and their uncertainties and the total and the reduced Chi Squares of the fit.  Additional instructions are included in the program and you will need Microsoft Excel Version 97 or newer to run this program.

For more information on Least Squares Fitting see also the Notes on Statistics at this server.

If you have problems reading these files, right click on the hyperlink below and select Save Target As...  Save them to your computer and then try to open them by double clicking on them:
http://mxp.physics.umn.edu/resources/Images/LSQFit2D.XLS

back

Last Updated: 04/25/2001