Unformatted text preview: and absorbance values for the first 4 wavelengths listed in the file absorbance.csv . B) Utilize matrix inversion to calculate the concentrations of Ni, Co, Cr and Cu, using the k and absorbance data for wavelengths 2-5 in the file absorbance.csv . C) Use least squares on k and absorbance values for all 8 wavelengths in the file to calculate concentrations and standard deviations in concentration for Ni, Co, Cr and Cu. Submit the following: 1. A printed copy of the spreadsheet you used to calculate the answers to parts A, B and C. Your results from part C will include standard deviations as well as concentrations; format these numbers to show the appropriate number of significant figures. 2. A printout of the formulas used in your calculations for parts A, B and C. Be sure to format your spreadsheet such that the formulas are shown in their entirety....
View Full Document
- Fall '10
- Chemistry, Elementary algebra