Lognormal Probability Distribution in Excel 07

[VigCS]

Hello all. First post here and I'm looking for a little bit of help .

I've started on a project for a Prob & Stat class I have and I'm stuck trying to figure out how to display a lognormal probability distribution on a Histogram.

In the attached .xlsx on sheet "C1 HIST" you can see the random variable seeds, the loginv to get the full numbers (column C), the BIN I used for the histogram, and my attempt at the "lognormaldist" values. On sheet 3 you an see the actual commands I used to generate the numbers. I don't think I'm using the "lognormaldist" properly because the values in Column E of "C1 HIST" keep going up instead of spiking up quickly and then coming back down.

Toward the bottom of this sheet you can see what an add-in called "EasyFitXL" shows the lognormal distribution to be, but I'd like to know how to do it without an add-in.

I also attached the project statement (I'm trying to do the probability distribution part of step 2 of "Progress Report 1". Right now I'm just trying to figure out everything for Random Variable C1, and once that's done, the rest will be easy. You can also see the distribution type, CV, and Mean on the table in the .pdf (seen at the upper right of sheet "C1 HIST").

If you guys have any help/input it's be greatly, greatly appreciated.

Thanks so much!

[VigCS]

Sorry for double posting, but I seemed to figure my number problem out at least. Now I'm just trying to figure out how to add a probability curve on top of a bar chart. Any ideas?

Haha, thanks!