+ Reply to Thread
Results 1 to 2 of 2

select certain data values from non-uniform distributed data table

  1. #1
    Registered User
    Join Date
    08-29-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    17

    Question select certain data values from non-uniform distributed data table

    Dear all,

    I need to get a range of data values which greater or equal to 1 for a particular year and months (group), hence to calculate the 95 percentile of this data value range.

    I got a very large data size and my data not everyday of the month got value, not uniformly distributed for days of the month.

    Im not sure you all understand what Im trying to find. Here, I attached the sample workbook. Hope you can understand my question better.

    Any ideas and help will be appreciated. Thanks in advance. cheers!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103

    Re: select certain data values from non-uniform distributed data table

    Not certain I completely understand, but does this help get you what you are looking for?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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