Using the data below please make two graphs with Excel (or a similar program). 1. Absorbance (v-axis) vs. A (x-axis) for the absorbance curve of the dye solution. Connect the points with a smooth curve. 2. Absorbance (y-axis) vs. concentration (x-axis) for the Beer's Law data. Draw a best-fit line or use a program such as Excel and do a least-squares fit to determine the best-fit line through the points. please answer super super fast please please need it now its urgent just creat the graphs

icon
Related questions
Question
Using the data below please make two graphs with Excel (or a similar program). 1. Absorbance (v-axis) vs. A (x-axis) for the absorbance curve of the dye solution. Connect the points with a smooth curve. 2. Absorbance (y-axis) vs. concentration (x-axis) for the Beer's Law data. Draw a best-fit line or use a program such as Excel and do a least-squares fit to determine the best-fit line through the points. please answer super super fast please please need it now its urgent just creat the graphs
Data-Absorbance Curve
λ, nm
480
490
500
510
520
530
540
550
Volume of
Allura Red,
Absorbance
Data-Beer's Law
0.790A
0.920A
0.979 A
0.961 A
220
0.900 A
0.821A
0.681A
0.492 A
216
ml
Concentration
of Allura Red, 0.00004 M
M
Absorbance
at λ max
Data-Unknowns
8.00
0.961A
Unknown # Absorbance at 2
0.425 A
6.00
0.978A
0.00003 M
0.684 A
max
4.00
0.00002M
0.471A
λ, nm
560
570
580
590
600
2.00
0.0000IM
0.254A
Absorbance
0.275 A
0.118 A
0.042 A
0.009A
-0.004A
Transcribed Image Text:Data-Absorbance Curve λ, nm 480 490 500 510 520 530 540 550 Volume of Allura Red, Absorbance Data-Beer's Law 0.790A 0.920A 0.979 A 0.961 A 220 0.900 A 0.821A 0.681A 0.492 A 216 ml Concentration of Allura Red, 0.00004 M M Absorbance at λ max Data-Unknowns 8.00 0.961A Unknown # Absorbance at 2 0.425 A 6.00 0.978A 0.00003 M 0.684 A max 4.00 0.00002M 0.471A λ, nm 560 570 580 590 600 2.00 0.0000IM 0.254A Absorbance 0.275 A 0.118 A 0.042 A 0.009A -0.004A
Expert Solution
steps

Step by step

Solved in 3 steps with 5 images

Blurred answer