UV/Vis Spectroscopy
 Page ID
 292500
Classroom Exercise #6: WorkUp of UVVis data
There is an Excel spreadsheet from the platereader that accompanies this exercise. You will need to use your computer to do the statistics to complete the questions.
UVVis
In this exercise, to test their skills to make a solution, each person in a class made a UVVis solution of a blue dye. The TAs and professor also made the same solution. The UVVis absorbance of each solution was collected with a platereader at 630 nm after the students pipetted 300 uL of their solution in a 96 well plate. Data are shown in the accompanying spreadsheet.
The class data is below, with 3 replicates per student (horizontally i.e. A 1&2&3 are the same person, A 46 are the same person, B1&2&3 are the same person, etc). The TA/prof data is in a column below the class data. I give you the average and s.d.
 Calculate the mean absorbance value for each person in the class.

 What is the mean and standard deviation of the student data? Use the per person data for this calculation.
 Whose standard deviation is higher, the students or the TAs? Why?
 What is the mean and standard deviation of the student data? Use the per person data for this calculation.

 What percentage of student values are within 1 standard deviation of the TA/prof value?
Within 2 standard deviations?
What percentage were outside 3 standard deviations?

If the data sampled the same normalized distribution, what percentage of values should have been within 1 standard deviation?
Within 2 standard deviations?
 What percentage of student values are within 1 standard deviation of the TA/prof value?
 Assume the TA/prof average value is the true value. Calculate the percent error for each person.
 Use the Qtest formula: can you throw out either the highest or the lowest student value? Why do think you can/cannot throw it out?

 What are the likely sources of error for those within 1 standard deviations of the TA/prof value?
 What are the likely sources of error for those within 2 standard deviations of the TA/prof value?
 What are the likely sources of error for those outside 3 standard deviations of the TA/prof value?
 What are the likely sources of error for those within 1 standard deviations of the TA/prof value?
Contributors and Attributions
 Jill Venton, University of Virginia (bjv2n@eservices.virginia.edu)
 Sourced from the Analytical Sciences Digital Library