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!