Body voltage testing â also called skin voltage testing â is the most sensitive, accurate and helpful method available to detect electric fields. This is a very important measurement, especially for sensitive individuals.
An outlier can be created by a shift in the location. (mean) or in the scale (variability) of the process. Though an observation in a particular sample might be a. candidate as an outlier, the process might have shifted. Sometimes, the spurious result is a gross recording. error or a measurement error.
Here is the complete formula to test if value 1 (A2) is an outlier: (QUARTILE(A$2:A$16,3)-QUARTILE(A$2:A$16,1))))). To use this formula in your own Excel spreadsheet, you must: 1  Replace the cell value (A2) with the first data value in your range.f the first value in the data set is larger than the Upper Bound or smaller than the Lower Bound then it's an outlier. Use the Excel OR function to compare the first value to the Upper Bound and Lower Bound at the same time.