Results 1 to 5 of 5

Thread: I need help to find second standard deviation in Microsoft Excel

  1. #1
    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.

  2. #2
    Join Date
    Jul 2011
    Posts
    642

    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. #3
    Join Date
    Jul 2011
    Posts
    638

    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)

  4. #4
    Join Date
    Jul 2011
    Posts
    627

    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. #5
    Join Date
    Aug 2011
    Posts
    568

    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.

Similar Threads

  1. Need help to Annualize a standard deviation in Excel
    By Saddys in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 07:06 PM
  2. Replies: 2
    Last Post: 25-01-2012, 06:59 PM
  3. Replies: 4
    Last Post: 24-01-2012, 04:06 PM
  4. How to find Hidden Text Box in Microsoft Excel
    By Lanka Boy in forum MS Office Support
    Replies: 2
    Last Post: 14-01-2012, 03:07 PM
  5. Replies: 4
    Last Post: 05-01-2012, 03:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •