Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ben
 
Posts: n/a
Default lognormdist function

What is the actual equation used for the lognormdist function (i.e. y = ...).
The excel help files do not provide the exact equation, instead only the
function syntax are explained. I have searched through several excel help
book and online and have not been able to find the actual equation
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Ben" wrote...
What is the actual equation used for the lognormdist function
(i.e. y = ...). The excel help files do not provide the exact
equation, instead only the function syntax are explained. I
have searched through several excel help book and online and
have not been able to find the actual equation


Online help for LOGNORMDIST is quite explicit that

LOGNORMDIST(x,m,s) = NORMSDIST((LN(x)-m)/s)

It's standard to define the density or distribution of log-transformed
random variables in terms of the untransformed density or distribution for
the log of possible values.

NORMSDIST is obscurely defined in terms of the normal density, which is the
derivative of the normal distribution. The normal distribution doesn't have
a closed form, meaning it can't be represented as a simple equation, only as
a definite integral. It's always derived numerically.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a ISWorkday Function -- Any Ideas Mark Excel Worksheet Functions 5 March 29th 05 01:58 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"