+ Reply to Thread
Results 1 to 3 of 3

Summarize Data Help

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

    Summarize Data Help

    Ok so I have over 11 years (attached example just part of the data) of monthly returns and quintiles for companies. I've quintiled the companies out by month then I matched up the companies returns for those periods (starting in column AL). I'm trying to figure out a way to easily summarize this data. I want to see what the returns are of the companies over different time periods based on what quintile they are in. I thought maybe I could use multiple pivot tables based on the same data but am struggling to do that. Any help would be much appreciated!

    Cheers
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Summarize Data Help

    Your data organization doesn't especially lend itself to pivot table analysis. Can you be a little more specific about this: "returns are of the companies over different time periods based on what quintile they are in" Do you want to see some sort analysis of returns for companies in Quintile 1 through all available months? Something like that? Here is one example.
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

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

    Re: Summarize Data Help

    Sorry for the confusion. I guess what I want to be able to do is look across the different time periods to see how many companies are driving the performance in the different quintiles. So for instance in one period if say 65% of the companies in the 1st quintile had positive performance and an average return of say 12%, but the 5th quintile also had 65% of the companies in it report positive performance but a lower average performance say 5%, I'd want to quickly be able to see what companies were driving that higher performance in the 1st quintile. I hope that helps Thanks for your help!

+ 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. How to summarize 30mins interval raw data directly to Yearly/Annual Data
    By dedark05 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2016, 01:45 AM
  2. [SOLVED] Summarize Data by Name
    By bigroo1958 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-22-2016, 10:46 PM
  3. Looking for help to summarize data
    By hp801 in forum Excel General
    Replies: 4
    Last Post: 02-02-2014, 08:59 PM
  4. Summarize Data
    By Kumara_faith in forum Excel General
    Replies: 9
    Last Post: 07-02-2013, 06:02 AM
  5. [SOLVED] Is it possible to summarize this data?
    By Bandicoot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2013, 08:55 AM
  6. Summarize data
    By blstone in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-11-2005, 06:06 PM
  7. Summarize Data Set
    By Jim in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-07-2005, 11:06 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