Statistical Functions

[Beth]

Is it possible to calculate CV% (Co-efficient Variation)

Thank you

 

[mate]

Try going to Tools, Addins, then adding the Data Analysis
Toolpack. The calculation you need is in there i believe

 

[Beth]

The Data Analysis Toolpack is checked – Where do I go from there?

 

[Harlan Grove]

Is it possible to calculate CV% (Co-efficient Variation)?

Depending on precisely how it's defined, either as =STDEVP(Rng)/AVERAGE(Rng) or
as =VARP(Rng)/AVERAGE(Rng)^2. Note that CVs are meaningful only for random
variables with nonnegative support and positive means.

 

[Jerry W. Lewis]

Out of curiosity, where have you seen CV defined as the square of the
usual definition (2nd formula)?

I would tend to use STDEV instead of STDEVP unless I had observed the
entire population.

Jerry

 

[Harlan Grove]

Out of curiosity, where have you seen CV defined as the square of the
usual definition (2nd formula)?

...

I don't recall specifics, but I believe it was in an actuarial or risk theory
article. I could be wrong.