UV/Vis Spectroscopy
( \newcommand{\kernel}{\mathrm{null}\,}\)
Classroom Exercise #6: Work-Up of UV-Vis 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.
UV-Vis
In this exercise, to test their skills to make a solution, each person in a class made a UV-Vis solution of a blue dye. The TAs and professor also made the same solution. The UV-Vis 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 4-6 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 Q-test 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