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)