How to calculate the Z score to percentile in Excel
Z-score is the numerical representation of the relationship of a value with the mean of a group of values. Z-score is measured with reference to standard deviations from the mean. A Z-score of 0 means that the data point is identical to the mean. A negative score means that the data point is below the mean and similarly a positive value means that data point is above the mean. Excel provides us with a built-in function. Before starting we would learn the syntax of formula.
=NORM.S.DIST(z,cumulative)
Z = z-score.
Cumulative = True returns the communicative distribution function, false returns the probability distribution function.
Below are the steps to follow;
Excel is a data oriented software produced by Microsoft. It is a data modeling application. Excel enables users to organize and manage data models of statistics in spreadsheets. In this tutorial, we will learn how to convert Z-score to percentile.
Step 1 – Select a cell and apply formula
– Select a cell, where you wish to calculate the percentile.
– Apply the formula, =NORM.S.DIST(z,cumulative)
– In this case the value for z is 1.56 in B4 cell.
– As soon as you press the enter key the percentile will be calculated. Below is the animation as an example to calculate Z score to percentile;
Resultantly, the value of percentile is 0.940. It turns out that z score of 1.56 corresponds to a percentile of 94.0 approximately.