Calculate the mean of the values in a column of a data table.
The arithmetic mean of a set of values is calculated by summing the values together and dividing the result by the total number of values. The arithmetic mean is often used to summarise the central tendency of data but can be greatly skewed by outliers in the data.
This module has a trim parameter which symmetrically removes a proportion of the data from each end after ordering. This can be useful to remove a small set of outliers for the calculation where a central set of data are of interest. Other more robust statistics, such as the median, may also be of interest in these cases.
The standard deviation can also be calculated as a measure of how close values in the data tend to be to the mean. A low standard deviation indicates that values in the data tend to be close to the mean, while a higher standard deviation indicates that the data are spread over a larger range of values. A confidence interval can also be calculated for the mean if the data represent a sample of some larger population. The calculation for this confidence interval assumes the t-distribution.
The example below shows how to compute the arithmetic mean of CO2 uptake in plants using the Single Mean module. The output also includes standard deviation, standard error and the 95% confidence interval.
|test_var||Yes||Column Input: Numeric, Integer||The column with numeric values from which to find the mean.|
|trim||Yes||Decimal between 0 and 0.5||The proportion of observations to be trimmed from each end of the values in |
|remove_na||Yes||Boolean||Whether to remove missing |
|standard_deviation||Yes||Boolean||Whether to also calculate the standard deviation for the selected column.|
|confidence_interval||No||Decimal between 0.5 and 1||If specified then the standard error and a confidence interval will be calculated for the mean.|
|round_digits||No||An Integer between -10 and 10||The number of decimal places to round the result to. Negative values indicate rounding to powers of 10 e.g. -2 will round to the nearest 100.|