msharma864512
Member
Hi,
I am trying to provide score to each entry on the basis of deviation from the mean. In this case, Column A represents the actual margin, and column B represents the average margin of their respective industries. So, I am looking for a way to provide score on the basis of deviation.
For e.g. in one case avg is 15.2%
So, higher the positive deviation, higher will be the score, and lower the negative valuation, lower will be the score.
I am trying to provide score to each entry on the basis of deviation from the mean. In this case, Column A represents the actual margin, and column B represents the average margin of their respective industries. So, I am looking for a way to provide score on the basis of deviation.
For e.g. in one case avg is 15.2%
So, higher the positive deviation, higher will be the score, and lower the negative valuation, lower will be the score.