

 Thread Tools  Search this Thread 
#1
 
 
I need help to find second standard deviation in Microsoft Excel
Does anyone have any suggestions on how to find the second standard deviation. For the first S.D., which is STDEV(a1:a20). Does anyone have any suggestions. Thanks in advance for any suggestions. 
#2
 
 
Re: I need help to find second standard deviation in Microsoft Excel
The standard deviation measures variation about the mean. Two standard deviations is just twice the standard deviation: =2*STDEV(A1:A10). I suspect you may mean 2 standard deviations which is simply standard deviation * 2. In a normal distribution 95.45% of the data points would be within 2 standard deviations. 
#3
 
 
Re: I need help to find second standard deviation in Microsoft Excel
So then you would have the results in an EXCEL spreadsheet drinstehen probably like this:

#4
 
 
Re: I need help to find second standard deviation in Microsoft Excel
As far as I can understand everything, there have also tried the same with my values. However, now get the message is "# NUM!". Actually, this sheet should be designed so that when I enter a value in the table is counting Smart Controller (to serve as a template for a statistical spreadsheet). Currently I have 6 values in the table and keeping the message as saying. When I further complete table, which is expected after a few entries. Must be considered in the formula yet? I have the entire field entered for computation, but only 6 values. I would be happy about a new support very much. 
#5
 
 
Re: I need help to find second standard deviation in Microsoft Excel
Look the formula is: = STDEV (Here are the data in the column or row you wish to insert THE DEVIATION). You can select it directly with the mouse. 

Tags: microsoft excel, microsoft office, office application, spreadsheet, standard deviation 
Thread Tools  Search this Thread 

Similar Threads for: "I need help to find second standard deviation in Microsoft Excel"  
Thread  Thread Starter  Forum  Replies  Last Post 
Need help to Annualize a standard deviation in Excel  Saddys  MS Office Support  2  17022012 07:06 PM 
How to convert the Standard Time to Military Time in Microsoft Excel  Anita Bath  MS Office Support  2  25012012 06:59 PM 
What is the way to calculate standard error in Microsoft Excel  Edha  MS Office Support  4  24012012 04:06 PM 
How to find Hidden Text Box in Microsoft Excel  Lanka Boy  MS Office Support  2  14012012 03:07 PM 
Is it possbile to calculate RSD ( relative standard deviation) in Mircosoft Excel  KalaK  Windows Software  4  05012012 03:40 PM 