+ Reply to Thread
Results 1 to 2 of 2

Standard Deviation of Returns Help

  1. #1
    Forum Contributor
    Join Date
    06-16-2014
    Location
    Columbia, Maryland
    MS-Off Ver
    2013
    Posts
    134

    Standard Deviation of Returns Help

    Ok so I have 591 companies that I have broken out into quin-tiles (1-5). In Column "C" I have each companies 12 month forward return as of that date and then in column "D" I have the companies Quintile rank for that period. What I want to do is in Column "H" calculate the standard deviation of returns for each Quintile. Now usually I would just use STDEV.S, but I'm not sure how to get that formula to only pick up the individual companies returns in the specific quintiles. Any help would be much appreciated

    Cheers!
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,551

    Re: Standard Deviation of Returns Help

    Hi,

    As an array formula in H2 (entered with Ctrl-shift-enter), then copied down.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Calculating Returns and Standard Deviation from a data sample of share prices.
    By ofhani in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2016, 11:51 AM
  2. Standard Deviation, Portfolio Returns Shortcuts
    By davidvanpatten in forum Excel General
    Replies: 2
    Last Post: 06-16-2015, 03:49 AM
  3. Standard Deviation IF
    By pickslides in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2014, 12:46 AM
  4. calculating annualised returns + Standard deviation of returns
    By Jaspal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2013, 09:22 AM
  5. standard deviation
    By Rony Das in forum Excel General
    Replies: 1
    Last Post: 06-30-2007, 05:40 AM
  6. Standard Deviation
    By Stan Banner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2006, 09:00 PM
  7. Standard Deviation
    By Stan Banner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2006, 05:15 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