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

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman