I have some data containing 6 different types of values. They are,
Dataset example is given below:
Any general or mathematical or statistical procedure to calculate the percentage? Any kind of suggestions is appreciable.
- ID means the main ID
- sub_ID means the subsection/part of the ID
- orig_content means the amount in milligram (mg) they have originally stored in this ID,
- orig_min means the minimum amount in milligram (mg) they can store in this ID
- orig_max means the maximum amount in milligram (mg) they can store in this ID
- orig_unit the real unit (100g) to calculate the orig_content, orig_min, and orig_max of the ID
- the percentage I have to calculate!
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