Generate a Standard Curve

1. Generate a Standard Curve.
Use Excel to graph a marked scatter plot (this means only data points are shown in graph and
the points are not connected by a line) of the standard values that you obtained for glycine
and draw a linear regression line using absorbance values vs concentration (in mM) for each
standard. The independent variable is on the x-axis and the dependent variable on the y-axis.
Display the straight-line equation of the regression line on the graph.
IMPORTANT: The color of the regression line and the data points MUST be BLUE
(you will receive 0 marks for question 1 in case that a different colour is shown).
Explanatory note: The teaching team strictly enforce the above indicated color
requirements in order to ensure the originality of 2019 worksheet submissions.
Give the graph a concise, useful and descriptive title and label the axes. Include appropriate
units or cite the wavelength measured. Provide a figure legend, which concisely describes the
graph that is shown, and the experiment that underlies the measurements. A figure legend
does not reproduce the entire experimental procedures in detail, but rather puts the shown
result into an experimental context. In the figure legend define the terms of the equation that
is presented in the graph. 2 marks
Insert/ Cut and paste your standard curve and figure legend in this space. Do NOT insert a scan
from a hand-drawn graph! The graph must be generated with suitable graphing software!

2. What is the concentration in mM (!) for the average of your unknown glycine sample
(Part B of prac)?
i) Write down the equation derived from your Excel generated standard curve (question 1)
and describe its components (!); ii) show all details of the working out of your calculation.
Indicate all units! Provide the answer with two (!) decimals precision; iii) state the answer in
a full sentence (note: avoid mathematical symbols (=, +, -, etc) in your answer sentence).
1 mark
Y=4.9011x
Y=4.9011x
0.177=4.9011x
X=0.036
iii) From the calibration curve the analytical response of an absorbance of 0.177 gives us a
concentration of 0.036