+ Reply to Thread
Results 1 to 2 of 2

Standard deviation of a subset of the data

  1. #1
    Registered User
    Join Date
    11-06-2018
    Location
    California, United States
    MS-Off Ver
    MS Office 2007
    Posts
    1

    Standard deviation of a subset of the data

    I want a cell to calculate the standard deviation of a subset of the column below. The subset(s) is/are all of the values in that column that are between quartile(A:A,0) and quartile(A:A,1), ie. if you calculate the quartiles you have $280k and $386k. So I want a single cell to create an array or something with all the values in my column that are between those two numbers (which can change if more data is added so I want to keep that in function form--quartile()), and I want to take the standard deviation of that array.

    $280,000.00
    $300,000.00
    $302,000.00
    $350,000.00
    $375,000.00
    $397,000.00
    $440,000.00
    $460,000.00
    $510,000.00
    $529,932.00
    $585,000.00
    $600,000.00
    $620,000.00
    $621,333.00
    $718,952.00
    $800,000.00
    $986,000.00
    $1,300,000.00
    $1,493,000.00

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Standard deviation of a subset of the data

    Hi jfinnegan0. Welcome to the forum.

    With this quote in mind I suggest converting the data to a Table. If you are not familiar with tables they resize automatically to fit the data.
    (which can change if more data is added
    The formulas use table syntax (referencing field names rather than ranges).

    Array enter this formula. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ 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. Calculate Standard Deviation spread across N Tabs of Data in Workbook
    By scantor145 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2018, 11:42 PM
  2. [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
  3. [SOLVED] Computing monthly standard deviation from daily data
    By Quantopic in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-07-2014, 07:42 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

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