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 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
This resource considers the basic statistic terms and shows how to calculate them, both manually and using Microsoft Excel. There is a worked example and an example for you to try. Click on the image to access the resource.
Details of Resource
This resource contains:
A glossary of basic statistical terms including how they are calculated and what they are useful for
A worked example for each of the basic statistical functions mean, standard deviation and variance, with short videos on how to compute these functions in Microsoft Excel
A short quiz for you to try out to test that you can perform these calculations
