These are a group of tutorials on skills needed to create good lab reports. They focus on using Microsoft Excel or OpenOffice Calc to analyze data. Each is a work in progress. Send comments.
Average and StdDev Simple instructions for using OpenOffice's Calc to compute the average and standared deviation of simple data.
Graphing Instructions Simple instructions for using Microsoft Excel to create a Scientific Graph.
Linear Graph Demo An animated demo on the steps needed to make a graph with Excel
Semilog Graph Demo A more complex demo showing how to make a semi-log graph with Excel.
Linear Regression Tutorial A tutorial on how to use Excel to do a linear regression.
Notes on Linear Regression A document that discusses linear regression, derives the equations, and shows code examples.
back to Physics Resources.