ExcelBanter - How to calculate 2 standard deviation?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to calculate 2 standard deviation? (https://www.excelbanter.com/excel-worksheet-functions/21702-how-calculate-2-standard-deviation.html)

How to calculate 2 standard deviation?

Pls advise how to can I calculate 2 standard deviation in Excel? The StDev
function only gives 1 standard deviation.
Thanks,
Li

JE McGimpsey

One way:

=2 * STDEV(rng)

In article ,
"Li" wrote:

Pls advise how to can I calculate 2 standard deviation in Excel? The StDev
function only gives 1 standard deviation.
Thanks,
Li

All times are GMT +1. The time now is 09:50 AM.