+ Reply to Thread
Results 1 to 2 of 2

Standard deviation of a large columne of data with 2 parameters applied

  1. #1
    Registered User
    Join Date
    01-23-2020
    Location
    Essex, England
    MS-Off Ver
    2016
    Posts
    1

    Standard deviation of a large columne of data with 2 parameters applied

    Hello,
    I understand there is not a formula for std.if,
    I am currently trying to build a tool to measure standard deviation of a column of data on a different sheet but only if it meets 2 parameters in the same row.

    For example I have already calculated average ifs

    =AVERAGEIFS(Data!$O13:$O40000, Data!$I13:$I40000, C9, Data!$P13:$P40000,$E$2)

    Where Column O is the data I am looking to get average and std of, Column I is a parameter of 1-24 but is jumbled data, Column P is a number 1-3
    basically trying to calculate the avg and std of
    setting 1 - 1
    setting 1 - 2
    setting 1 - 3
    setting 2 - 1

    etc up to
    24-3

    Any help is greatly appreciated.

    Thanks.

  2. #2
    Registered User
    Join Date
    12-26-2019
    Location
    seoul, south korea
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Standard deviation of a large columne of data with 2 parameters applied

    Fisrt i recommend excel's pivot table.
    If you want a formula, see below.

    Press Ctrl, Shift, Enter key

    standard deviation
    =stdev(if((Data!$I13:$I40000=C9)*(Data!$P13:$P40000=$E$2),Data!$O13:$O40000))

+ 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. [SOLVED] Standard Deviation malfunction when there is no data variation
    By greyhounddd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-05-2019, 05:41 PM
  2. Standard deviation of a subset of the data
    By jfinnegan0 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2018, 01:08 AM
  3. [SOLVED] Populate Data set on Mean Standard Deviation and Correlation
    By sajeel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2014, 04:24 AM
  4. Standard deviation and Skweness of time series data
    By rjerung in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2012, 02:19 AM
  5. Data with fixed mean and standard deviation
    By Klorgrodan in forum Excel General
    Replies: 2
    Last Post: 02-10-2009, 10:23 AM
  6. [SOLVED] Median, Average, and Standard Deviation from large set of data
    By Humberto Goyen in forum Excel General
    Replies: 6
    Last Post: 11-30-2005, 08:40 PM

Tags for this Thread

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