please can you please im begging can you please create graphs with Excel (or a similar program). Plot absorbance (v-axis) vs. A (×- axis) for the absorbance curve determined in part 2. Connect the points with a smooth curve. Plot absorbance (y-axis) vs. concentration (x-axis) for the Beer's Law data from part 3. 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λ, nm480490500510520530540550Volume ofAllura Red,Data Beer's LawmlConcentrationof Allura Red,MAbsorbanceat λAbsorbance0.723 A0.842 A0.887 A0.860 A0.805 A0.731 Amax0.606 A0.434 A8.006.004.0 x10-5 3.0 x105Data-Unknowns4.00Unknown # Absorbance at λ max110.836 A2.0 x 1050.887 A 0.563 A 0.465 Aλ, nm5605705805906002.00Absorbance0.231 AO. 104 A0.039 A0.019 A0.006 A1.0 x10-50.465 A 0.243 A GRAPHSCreating graphs with Excel (or a similar program) is preferred. Plot absorbance (y-axis) vs. λ (x-axis) for the absorbance curve determined in part 2. Connect the points with a smooth curve.Plot absorbance (y-axis) vs. concentration (x-axis) for the Beer's Law data from part 3. Draw abest-fit line or use a program such as Excel and do a least-squares fit to determine the best-fitline through the points. Attach your graphs to the yellow copies of your report from yournotebook.CALCULATIONSShow a sample calculation of the concentration of the solutions made by dilution. Also use theslope of the best-fit line from your absorbance vs. concentration plot to calculate theconcentration of Allura Red in each unknown.RESULTSUnknown #[Allura Red], M

Plot the absorbance on y-axis and wavelength on x-axis. The graph is shown below.

Answered: Creating graphs with Excel (or a…

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...

See similar textbooks

Related questions

Concept explainers

Question

please can you please im begging can you please create graphs with Excel (or a similar program). Plot absorbance (v-axis) vs. A (×- axis) for the absorbance curve determined in part 2. Connect the points with a smooth curve. Plot absorbance (y-axis) vs. concentration (x-axis) for the Beer's Law data from part 3. 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,
Data Beer's Law
ml
Concentration
of Allura Red,
M
Absorbance
at λ
Absorbance
0.723 A
0.842 A
0.887 A
0.860 A
0.805 A
0.731 A
max
0.606 A
0.434 A
8.00
6.00
4.0 x10-5 3.0 x105
Data-Unknowns
4.00
Unknown # Absorbance at λ max
11
0.836 A
2.0 x 105
0.887 A 0.563 A 0.465 A
λ, nm
560
570
580
590
600
2.00
Absorbance
0.231 A
O. 104 A
0.039 A
0.019 A
0.006 A
1.0 x10-5
0.465 A 0.243 A

GRAPHS
Creating graphs with Excel (or a similar program) is preferred. Plot absorbance (y-axis) vs. λ (x-
axis) for the absorbance curve determined in part 2. Connect the points with a smooth curve.
Plot absorbance (y-axis) vs. concentration (x-axis) for the Beer's Law data from part 3. 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. Attach your graphs to the yellow copies of your report from your
notebook.
CALCULATIONS
Show a sample calculation of the concentration of the solutions made by dilution. Also use the
slope of the best-fit line from your absorbance vs. concentration plot to calculate the
concentration of Allura Red in each unknown.
RESULTS
Unknown #
[Allura Red], M

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Introduction and Principles of Quantum Theory

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