Bartleby Related Questions 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
**Educational Website Transcription**

### Data — Absorbance Curve

#### Table 1: Absorbance Measurements

| λ (nm) | Absorbance |
|--------|------------|
| 480    | 0.790 A    |
| 490    | 0.920 A    |
| 500    | 0.979 A    |
| 510    | 0.961 A    |
| 520    | 0.900 A    |
| 530    | 0.621 A    |
| 540    | 0.604 A    |
| 550    | 0.492 A    |

| λ (nm) | Absorbance |
|--------|------------|
| 560    | 0.275 A    |
| 570    | 0.118 A    |
| 580    | 0.042 A    |
| 590    | 0.009 A    |
| 600    | -0.004 A   |

### Data — Beer’s Law

#### Table 2: Beer’s Law Data

| Volume of Allura Red (ml) | Concentration of Allura Red (M) | Absorbance at λₘₐₓ |
|---------------------------|---------------------------------|--------------------|
| 8.00                      | 0.00004 M                       | 0.981 A            |
| 6.00                      | 0.00003 M                       | 0.684 A            |
| 4.00                      | 0.00002 M                       | 0.474 A            |
| 2.00                      | 0.00001 M                       | 0.254 A            |

### Data — Unknowns

#### Table 3: Unknown Samples

| Unknown # | Absorbance at λₘₐₓ |
|-----------|---------------------|
| 220       | 0.426 A             |
| 216       | 0.973 A             |
expand button
Transcribed Image Text:**Educational Website Transcription** ### Data — Absorbance Curve #### Table 1: Absorbance Measurements | λ (nm) | Absorbance | |--------|------------| | 480 | 0.790 A | | 490 | 0.920 A | | 500 | 0.979 A | | 510 | 0.961 A | | 520 | 0.900 A | | 530 | 0.621 A | | 540 | 0.604 A | | 550 | 0.492 A | | λ (nm) | Absorbance | |--------|------------| | 560 | 0.275 A | | 570 | 0.118 A | | 580 | 0.042 A | | 590 | 0.009 A | | 600 | -0.004 A | ### Data — Beer’s Law #### Table 2: Beer’s Law Data | Volume of Allura Red (ml) | Concentration of Allura Red (M) | Absorbance at λₘₐₓ | |---------------------------|---------------------------------|--------------------| | 8.00 | 0.00004 M | 0.981 A | | 6.00 | 0.00003 M | 0.684 A | | 4.00 | 0.00002 M | 0.474 A | | 2.00 | 0.00001 M | 0.254 A | ### Data — Unknowns #### Table 3: Unknown Samples | Unknown # | Absorbance at λₘₐₓ | |-----------|---------------------| | 220 | 0.426 A | | 216 | 0.973 A |
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions