G
Guest
Is it possible to calculate CV% (Co-efficient Variation)
Thank you
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mate
Try going to Tools, Addins, then adding the Data Analysis
Toolpack. The calculation you need is in there i believe
Toolpack. The calculation you need is in there i believe
G
Guest
The Data Analysis Toolpack is checked – Where do I go from there?
H
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.
J
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
usual definition (2nd formula)?
I would tend to use STDEV instead of STDEVP unless I had observed the
entire population.
Jerry
H
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.