Table 2: Absorbance Values of Standards and Unknowns. Sample Blank Standard Solution 1 Standard Solution 2 Standard Solution 3 Standard Solution 4 Standard Solution 5 Water Sample 1 Water Sample 2 Phosphate Concentration (in ppm) Y17 0 ppm 0.02 ppm 0.04 ppm 0.08 ppm 0.16 ppm 0.32 ppm Freeman Lake 0.001 0.325 0.292 0.413 0.315 0.039 0.054 0.049 Absorbance at 2.-690 nm Calculations: 1. Construct a phosphate standard curve in Excel by plotting concentration (in ppm) on your x-axis and Absorbance (unitless) on your y-axis for your known solutions. Label the axes on the graph and provide the curve with a title. Use a linear trendline to generate a best fit line to your data. Label the graph with the equation and the value. Insert your labeled graph in the space below. 2
Table 2: Absorbance Values of Standards and Unknowns. Sample Blank Standard Solution 1 Standard Solution 2 Standard Solution 3 Standard Solution 4 Standard Solution 5 Water Sample 1 Water Sample 2 Phosphate Concentration (in ppm) Y17 0 ppm 0.02 ppm 0.04 ppm 0.08 ppm 0.16 ppm 0.32 ppm Freeman Lake 0.001 0.325 0.292 0.413 0.315 0.039 0.054 0.049 Absorbance at 2.-690 nm Calculations: 1. Construct a phosphate standard curve in Excel by plotting concentration (in ppm) on your x-axis and Absorbance (unitless) on your y-axis for your known solutions. Label the axes on the graph and provide the curve with a title. Use a linear trendline to generate a best fit line to your data. Label the graph with the equation and the value. Insert your labeled graph in the space below. 2
Chemistry
10th Edition
ISBN:9781305957404
Author:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Chapter1: Chemical Foundations
Section: Chapter Questions
Problem 1RQ: Define and explain the differences between the following terms. a. law and theory b. theory and...
Related questions
Question
100%

Transcribed Image Text:Table 2: Absorbance Values of Standards and Unknowns.
Sample
Blank
Standard Solution 1
Standard Solution 2
Standard Solution 3
Standard Solution 4
Standard Solution 5
Water Sample 1
Water Sample 2
Phosphate Concentration
(in ppm)
Y17
0 ppm
0.02 ppm
0.04 ppm
0.08 ppm
0.16 ppm
0.32 ppm
Freeman Lake
0.001
0.325
0.292
0.413
0.315
0.039
0.054
0.049
Absorbance at
2= 690 nm
Calculations:
1. Construct a phosphate standard curve in Excel by plotting concentration (in ppm) on your
x-axis and Absorbance (unitless) on your y-axis for your known solutions. Label the axes
on the graph and provide the curve with a title. Use a linear trendline to generate a best fit
line to your data. Label the graph with the equation and the R" value. Insert your labeled
graph in the space below.
X
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, chemistry and related others by exploring similar questions and additional content below.Recommended textbooks for you

Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning

Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education

Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning

Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning

Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education

Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning

Organic Chemistry
Chemistry
ISBN:
9780078021558
Author:
Janice Gorzynski Smith Dr.
Publisher:
McGraw-Hill Education

Chemistry: Principles and Reactions
Chemistry
ISBN:
9781305079373
Author:
William L. Masterton, Cecile N. Hurley
Publisher:
Cengage Learning

Elementary Principles of Chemical Processes, Bind…
Chemistry
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY