The shape is determined only by the data itself.
Nonparametric approaches get more likely results because they do not constrain the model parameter distributions into some assumed shape like normal or lognormal. The papers above compare the strengths and weaknesses of parametric versus nonparametric approaches to population modeling. Pmetrics is a freely available software package, embedded in R. Why are you using something in Excel? I am not clear.
