Question: how to calculate z value for 95 confidence interval in excel?
Answer: Originally Answered: How do I calculate z values suitable for 90, 95 and 99% confidence intervals in Excel? use the command =normsinv(probability) and it will give you the confidence coefficient. Make sure you are using the alpha/2 value for the probability. For example, the alpha for 95% is 2.5% or .