Introduction to Excel
|
Guidelines for drawing a best fit line to a set of data by hand and for estimating the associated error. PDF
(87 KB ) |
Graphing with Excel |
A run-through to creating graphs in Excel with the Chart Wizard, including tweaking the look of the graph, adding multiple data sets, fitting curves, and estimating the error of a curve fit. PDF (224 KB)
|
| Least
Squares Fitting with Excel
|
An introduction to using the Least Squares method to calculate the slope and intercept as well as the error of a line which best fits a set of data. Includes derivation of equations, going through the method using Excel formulae, and using the LINEST function for quick results. PDF (114 KB ) |
| Minimizing Chi-Squared |
Derivation of the equations for the slope and the intercept of the best fit line. This goes through the minimization of chi-squared, found from using the method of least squares to derive the equation for a line that best fits a set of data. PDF (27 KB) |
| Propagation
of Error for Slope and Intercept |
Details of propagating the error in y through the equations for slope and intercept (derived in the above-mentioned Minimizing Chi-Squared document) PDF (29 KB) |
| Physics 150 Text Concordance |
Text references relating to each lab |
| Physics 151 Text Concordance |
Text references relating to each lab |
| Histograms with
Excel 18 KB |
Quick instructions to using Excel to create histograms. |
Graph Paper is a website for printing out different kinds of graph paper Print Free Graph Paper is another website for printing different kinds of graph paper Interactive Physics and Math with Java has interactive web programs for mechanics and electromagnetism Eric Weisstein's Scienceworld definitions and proofs over a range of topics, including physics, astronomy, and chemistry Eric Weisstein's Mathworld definitions and proofs for many topics in math |
|
Send
Comments
Last update:9/15/06
by HSlogoff
