# How to get the Z value in Excel

I am trying to practice the exercise for this lesson, How I can get the Z value in Excel?

1 answers ( 0 marked as helpful)

In Excel, the formula for calculating the Z-value looks as follows:

=NORM.INV(1 - (1-confidence_interval)/2)

Here, confidence_interval represents the desired confidence interval (in decimal form). For example, if you want to obtain the Z-value for a 90% confidence interval, the formula would be:

**=NORM.INV(1 - (1-0.9)/2)**

Or, if you want to obtain the Z-value for a 95% confidence interval, the formula would be:

`=NORM.INV(1 - (1-0.95)/2)`

PS: I don't have Excel on my computer, so I can't guarantee 100% accuracy. However, if you're calculating in Google Sheets (which I have access to), the formula is very similar:

**=NORM.S.INV(1 - (1-0.9)/2)**