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

Does anyone know which function to determine 1 and 2 standard deviation?
The STDEV does not specific any number.
Thank you
Eric
  #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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,670
Default Which function to determine 1 and 2 standard deviation?

Thank you very much
Eric
Reply
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 06:57 PM.

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"