I am working with some questionnaire data. Up to this point, I have been working with regression coefficients to determine that a one unit change in A leads to x 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 change in B. I have the scale mean and SD 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. Is there an Excel function(s) that can map the percentile rank scale (0-100) onto the coefficient values based on the questionnaire scale (1-7)? I hope I explained everything clearly. Thanks for your time!