ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can we compute CDF value from a given std. normal? (https://www.excelbanter.com/excel-programming/315583-can-we-compute-cdf-value-given-std-normal.html)

aiyer[_67_]

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



All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com