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

# 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

• ###### Trying to plot a normal distribution

If I understand you correctly then one way you can get this is by using a caculated dimension

fe:

Calculated Dimension:

=IF (CoilWeight < 51 , '0 - 50' ,

IF (CoilWeight  >= 51 and  CoilWeight <= 100,  '51-100',

IF (CoilWeight  >= 101 and  CoilWeight <= 150,  '101-150',

IF (CoilWeight  >= 151 and  CoilWeight <= 200,  '51-200',

'201 +'))))

Expression:

SUM(Quantity)

This calculated dimesion groups your Dimension.

Let me know if you get this to work, and if this is what you are looking for.

Good Luck,

Dennis.

• ###### Trying to plot a normal distribution

Thank you.