Pass variable to NORMINSV function to get only mean value

[Guest]

Does anyone now how to pass variables to a NORMINSV Function so that I only
the mean value is calcualted. I have a model which I want to run in both
deterministic and stochastic mode. When in is stochastic model I want to do
the usual:

Nominsv(RAND(), mean, std) = Stochastic outcome

But I also want to run the model in deterministic mode so that I can use the
same formula to do the following:

Nominsv(RAND(), mean, std) = Mean

Using a RAND() of 0 does not work. Using a std of 0 does not work.
I know I can simply wrap an IF around it IF(a1 = Deterministic, Mean,
Nominsv(RAND(), mean, std)).

But I was hoping I could simply pass a variable to the function an avoid an
IF stmt.

Any ideas?

Thanks

EM

 

[Mike Middleton]

EM -

There is no English-version Excel worksheet function named either NORMINSV
or Nominsv.

If you're referring to NORMINV, it returns the mean when the cumulative
probability (your RAND() argument) is 0.5.

But I don't know what you mean by "pass a variable to the function," which
is language sometimes used with programming languages. Please clarify.

- Mike
www.mikemiddleton.com

 

[Guest]

If you are not asking for either the NORMINV or NORMSINV function, try
rewriting your question more coherently.

Jerry

 

[Guest]

Sorry for for the confusion. Yes I mean the NORMINV function. Assume the
following:

A1 = 5 (mean)
A2 = .2 (Std)

In A3 I have the following formula:

=NORMINV(RAND(),A1,A2)

Effectively A3 wil return a value which changes everytime I calc. I was
hoping that I could turn the stochastic nature of the calc off without using
an If stmt. I know I can do the following with a flag in A4 which says
either "Deterministic" or "Stochastic":

=IF(A4 = "Deterministic", A1, NORMINV(RAND(),A1,A2))

I was hoping that I could avoid the IF stmt outside the NORMINV altogether
and put it inside A2. Or use a Ran() of zero. The goal being to force the
function to calc the mean value (A1) without any dispersion around it (i.e.
no std).

Thanks

EM