**Z-Score** is a parameter using which we can calculate the value of probability. Excel contains some formulas by which we can easily estimate the value of the Z-Score. In this article, we are going to show the steps of how to calculate probability from Z-Score in Excel elaborately. If you are also curious to know about it, download our practice workbook and follow us.

## What is Z-Score?

**Z-Score** is a special type of value that indicates how far the value is from the mean. The general formula for the Z-score is:

Here,

**Z**represents the value of the Z-score**XÂ**is the value of any case**Âµ**stands for the mean value**Ïƒ**represents the value of the Standard Deviation

**Read More:** How to Calculate Z Score in Excel

## What Is Probability?

Probability represents the possibility of occurring any events with respect to the total number of events. The mathematical expression of probability is:

## How to Calculate Probability from Z-Score in Excel: with Quick Steps

To demonstrate the process, we consider a dataset of **10** students of a school. The names of the students are in column **B** and their examination marks are in column **C**. The procedure to calculate the value of probability from the** Z-score** is given below:

### Step 1: Estimate Mean Value of Dataset

In this first step, we will calculate the **Mean** value of our total marks number. For that, we are going to use **the AVERAGE function**.

- At first, select cell
**F5**. - Now, write down the following formula in the cell.

`=AVERAGE(C5:C14)`

- Press
**Enter**.

- You will get the value of the mean of our dataset.

Thus, we can say that we have completed the first step, to calculate probability from the Z-score in Excel.

### Step 2: Evaluate Standard Deviation

Now, we are going to estimate the **Standard Deviation** of our dataset. To determine the value, we will use the** STDEV.P **function.

- First, select cell
**F6**. - After that, write down the following formula in the cell.

`=STDEV.P(C5:C14)`

- Press the
**Enter**key.

- You will get the value of the standard deviation.

So, we can say that we have finished the second step to calculate probability from the Z-score in Excel.

### Step 3: Determine Z-Score

Here, we are going to evaluate all the values of the **Z-score**. The general expression of the Z-score shown above, tells us the parameters required to determine the value.

- At the beginning of this step, Insert a
**Column**between columns**C**and**D**. - Then, rename the column as
**Z-Score**.

- After that, select cell
**D5**and write down the following formula in the cell. Make sure that you put the**Absolute Cell Reference**for cells**G5**and**G6**.

`=(C5-$G$5)/$G$6`

- Press
**Enter**.

- Now,
**double-click**on the**Fill Handle**icon to copy the formula up to cell**D14**.

- You will get all the values of
**Z-Scores**for our datasheet.

In the end, we can say that we have accomplished the third step to calculate probability from the Z-score in Excel.

### Step 4: Calculate Probability for Each Data

This is the final step of our calculation. Here, we will estimate the value of probability from the value of Z-Score. To calculate the value of probability, we are going to use the** NORM.DIST **function. The process is given below step by step:

- First, Insert a
**Column**between columns**D**and**E**. - After that, rename the column as
**Probability**.

- Now, select cell
**E5**and write down the following formula for the cell. Make sure that you put the**Absolute Cell Reference**for cells**H5**and**H6**.

`=NORM.DIST(C5,$H$5,$H$6,TRUE)`

- Then, press
**Enter**.

- Next,
**double-click**on the**Fill Handle**icon to copy the formula up to cell**E14**.

- Finally, you will get all the values of probability.

At last, we can say that we have finished the final step to calculate probability from the Z-score in Excel.

**🔍 Interpretation of the Result**

We are illustrating the result for cell **E5**. The value of probability is **0.664**. The value means that the possibility of happening that event is **0.664** with respect to the total number of events.

**Read More:** How to Calculate P Value from Z Score in Excel

**Download Practice Workbook**

Download this practice workbook for practice while you are reading this article.

## Conclusion

Thatâ€™s the end of this article. I hope that this article will be helpful for you and you will be able to calculate probability from Z-score in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations. Keep learning new methods and keep growing!

## Related Articles

- How to Calculate Critical Z Score in Excel
- How to Calculate Altman Z Score in Excel
- How to Calculate Z-Score with 95 Confidence Interval in Excel

**<< Go Back to Z Score in Excel | Statistical Significance in Excel | Excel for StatisticsÂ |Â Learn Excel**