Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

LOGINV(probability,mean,standard_dev) returns the inverse of the lognormal distribution

Input the formula: =LOGINV(0.06, 5.6, 1.4). Press Enter to get the result. Referenced from Excel Help