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."