I am trying to fit a lognormal distribution with 3 points on the cumulative distribution function [start at 0,0; 60th percentile equal to 100 and 92nd percentile equal to 234]. I need to determine the parameters mu and sigma so that i can then simulate from this distribution but I can't seem to find any function in excel VBA that will allow me to do this. I don't have any sample mean or variance (only these 3 points on the graph). I know if it possible using other software but I need to be able to do this in Excel.
Does anyone know how this could be done? Any suggestions would be appreciated!
Does anyone know how this could be done? Any suggestions would be appreciated!