I am trying to create a scoring system to show how contaminated a sample is.My aim is for the formula to yield one overall score, to indicate how "concerning" a sample is, i.e. the more it is contaminated, the more concerning it is - let's call this overall score the "Concern Index", CI. The CI could be on a min-max scale of 0-100, and anything that's over 100 could just be designated 100+.
Each of the chemicals has a government issued "allowed limit" ("AL), i.e. an amount of chemical that can be present in a sample, without being of concern to human health, and above which is of concern.
So for a single chemical test, it might make sense to make a simple percentage. However, for each sample we will will test for 400 chemicals. Most of the 400 chemicals will come back as 0 detected. But some usually come back as detected and a concentration (amount detected, "AD") is given.
The best result I can imagine is that none of the 400 chemicals is detected. The realistic "worst case" result might be that 10 chemicals are detected, all at 100% of the allowed limits. In reality though, we often get a distribution of results, for example:
I feel the formula needs to additive in that if two chemicals are detected at 30% of AL, this would get a more higher score, than one chemical at 30%.
I feel however that it should not be a case of just adding the percentages, I mean adding the numbers 30+30=60 (I realise this is not how you add percentages, but I don't know how to describe this). The reason I think this is because if in SampleX we have Chemicals A,B,C,D, E and F detected at 40%,25%,20%,15%,10% and 5%, NONE of the chemicals have exceeded the allowed limit set by the government and therefore should not be of concern by themselves, yet the food is getting a rating of 100+, which indicates it has failed.
Perhaps the addition of each of theses could be weighted in some way, so each additional chemical detected does increase the overall score, but as long as none of the chemicals individually go over 100% of of the AL for that substance, then the overall score, CI, won't go over 100. This is just a suggestion, but I don't know how to write this formula.
My idea would be to use the rank, so for the 1st rank 100% of the %AL is considered, 2nd rank less (f2), and 3rd rank even less (f3). So, for example:
CI = %AL1 + %AL2(f2) +%AL3(f3) f2= 100-%AL1 f3=f2-((%AL2*f2)/100) fn=fn-1-((ALn-1*fn-1/100)
So for SampleX CI = 67 + (8f2) + (7f3) f2 = (100-67)/100 = 0.33 f3= .33 - ((8*f2)/100) = 0.3036 And CI = 67 +(8*0.33) + (7*0.3036) = 71.77, or 72.
As you will note from the above, I am not much of a mathematician, but I would appreciate comments on this proposed approach and any suggestions to improve it. Thank you.