Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



I need help to find second standard deviation in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-01-2012
Member
 
Join Date: Oct 2011
Posts: 58
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.

Reply With Quote
  #2  
Old 24-01-2012
Member
 
Join Date: Jul 2011
Posts: 632
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.
Reply With Quote
  #3  
Old 24-01-2012
Member
 
Join Date: Jul 2011
Posts: 631
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:
  • First 7
  • Second 84
  • Third 41
  • Fourth 13
  • Fifth 10
It would be in the left column in the EXCEL column A and the right in B. More precisely, in cells B1 through B5. Thus you would have the formula if you want it less, write in cell B6: = STDEV (B1: B5)
Reply With Quote
  #4  
Old 24-01-2012
Member
 
Join Date: Jul 2011
Posts: 618
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.
Reply With Quote
  #5  
Old 24-01-2012
Member
 
Join Date: Aug 2011
Posts: 564
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 17-02-2012 08:06 PM
How to convert the Standard Time to Military Time in Microsoft Excel Anita Bath MS Office Support 2 25-01-2012 07:59 PM
What is the way to calculate standard error in Microsoft Excel Edha MS Office Support 4 24-01-2012 05:06 PM
How to find Hidden Text Box in Microsoft Excel Lanka Boy MS Office Support 2 14-01-2012 04:07 PM
Is it possbile to calculate RSD ( relative standard deviation) in Mircosoft Excel KalaK Windows Software 4 05-01-2012 04:40 PM


All times are GMT +5.5. The time now is 07:02 PM.