Results 1 to 4 of 4

Thread: Need help with my calculation on 95th and 50th percentiles

  1. #1

    Need help with my calculation on 95th and 50th percentiles



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello i am new to excel, i need help with my calculation, im not too familiar with the syntax and the percentile function. My calculation calculates every percentile in 'Group', but i dont want it to, i need it to calculate every percentile in each subgroup (ID) in each 'Group'. Can someone please point me in the right direction ?Copy of Copy of EXAMPLE1 (2).xlsx

  2. #2

  3. #3

    Unhappy Question ?

    I have an issue with the table1 and table2 name managers, i cannot access the Refers to =sheet!1!$L$4:$O$12 ,It seems as if they are suppressed/locked. Also how did you get excel to find the address of GROUP ? i see the @Group. But in the excel spreadsheet im working on it doesnt let me format it the way you have it.

  4. #4
    For learning purposes, don't try to modify your spreadsheet, but enter your data into my spreadsheet.
    All my data is in the form of "Tables" with "Structured References".
    I'm not using obsolete $A$1 or R1C1 references.
    For "Tables" tutorial see:
    http://office.microsoft.com/en-us/ex...956.aspx?CTT=1
    Also read up on "PivotTables"
    The learning curve should be several months/years.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •