B. Using the data below, construct a calibration curve. Include the error bars and the equation of the line and the linearity (R2) of the curve. Absorbance (Y-data) Absorbance (Y-data) Absorbance (Y-data) Calcium concentration (ppm) (X-data) Run 1 Run 2 Run 3 0.3 1109 1069 1155 1.2 1225 1168 1233 2.1 1472 1319 1389 4.2 1497 1523 1472 8.0 1833 1898 1849 16 2066 2012 2051

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.5: Correlation And Causation
Problem 21PFA
icon
Related questions
Question

Hi, please help me to find the:
1. Intercept
2. Slope
3. Pearson
4. Unknown Concentration

Please show me the step by step process in MS EXCEL please. So I can use it as a guide. Thank you so much. 

B. Using the data below, construct a calibration curve. Include the error bars and the equation of the line and
the linearity (R2) of the curve.
Absorbance (Y-data)
Absorbance (Y-data)
Absorbance (Y-data)
Calcium concentration
(ppm) (X-data)
Run 1
Run 2
Run 3
0.3
1109
1069
1155
1.2
1225
1168
1233
2.1
1472
1319
1389
4.2
1497
1523
1472
8.0
1833
1898
1849
|16
2066
2012
2051
Transcribed Image Text:B. Using the data below, construct a calibration curve. Include the error bars and the equation of the line and the linearity (R2) of the curve. Absorbance (Y-data) Absorbance (Y-data) Absorbance (Y-data) Calcium concentration (ppm) (X-data) Run 1 Run 2 Run 3 0.3 1109 1069 1155 1.2 1225 1168 1233 2.1 1472 1319 1389 4.2 1497 1523 1472 8.0 1833 1898 1849 |16 2066 2012 2051
Expert Solution
steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Similar questions
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage