I have some percentage values in my excel spreadsheet like:
When i use the STDEV function to calculate the standard deviation with these values, i get 0,125. How should i interpret this? Is it +- 0,125% or +-12,50%?
$\begingroup$
$\endgroup$
Add a comment
|
1 Answer
$\begingroup$
$\endgroup$
You should interpret it as 12.5%.
The percentage values that you are seeing in your spreadsheet (93.33%, ...) are only formats, internally Excel is dealing with decimal point numbers (.9333, ...) so the result of the standard deviation will be in the same scale: .125 -> 12.5%
