I have some percentage values in my excel spreadsheet like:

enter image description here

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%?


1 Answer 1


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%


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.