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

    Trying to plot a normal distribution

      Hello,

       

      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.

       

      PalletIDCoilIDCoilWeight
      11100
      1250
      23200
      1490
      35100

       

      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