Absorbance Values from Serial Dilution Questions

In this section, you will need to submit (individually) a fully-typed Worddocument with the following:
-Answer post lab summary Questions 1, 2, 3, and 5 provided in Page 21 in the lab manual. Each question
is worth 3 points, total 12 points.
-Use the absorbance and concentration data collected in the lab to
create two calibration plots, one from serial dilution and the other
from parallel dilution (10 points each plot). Each calibration plot must have
the correct title of the graph, X and Y-labeling, linear equation, Rsquare value and slope displayed on the graph to qualify for full credit.
Also make sure to include a title, your name, section number, and ALL the
calculations involved with the assignment.
You can plot the graphs using Excel as demonstrated in the introductory
video from this Module or in the link below and add them to the Word file
for submission:
Link: Calibration Plot (Links to an external site.)
Reference: Harper College
Note: If you notice a negative slope or your X-axis is labeled as whole numbers
1,2,3,4..etc., you may have an input error in your concentration data on the
spreadsheet. Excel is particular at how it recognizes numbers. If the value in the table is
1×10-4, you have to input in in Excel as either 0.0001 or 1E-04.
-Your lab instructor will provide a sample of your dye with an unknown
concentration; use the data you collected (follow Beer’s Law) to determine
the concentration of the unknown solution. Show all the calculations. (5
points)
Table#1: Absorbance Values from Serial Dilution @ λmax
Concentration (in M)
Absorbance @ xxx nm Trial 1
Absorbance @ xxx nm Trial 2
Table#2: Absorbance Values from Parallel Dilution @ λmax
Concentration (in M)
Absorbance @ xxx nm Trial 1
Absorbance @ xxx nm Trial 2