The purpose of using descriptive statistical methods is to summarize a set of data by certain characteristics, e.g., by the value of the mean, median, or standard deviation, and to draw some basic conclusions and generalizations about the dataset.
To calculate descriptive statistics for the data collected in the datasheet, open the
Descriptive statistics window via menu
In this window, we select the variable to be analysed and the analysis settings and select the descriptive statistics measures we are interested in. You may select individual statistics or groups of statistics by clicking on the . Confirm the selection by pressing
OK. The result of the analysis will be in a report attached to the datasheet for which the analysis was performed.
In addition, if you want the data to be visualized with a box-and-whisker chart, then in the
Descriptive statistics window select the
Measures of central tendency are so-called average measures that characterize the average or typical level of a trait's values.
Arithmetic mean is expressed by the formula:
where is the consecutive values of the variable and is the sample size.
The arithmetic mean is used for interval scale. For a sample it is taken to be denoted by and for a population by .
Trimmed mean - is determined as the arithmetic mean calculated after removing from the sample a given percentage of the smallest and largest measurements, e.g. if we cut off 5 per cent of the measurements, it means that we cut off 2.5 per cent of the largest and 2.5 per cent of the smallest values. At the same time, if the number of measurements to be removed obtained from the conversion is not an integer, it is rounded down to the nearest whole number.
Winsor mean - is determined as the arithmetic mean calculated after replacing the appropriate percentage of extreme measurements with the smallest and largest value that remains of the reduced set of values. If we choose to calculate the Winsor average by pruning, say, 5% of the measurements, then those discarded 5% will be replaced by the smallest and largest value determined from the remaining 95% of the measurements. As with the pruned average, when converting the percentage of values to be replaced to the number of measurements to be replaced does not result in an integer, then we round down to the nearest integer. Geometric mean is expressed by the formula: This mean is used for the interval scale, when the variable has a log-normal distribution (the logarithm of the variable has a normal distribution).
Harmonic mean is expressed by the formula: This mean is used for the interval scale.
In an ordered data set, the median is the value that divides the data set into two equal parts. Half of all observations are below and half are above the median.
The median can be used in interval and ordinal scale.
Mode is the value that occurs most frequently among the measurements obtained. Fashion can be used at any measurement scale.
Quartiles (, , ) divide the ordered series into 4 equal parts, deciles (, ) into 10 equal parts and centiles (percentiles: , ) into 100 equal parts. The second quartile, fifth decile, and fiftieth centile are equal to the median. These measures can be used in the interval and ordinal scale.
Central tendency measures knowledge is not enough to fully describe a statistical data collection structure. The researched groups may have various variation levels of a feature you want to analyse. You need some formulas then, which enable you to calculate values of variability of the features.
Measures of variability are calculated only for an interval scale, because they are based on the distance between the points.
where are values of the analysed variable
where are the lower and the upper quartile.
Ranges for a percentile scale (decile, centile)
Ranges between percentiles are one of the dispersion measures. They define a percentage of all observations, which are located between the chosen percentiles.
Variance measures a degree of spread of the measurements around arithmetic mean
where are following values of variable and is an arithmetic mean of these values, n - sample size;
where are following values of variables and is an arithmetic mean of these values, - population size;
Variance is always positive, but it is not expressed in the same units as measuring results.
Standard deviation measures a degree of spread of the measurements around arithmetic mean.
The higher standard deviation or a variance value is, the more diversed is the group in relation to an analysed feature.
The sample standard deviation is a kind of approximation (estimator) of the population standard deviation. The population standard deviation value is included in a range which contains the sample standard deviation. This range is called a **confidence interval ** for standard deviation.
Coefficient of variation, just like standard deviation, enables you to estimate the homogeneity level of an analysed data collection. It is formulated as:
where means standard deviation, means arithmetic mean.
This is a unitless value. It enables you to compare a diversity of several different datasets of a one feature. And also, you are able to compare a diversity of several features (expressed in different units). It is assumed, if coefficient does not exceed 10%, features indicate a statistically insignificant diversity.
Standard errors they are not measures of a measurement dispersion. They measure an accuracy level, you can define the population parameters value, having just the sample estimators.
Standard error of the mean is defined by:
On the basis of a sample estimator you can calculate a confidence interval for a population parameter.
Skewness or asymmetry coefficient in other words
This measure tells us how data distribution differs from symmetrical distribution. The closer the value of skewness is to zero, the more symmetrically around the mean the data are spread. Usually the value of this coefficient is included in a range [-1, 1], but in the case of a very big asymmetry, it may occur outside the above-mentioned range. A positive skew value indicates that the right skew occurs (the tail on the right side is longer), whereas the negative skew indicates that the left skew occurs (the tail on the left side is longer). Skewness is defined by:
the following values of a variable,
, adequately - arithmetic mean and standard deviation ,
Kurtosis or coefficient of concentration
This measure tells us how much the spread of data around the mean is similar to the spread of data in normal distribution. The greater than zero the value of kurtosis is, the more narrow the tested distribution than normal one is. And inversely, the lower than zero the value of kurtosis is, the flatter the tested distribution than the normal one is. Kurtosis is defined by:
the following values of a variable,
, adequately - arithmetic mean and standard deviation of ,
EXAMPLE (fertilisers.pqs file)
In an experiment related to a soil fertilising the with various sorts of microbiological specimens and fertilisers it was calculated how many microorganisms occur in a 1 gramme of dry mass of soil. Now we would like to calculate descriptive statistics of the amount of actinomycetes for the sample fertilised with nitrogen. Additionally, we want the data to be illustrated in the Box-Whiskers plot. In a datasheet, we select only the 54 first rows, which are relevant to the assumptions of the analysis (there are actinomycetes fertilised with nitrogen). Then we open
Descriptive statistics window in
In the window of descriptive statistics options, select a variable to analyse: the number of microorganisms, and then all the procedures you want to follow (for example arithmetic mean altogether with the confidence interval, median, standard deviation altogether with the confidence interval, and an information about the skewness and kurtosis of distribution altogether with errors). At the top of the window you should see the following message:
Data limited by the selected area
. To add a graph to the report, we select
Add graph option and chose the Box-Whiskers plot type. Confirm your choice by clicking OK and you get the result in a report: