Explanation
The coefficient of variation measures the relative variability of data with respect to the mean.
It is sometimes called relative standard deviation (RSD).
The result is a decimal value, formatted with the percentage number format.
The calculated CV values show variability with respect to the mean more clearly.
In the first data series, the CV is nearly 50%.
In the last data series, the CV is only .12%.
STDEV.P calculates standard deviation using the “n” method, ignoring logical values and text.
STDEV.S Function
The Excel STDEV.S function calculates the standard deviation for a sample set of data.
STDEV.S replaces the older STDEV function, with the same behavior.
AVERAGE Function
The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers.
