How to Convert Between Z-Scores and Percentiles in Excel ...
www.statology.org › convert-z-scores-percentiles-excelMar 30, 2020 · For example, here is how to convert a z-score of 1.78 to a percentile: It turns out that a z-score of 1.78 corresponds to a percentile of roughly 96.2. In plain English, this means a data value that has a z-score of 1.78 is larger than roughly 96.2% of all other data values in the dataset. 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: