We want to solve this problem using Excel. There are two ways to approach it (easily). In this second method, we will look at the matrix method: (The first method is to use circular references)
Two substances, A and B, absorb light according to the Beer-Lambert law A = ecL where e is the extinction coefficient, c is the concentration of the absorbing substance and L is the path length (0.1 dm). If both species are in solution and the absorbance at 300 nm is measured to be 3.5 and the absorbance at 500 nm is 2.3, use simultaneous equations to calculate the concentrations of A and B in the mixed solution. The extinction coefficients, e are:
* At 300 nm, e(A) = 80; e(B) = 150 units
* At 500 nm, e(A) = 52, e(B) = 100 units.
We want to solve this problem using Excel. There are two ways to approach it (easily). In this first method, we will look at the circular references method: (The second method is to use matrices)
Two substances, A and B, absorb light according to the Beer-Lambert law A = ecL where e is the extinction coefficient, c is the concentration of the absorbing substance and L is the path length (0.1 dm). If both species are in solution and the absorbance at 300 nm is measured to be 3.5 and the absorbance at 500 nm is 2.3, use simultaneous equations to calculate the concentrations of A and B in the mixed solution. The extinction coefficients, e are:
* At 300 nm, e(A) = 80; e(B) = 150 units
* At 500 nm, e(A) = 52, e(B) = 100 units.
This resource explains the background to and illustrates the use of the van’t Hoff equation. Along with some details on how it can be used, there are a number of questions to try, with some hints if you need them.
Details of the resource:
some parts of this file have audio, but it is not necessary to use this if you do not have an audio source
Derivation of the van’t Hoff to two forms – one for use in experimental analysis via graphs and one for use algebraically
How to use the van’t Hoff equation to understand how temperature changes affect a reaction
Some questions to try with video/picture tips and hints
This resource sumamrises the derviation and use of integrated rate equations in kinetics. Three examples of integrated rate equations are given (zero, first and second order) along with some worked examples and questions to try. Click on the image to access the resource:
Details of Resource:
Demonstrations and downloadable PDFs of the derivations for zero, first and second order equations
Questions with demonstrated worked examples to show you how answers were obtained
This resource provides information on the principles of the ANOVA test and how to carry it out in MS Excel. A worked example is given, along with screen videos on how to use Data Analysis in Excel. There are some questions for you to test your knowledge. Click on the image to access the resource:
Details of Resource:
Background to the ANOVA test and how it is carried out manually
A glossary of terms involved in ANOVA accessible through the top menu bar
Videos of how to conduct the test in Excel
A worked example showing how the test is performed and results analysed
