What is LowerLimit?
Hi everyone,
I am a newbie here and apologize if this post is in the wrong forum.
I need help to solve the following LogNormal Conditional expectation equation for MuNew such that:
(e^(MuNew + Sigma^2/2)*normcdf((-log(LowerLimit)+MuNew+Sigma^2)/Sigma))
/
(1-logncdf(LowerLimit, MuNew, Sigma)) - Severity = 0.0001
normcdf = Standard Normal cumulative distribution function. Hence Mu = 0, Sigma =1
logncdf= Lognormal cumulative distribution function
Is there any pros out there that can help me?
Thanks!!
Br, Magnus
What is LowerLimit?
I don't have emotions and sometimes that makes me very sad.
So all the parameters but MuNew are fixed known quantities?
I don't have emotions and sometimes that makes me very sad.
Solver in Excel should be able to do this kind of thing. Otherwise if you move everything to one side equation then ultimately you're just looking the zeroes/roots of the resulting expression and most math/stats packages have root solvers easily available. Are you using any particular software for this?
I don't have emotions and sometimes that makes me very sad.
I mean I don't think there is a closed form solution for what you want so any method to solve will be iteration based. With matlab I wouldn't think you would need to explicitly write out the loops by hand though.
I don't have emotions and sometimes that makes me very sad.
Tweet |