NTLOGNORMMEAN
Returns mean of a specified log normal distribution.
Syntax
NTLOGNORMMEAN(
- M,
- S
)
Parameters
- M is a parameter of the distribution .
- S is a parameter of the distribution .
Example
- The example may be easier to understand if you copy it to a blank worksheet
How to copy an example- Create a blank workbook or worksheet.
- Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
- Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
1 2 3 4 5 A B Data Description 13.5 Value of parameter M 31 Value of parameter S Formula Description (Result) =NTLOGNORMMEAN(A2,A3) Mean of the distribuion for the terms above
See also
- NTRANDLOGNORM
- NTLOGNORMDIST
- NTLOGNORMINV
- NTLOGNORMKURT
- NTLOGNORMMOM
- NTLOGNORMPARAM
- NTLOGNORMSKEW
- NTLOGNORMSTDEV
- Log Normal distribution