close

Hi there

I am trying to create a function that will grab random values from a
given distribution (lognormal and beta in particular). I am currently
using the following code for lognormal:

dblValue = Application.WorksheetFunction.LogInv(Rnd(), v1, v2)

where v1 is my mean and v2 is my standard deviation. But each time I
try to run it, I get the error quot;Unable to get the LogInv property of
the Worksheet Function classquot;

Any suggestions?--
leebean337
------------------------------------------------------------------------
leebean337's Profile: www.excelforum.com/member.php...oamp;userid=31099
View this thread: www.excelforum.com/showthread...hreadid=507712

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄