View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aiyer[_67_] aiyer[_67_] is offline
external usenet poster
 
Posts: 1
Default Can we compute CDF value from a given std. normal?


Hi all!

I am Aun and I work for Vtec corp. Had a quick question.

I did rank the values for a certain a random variate and computed th
CDF (1/N+1) and computed the std. normal values (normsinv(cdf)), i
Excel.

But, I was wondering if there would be a way I could do the reverse
where I can get the CDF values, given the std. normal values & the no
of observations (N).

Thanks in advance guys.

Regds,
Arun

--
aiye
-----------------------------------------------------------------------
aiyer's Profile: http://www.excelforum.com/member.php...nfo&userid=607
View this thread: http://www.excelforum.com/showthread.php?threadid=27466