Open Side Menu Go to the Top
Register
z-score equation? z-score equation?

10-22-2009 , 10:15 PM
My brain hit a block. Without using the normal distribution table, is there an equation that will give me the number of standard deviations away from the mean (z-score?) given the desired confidence interval?

For example, I want to be able to type in 95% and have it return 1.96. 90% would return 1.67. 99% would return 2.58.
z-score equation? Quote
10-22-2009 , 10:33 PM
Since the normal pdf is not an integrable function, there is no exact closed form solution. The book Abramowitz and Stegun, Handbook of Mathematical Functions, National Bureau of Standards 1970 has a polynomial approximation.

If you have Excel, you can use the following:

If the two sided confidence level is stored in cell C1, then

Z = NORMINV(1-(1-C1)/2,0,1)

BTW - Z for 90% is 1.645
z-score equation? Quote
10-22-2009 , 11:23 PM
Sweet, thanks. I'm using this in excel so that's perfect.
z-score equation? Quote

      
m