View Single Post
  #8   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

inv_normal is a more accurate implementation of NORMSINV. Use Harlan's
formula with either.

Jerry

Paul D. Simon wrote:

Thanks very much for your response, Jerry.

I tried the inv_normal function, but I couldn't figure out how to apply
it properly.

For example, the number of Standard Deviations for 68.3% is 1; for 95%,
it's 1.95996. When applying the inv_normal function to 68.3%, it gave
me an answer of 0.476104403489395. For 95%, it gave me an answer of
1.64485362695147. Obviously, I doing something wrong.