Skip to main content

COEFVAR function

Coefficient of variation function.

COEFVAR(range) computes the coefficient of variation of the contents of the cells in the specified range. The result is expressed as a percentage.

Coefficient of variation COEFVAR function$$ \text{CV(%)} = 100 \times \frac{\text{SD}}{\text{Mean}} $$

The argument range can be a list of numbers, cell addresses, cell ranges (such as A1:A10).

Range can also be a matrix. In that case the function returns a matrix with one row and the same number of columns, with each element the COEFVAR of the corresponding column. If range is a row matrix, it is converted to a column matrix first.

Calculator

COEFVAR 20

Related functions