| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate 2 Standard Deviations
Michael -
If cell A1 has the standard deviation, e.g., =STDEV(data_range), then in some other cell enter =2*A1. - Mike www.mikemiddleton.com "Michael" wrote in message oups.com... Is it possible to calculate a figure for two standard deviations for a series of numbers? I have the output for 1 SD, but need 2 SDs. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to determine number of Standard Deviations based on % of population | Excel Worksheet Functions | |||
| Graph Standard Deviations | Excel Discussion (Misc queries) | |||
| Standard deviations in Excel | Charts and Charting in Excel | |||
| PivotTables in Excel 2004 calculate incorrect standard deviations | Excel Worksheet Functions | |||
| How to calculate 2 standard deviation? | Excel Worksheet Functions | |||
Hybrid Mode
