• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Number density distribution

J

Jayani

New Member
Dear All

Iam trying to get a smooth number density distribution for my 5 data sets. I have given it a go but I think I have chosen my bands incorrectly and therefore cannot achieve a smooth distribution. Please advice.

Best regards
Jayani
 

Attachments

  • number density distribution.xlsx
    91.7 KB · Views: 5
Jayani

Firstly, Welcome to the Chandoo.org Forums

A few issues

1. You have used 16 bands although your calculations say there are 15. Band 0 is a band
I think the formula in I13 is incorrect and hence should be
upload_2014-8-11_9-52-13.png

This creates an inconsistent set of band widths

2. The band widths are inconsistent,
upload_2014-8-11_9-50-37.png

Once you adjust the above the distribution chart changes to:
upload_2014-8-11_9-54-15.png

Does that help ?
 
You must log in or register to reply here.
Back
Top