Excel

How to Find a Z-Score in Excel

How to Find a Z-Score in Excel

In order to find a z-score in Excel, you will need to use the function =ZTEST(). This function takes two arguments: the first is the value that you want to test, and the second is the number of standard deviations you want to use. So, for example, if you wanted to find the z-score for the value of 45, you would use the function =ZTEST(45,1).

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.