Pass variable to NORMINSV function to get only mean value
 

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

Pass variable to NORMINSV function to get only mean value
 

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

"ExcelMonkey" wrote in message
...
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

Pass variable to NORMINSV function to get only mean value
 

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

Jerry

"ExcelMonkey" wrote:

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

Pass variable to NORMINSV function to get only mean value
 

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






"Jerry W. Lewis" wrote:

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

Jerry

"ExcelMonkey" wrote:

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