How to Calculate Probability from Z-Score in Excel (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

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
  • 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.

Estimate Mean Value of Dataset to Calculate Probability from Z-Score

  • 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.

Evaluate Standard Deviation to Calculate Probability from Z-Score

  • 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.

Determine Z-Score Value to Calculate Probability from 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.

Determine Z-Score Value to Calculate Probability from Z-Score

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

Determine Z-Score Value to Calculate Probability from Z-Score

  • 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.

Calculate Probability from Z-Score Value for Each Case

  • 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.

Calculate Probability from Z-Score Value for Each Case

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

Calculate Probability from Z-Score Value for Each Case

  • 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


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo