View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default WorksheetFunction Class - Random values from LogInv needed

It's been way too long since my last stats course.

But maybe someone will chime in.

leebean337 wrote:

Hey,

v1=8500 (mean)
v2=3000 (sd)

I figured out the first part of the problem, that being that my values
are too large and excel can't handle the resulting figures.

Also, when I change v1=ln(8500) and v2=ln(3000) I end up with a result
(and even a decent one!)

But I'm still concerned that I'm not actually suppose to modify my
specified mean and sd. What do you think?

Thanks

--
leebean337
------------------------------------------------------------------------
leebean337's Profile: http://www.excelforum.com/member.php...o&userid=31099
View this thread: http://www.excelforum.com/showthread...hreadid=507712


--

Dave Peterson