If I input data as “<5", the database knows to interpret this as not detected with a detection limit of 5? And then will calculate statistics based on 1/2 of the detection limit for this value?
A. Yes, but you have to tell it to do so. I assume you are using the Universal Importer in ChemPoint to convert your data. In that case, you have to tell the Universal Importer that non-detects are indicated by the presence of a “<" symbol. After the data are in ChemStat, you can specify whether you want to represent non-detects by 0, 1, 1/2 DL, or DL.
Related Questions
- If the detection limits between different sets of data are varying, does the database set the detection limit as one value, or does it vary with the sample data set?
- How do I pre-populate input fields with data retrieved from a database?
- Where does the database store data that I input into the database?
