How can I make a range (0, 1) for related dataset/objects/rows

Akib Rahman

New Member
I have some data containing 6 different types of values. They are,
1. ID means the main ID
2. sub_ID means the subsection/part of the ID
3. orig_content means the amount in milligram (mg) they have originally stored in this ID,
4. orig_min means the minimum amount in milligram (mg) they can store in this ID
5. orig_max means the maximum amount in milligram (mg) they can store in this ID
6. orig_unit the real unit (100g) to calculate the orig_content, orig_min, and orig_max of the ID
7. the percentage I have to calculate!
Now, is it possible to calculate the percentage or proportion (range from 0 to 1) of the sub_ID based on the orig_content, orig_min, orig_max, and orig_unit? For example, I would like to explore the sub_ID which has a strong influence and week influence on the ID.

Dataset example is given below:
Code:
    ID    sub_id    orig_content    orig_min    orig_max    orig_unit        percentage

4    1         1146             332        1960      mg/100 g

4    2         17.25             5            29.5      mg/100 g

4    3         0.0111            0.0037        0.0185      mg/100 g

6    1         3.4             3.4        3.4          mg/100 g

6    2         0.0039             0.0002        0.0076      mg/100 g

6    3         0.01925         0.0005        0.038      mg/100 g

6    4         0.0705             0.001        0.14      mg/100 g

6    5         208.25             35            381.5      mg/100 g

9    1         546.75             81            1012.5      mg/100 g

9    2         938.25             139        1737.5      mg/100 g

9    3         1.2             0.2        2.2          mg/100 g

9    4         324             48            600          mg/100 g

11    1         495.25             491        499.5      mg/100 g

11    2         824.05             817        831.1      mg/100 g
Any general or mathematical or statistical procedure to calculate the percentage? Any kind of suggestions is appreciable.