How to Convert Between Z-Scores and Percentiles in Excel ...
www.statology.org › convert-z-scores-percentiles-excelMar 30, 2020 · How to Convert Percentiles to Z-Scores in Excel. We can use the following built-in Excel function to convert a percentile to a z-score: =NORM.S.INV(probability) where: probability = the percentile you’re interested in converting. For example, here is how to convert a percentile of 0.85 to a z-score: It turns out that a percentile of 0.85 corresponds to a z-score of roughly 1.036. In plain English, this means a data value located at the 85th percentile in a dataset has a z-score of 1.036.
Conversion table-percentiles to z scores.
https://www.cedu.niu.edu/~walker/statistics/Percentile to Z2.pdfPercentile : z Score : Percentile : z Score : 1st -2.41 : 26th -0.64 : 51st : 0.03 : 76th : 0.71 : 2nd -2.05 : 27th -0.61 : 52nd : 0.05 : 77th : 0.74 : 3rd -1.88 : 28th -0.58 : 53rd : 0.08 : 78th : 0.77 : 4th -1.75 : 29th -0.55 : 54th : 0.10 : 79th : 0.81 : 5th -1.65 : 30th -0.52 : 55th : 0.13 : 80th : 0.84 : 6th -1.56 : 31st -0.50 : 56th : 0.15 : 81st : 0.88 : 7th -1.48 : 32nd -0.47 : 57th : 0.18 : 82nd : 0.92 : 8th -1.41 : 33rd …