Which function to determine 1 and 2 standard deviation?

E

Eric

Does anyone know which function to determine 1 and 2 standard deviation?
The STDEV does not specific any number.
Thank you
Eric
 
D

David Biddulph

If you want 1 standard deviation, use STDEV(); if you want 2 standard
deviations, use =2*STDEV()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Sortino Ration (Downside Deviation) 7
Standard Deviation and Averages based on criteria 2
Does anyone know if excel has a function to calculate standard er. 1
Standard deviation and bell curve 0
How to Create an S-Curve from Custom Field? 0
Geometric Standard Deviation 11
Calculating STDEV and other Calcs based on another cells value 3
How to calculate 2 standard deviation? 1

Top