Related Experiment Video
Updated: Aug 7, 2026

Development of New Methods for Quantifying Fish Density Using Underwater Stereo-video Tools
Published on: November 20, 2017
[Establishing endemic levels of ranges with computer spreadsheets]
Abstract:
Epidemics or disease outbreaks can be defined as an excess in the number of cases of a given health problem, in a particular population, period, and place. However, to determine what constitutes an excess implies knowing what is normal or to be expected. Establishing endemic levels or ranges makes it possible to determine figures for the number of expected cases and to show in graphic form the appearance of a higher number of cases. In this work a new methodology is described to develop these endemic ranges, in which the Quattro Pro (Qpro) and Excel software programs are used to calculate the geometric mean of historical rates and their confidence intervals. Also presented is a procedure for cumulative endemic ranges that facilitates surveillance of endemic events with a low incidence.
Related Concept Videos
Midrange
Simply put, the midrange is half of the data set’s range. Similar to the mean, the midrange is sensitive to the extreme values and hence the prospective outliers. However, unlike the mean, the midrange is not sensitive to all the values of the data set that lie in the middle. Thus, it is prone to outliers and...
Range
15.9; 16.1; 15.2; 14.8; 15.8; 15.9; 16.0; 15.5
Measurements of the amount of soda in a 16-ounce can vary since different subjects record these measurements or since the exact amount - 16 ounces of liquid, was not...
Overview of Microsoft Excel as a Data Analysis Tool
Common Leveling Mistakes and Errors
Microsoft Excel: Plotting Mean, SD, and SE
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...
Microsoft Excel: Median, Quartile range, and Box Plots
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which measures data spread, is...

