| |
 |
|
|
|
| |
| |
Instructions and materials
Calculating AVE and STDEV in Excel
The html document below shows you how to use Excel to calculate averages and standard deviations.
The RLS worksheet
The Excel worksheet has been designed as tool for your use throughout the course. It provides several options for error analysis. Perhaps the most important is a linear regression that includes outputs of the standard errors using both least squares and robust statistics. By the end of the lab and Lecture 1 you should understand that robust statistics is useful for determining outliers. Outliers can be excluded from the data set provided you have gone through the appropriate statistical analysis. The RLS worksheet does this, but you should not use it as a "black box". You should understand the various tools provided and make sure you can justify the applications of this worksheet as you perform analyises of the data in various laboratories and experiments in this course.
|
| |
|