I. Construct a graph of concentration against absorbance, clearly show a best fit line. II. Find regression of your graph. Show how

Appl Of Ms Excel In Analytical Chemistry
2nd Edition
ISBN:9781285686691
Author:Crouch
Publisher:Crouch
Chapter2: Basic Statistical Analysis With Excel
Section: Chapter Questions
Problem 12P
icon
Related questions
Question
Table 1.0 of data showing calibration standards prepared by dilution and the absorbance
Concentration CuSO4 (M) Volume of 0.5M (ml) Volume of D/Water (ml) Absorbance
0.00
0.10
0.20
0.30
0.40
0.50
II.
0.00
1.00
2.00
3.00
4.00
5.00
5.00
4.00
3.00
2.00
1.00
0.00
1. Construct a graph of concentration against absorbance, clearly show a best fit line.
Find regression of your graph. Show how
0.000
0.406
0.638
0.854
1.202
1.276
Transcribed Image Text:Table 1.0 of data showing calibration standards prepared by dilution and the absorbance Concentration CuSO4 (M) Volume of 0.5M (ml) Volume of D/Water (ml) Absorbance 0.00 0.10 0.20 0.30 0.40 0.50 II. 0.00 1.00 2.00 3.00 4.00 5.00 5.00 4.00 3.00 2.00 1.00 0.00 1. Construct a graph of concentration against absorbance, clearly show a best fit line. Find regression of your graph. Show how 0.000 0.406 0.638 0.854 1.202 1.276
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Analyzing and Predicting Spectroscopic Data
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Appl Of Ms Excel In Analytical Chemistry
Appl Of Ms Excel In Analytical Chemistry
Chemistry
ISBN:
9781285686691
Author:
Crouch
Publisher:
Cengage