View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Larry Webb Larry Webb is offline
external usenet poster
 
Posts: 4
Default Need help reversing a formula...

Rob Bovey wrote:
Hi Larry,

My statistics are pretty rusty, so I have no idea if this is
meaningful, but solving for Z algebraically gives you:

Z = (NORMSINV(1-X/2)*Y/Answer)^2


Yeah, that's it. Don't know why I couldn't see that for myself.

Too few brain cells left and not enough sleep I guess.

Thanks!


Larry