LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 618
Default Which function to determine 1 and 2 standard deviation?

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

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
standard deviation Arne Hegefors Excel Discussion (Misc queries) 7 August 6th 06 01:12 PM
What is the function to calculate standard errors of the mean? Steph Excel Worksheet Functions 2 July 17th 06 02:44 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
feel that the STANDARD DEVIATION formula on Excel is incorrect !! Ganapati Hegde Excel Worksheet Functions 3 November 18th 05 04:09 PM
Formula to determine number of Standard Deviations based on % of population Paul D. Simon Excel Worksheet Functions 8 September 15th 05 03:08 PM


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"