How to smooth data in my charts

[JK1234]

It is hard to compare the different data sets. I did add a trend line but it does not color/fill in the data.

Is there a better way smooth out the data in the bell curve.

Goal is to compare them. Also, I do not like the way it goes past zero either.

[shg]

Don't particle sizes tend to have a lognormal distribution?

[JK1234]

Yes they do.

I know the trend is not, but matches the actual data closer than the log trend

[shg]

Tied up now, but will try to post an example of extracting a best-fit lognormal distribution to the data later.

If no one else does in the meanwhile ...

[JK1234]

Thanks....

[shg]

JK, I am struggling to use your data with all the zero amounts in the data. I'll let you know if I make some progress.

[JK1234]

okay, thanks for trying

[JK1234]

Any luck yet???

[JK1234]

I tried this addin but it locks up my pc??

http://www.quantdec.com/Excel/smoothing.htm

thought it may help, not sure as I cant use it for some reason

[shg]

OK, I punted on a closed-form solution.

Here's a log-normal distribution fitted to one of your series using Solver.

[JK1234]

wow -

Thank you (As always)

You da man!! Great work.

[JK1234]

Curious:

How did you generate the values (.2524 and -.6557).

I think I understand the rest. Good stuff.

[shg]

Tools > Solver. The model is set up.

[JK1234]

I got it....
Thanks!!!!!!!!!!!

[shg]

You're welcome. Would you please mark the thread as Solved?

Edit: BTW, the macro in there is from some other log-normal stuff, and not used for your data. You can delete it.