Lognormal in VBA

  • Thread starter Thread starter DaviesL
  • Start date Start date
D

DaviesL

I'm trying to find a lognormal fuction for MS Access so I can . I can
see the built-in one in Excel but I don't want to have to use an Excel
app in my code just to use this worksheet function.

I can find the VBA code for a normal distribution function but I want
to find a coded version of the lognormal function.

Does anybody have any ideas where I can find one?

Cheers
Lee
 
DaviesL said:
I'm trying to find a lognormal fuction for MS Access so I can . I can
see the built-in one in Excel but I don't want to have to use an Excel
app in my code just to use this worksheet function.

I can find the VBA code for a normal distribution function but I want
to find a coded version of the lognormal function.

Does anybody have any ideas where I can find one?

Cheers
Lee
Click to expand...

Did you try putting the natural logarithm of the values into the normal
distribution code? See:

http://mathworld.wolfram.com/LogNormalDistribution.html

Watch out for non-positive values -- they don't have logarithms, at
least not real ones.

James A. Fortune
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generating random lognormally distributed numbers 1
Lognormal base in charts (excel 2007) 2
Generating lognormal distribution 1
Generating random lognormal distribution 3
Generating lognormal equity returns 2
Generate a lognormal distribution 1
WorksheetFunction Class - Random values from LogInv needed 5
How do I model a Paretian Distribution in Excel? 4

Back
Top