91影视

Beer's law states that through the sample and the concentration of the absorbing species, the absorbance is proportional to the path length.

$\mathrm{A}=\mathrm{蔚产颁}$

A is the absorbance,$\mathrm{蔚}$is the molar absorptivity,b is the length of light path, C is the concentration.

Make a spreadsheet,

Calculatevalues using Beer鈥檚 Law,

$鈭�=\frac{\mathrm{A}}{\mathrm{b}-\left[\mathrm{standard}\right]}$

Thus, Column can be calculated by using the formula,

$\mathrm{A}=鈭�\mathrm{x}鈥�\mathrm{b}鈥�{\left[\mathrm{X}\right]}_{\mathrm{guess}}+鈭�鈥�\mathrm{b}鈥�{\left[\mathrm{Y}\right]}_{\mathrm{guess}}$

Hence, in cell D10 and D11 we know the values.

Take the concentration is0.001 M for each compound.

Thus, we calculated column G and column H.

Calculate the sum in columnH8.

Use the solver to calculate the concentration of unknown and highlight the cellH8.

Select data tab$鈫�$Solver and enterH8 in Set Objective.

Select the min button and in by Changing Variables enterD10 and D11.

Thus, solving method should be GR G nonlinear.

Hence, set Constraint Precision to a small number such as1E-12.

Therefore, by clicking solve, the values appears in the cell D10 andD11.

Thus, the concentration of each species in the mixture is.

$\left[{\mathrm{MnO}}_4\right]=8.32路{10}^{-5}\mathrm{M}\left[{\mathrm{Cr}}_2{\mathrm{O}}_4\right]=1.78路{10}^{-4}\mathrm{M}.$