+ Reply to Thread
Results 1 to 4 of 4

Standard deviation with multiple criteria

  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    Copenhagen, Denmark
    MS-Off Ver
    office 365
    Posts
    2

    Standard deviation with multiple criteria

    Hi everyone,
    Hope you can help me. I have attached a small example illustrating my problem. I am trying to calculate the standard deviation from the data in the value column. However, I want to discriminate between the samples (three different sample no. and also I want to deine which date I want to include. For an example I would like to calculate the standard deviation for samples with sample number: 1461101 between 5 - 8 august. I have managed to calculate the standard deviation discriminating between sample number using an array formula, but I havent managed to "include" date range in my formula. Hope you can help.
    sincerely
    Thomas
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,945

    Re: Standard deviation with multiple criteria

    How about using the DSTDEVP formula?

    See attached for detail on how Criteria is defined.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,125

    Re: Standard deviation with multiple criteria

    With the 3 criterias is in F1,F2,F3:

    Please Login or Register  to view this content.
    **Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
    Attached Images Attached Images
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-18-2020
    Location
    Copenhagen, Denmark
    MS-Off Ver
    office 365
    Posts
    2

    Re: Standard deviation with multiple criteria

    Thank you both for a very quick reply and awesome excel skills!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula DB.DEV.ST for calculate the deviation standard with criteria
    By Ron78 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2018, 05:49 AM
  2. [SOLVED] Standard Deviation with Lookup Criteria
    By StratVar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-28-2017, 08:55 PM
  3. [SOLVED] Standard deviation based on multiple criteria in a separate column
    By sstyre in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-19-2014, 11:59 AM
  4. Standard Deviation Using Multiple Criteria
    By T86157 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2014, 09:57 PM
  5. how do you find the SD(standard deviation ) for the multiple reg
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  6. [SOLVED] how do you find the SD(standard deviation ) for the multiple reg
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  7. how do you find the SD(standard deviation ) for the multiple reg
    By Basem Salman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1