I picked (1+B9) to avoid he denominator coming close to zero if the variance
gets close to zero.
--
Gary''s Student - gsnu200810


"prabhat" wrote:

Why is B9/(1 + B10) .. and not B9/B10 .. also, is there a way to plot a graph
of expected value vs variance.

"Gary''s Student" wrote:

Consider combining the variables:

If the expected rate of return in is B9
and
the variance is in B10
then in another cell enter:
=B9/(1+B10)

and use Solver to maximize this cell.
--
Gary''s Student - gsnu200810


"prabhat" wrote:

I want to maximize one value (expected rate of return) and minimize another
value (variance) at the same time. Is there a way to find an optimum value
rather than just finding either the maximum value of expected return, or
finding the minimum value of variance.

Is it possible to generate a table for a range of values ? Is it possible to
generate a graph of expected return vs variance.

Thanks,
Prabhat