Spreadsheet Assignment 02.1
Chemistry 102
Spring 1999
Using the Model Linear Least Squares Analysis found at http://www.csufresno.edu/chem/~davidz/Stat/LLSTutorial/LLSmodel/LLSmodelSp99.html
1. Duplicate the spreadsheet shown above, make sure it all works and print it out.
2. Work up the following data. Be sure you make all the appropriate changes to the Model spreadsheet shown above. The data came from a spectrophotometric analysis.
Conc, Molarity |
Absorbance |
1.24E-04 |
0.139 |
2.55E-04 |
0.295 |
5.88E-04 |
0.517 |
8.97E-04 |
0.962 |
unk 1 |
0.115 |
unk 2 |
0.453 |
After determining the values and errors of the two unknowns, comment on any differences you find in the two values of "s sub c."