For most measurements in analytical chemistry some form of calibration curve is required. The better the calibration the more accuracy and precise are the results that you can achieve.
When you run an analysis there is a procedure you need to follow to ensure you get the best data.
What the analyst expects from you…
What should you expect from the analyst…
From a laboratory scientist point of view, the water we drink it is dirty. In a laboratory we need get our water closer to the school ideal of H2O (pure water).
Before you chose a piece of equipment or experimental method you need to ensure that it can detect the thing you want to measure (analyte) in the concentrations present. For example, can your method detect 1ppb phosphate in sea water? If you can’t measure it then there is no point in making, or collecting, it!
While Excel is anything but ideal for use in statistical work it can do many amazing things. However, it can be quite opaque as to what is actually happening and difficult to find the correct function. For this reason I have picked out the key functions for the statistical analysis discussed here.