+ Reply to Thread
Results 1 to 2 of 2

convert unit change to percentile rank change

  1. #1
    Registered User
    Join Date
    11-13-2006
    Posts
    2

    Question convert unit change to percentile rank change

    I have been working with Excel formulas to manipulate regression coefficients to determine that a one unit change in A leads to x unit change in B. What I now like to do is look at percentile rank change - to see when one moves from the 50th percentile to the 60th percentile in A, it leads to x unit change in B. I have the scale mean and standard deviation for A and B and have been trying the NORMDIST and NORMINV functions, but I cannot get it to map on properly based on the z-score and the regression coefficient for the one unit change I previously computed. For example, the change in B when I move A from the 50th percentile to 84th percentile should equal the standard deviation - but I cannot get that change to replicate when converting to percentile rank. Is there an Excel function(s) that can map the percentile rank scale (ideally 0-100, but I will take +/- 2 SD) onto the coefficient values based on the questionnaire scale (1-7)? I hope I explained everything clearly. Thanks for your time!

  2. #2
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517

    Not sure if I can help

    My statistics are very old and rusty so I'm afraid I don't understand exactly what you are trying to do.

    However there are two functions :
    PERCENTILE(array,k) and PERCENTRANK(array,x,significance)
    that might be working in the area you want.

    Mark.

+ 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