Distribution: how setting a maximum value for the bin?

Question

Hello everybody,

I have a continuous variable with values between 0 and 100.

When I look at the Distribution platform, the last bin corresponds to the range [100 ; 110[ With this graphical representation we can believe that there are values higher than 100.

How can we change the axis settings so that the last bin would be [90 ; 100] ? I tried to change the maximum value but it doesn't fix the problem...

Thanks in advance for you help!

anne_sa · Answer

Hello Jim,

Thanks for your answer.

Using the labels is a good idea! Unfortunately I am not able to reproduce exactly what I want.

First I set the Value Labels so that the 100 values should be included in the last bin:

But  I still have an additional bin for the 100 values:

If I use then the hand tool, the first bin is associated to "0-10" and "10-20" values which is a bit confusing:

txnelson · Answer

I think you may be able to get what you want by using a combination of Value Labels with ranges and the Hand Tool.  I set the Value Labels to the bins that I wanted, and then used the hand tool to move the scale and bins to what I wanted......see below

anne_sa · Answer

Hello Karen,

Thanks a lot for your answer.

I also tried to play with the axis settings, however if you set the min to 0 and the max to 100 it will just hide the last bin. If you use then the handle tool to change the scale of the axis the last bin appears. Did I miss something?

Regarding the second part of your answer, I was not aware about the fact that the hand tool can be used to change where bins start. Playing with that tool allows indeed to get something very close to the expected results.

That is great to know, thanks!