2 Replies Latest reply: May 8, 2012 2:52 AM by edstromp RSS

    Trying to plot a normal distribution



      I am trying to create a diagram showing the normal distribution of pallet weights in a machine.

      The weight of the pallets, which carry coils with unique ID's, are calculated as the sum of the coil weights as shown below.




      In the example above, PalletID 1 has a total weight of 240 (100+50+90).


      Now I would like to plot this table as a diagram with PalletWeight as X-axis and quantity as Y. Furthermore, I would like the X-axis to be presented as a couple of ranges; i.e. 0-50, 51-100, 101-150, 151-200 and so on.


      When I use PalletID as dimension of a bar chart and Sum(CoilWeight) as the expression, I get the pallet weights over palletID's, but I have no idea of how to get the normal distribution over some ranges of weights.


      Do you have an idea?


      Thank you