I'm developing a participatory social environmental diagnostic. To do this, I'm using primary (qualitative data from interviews with stakeholders) and secondary data (local socioeconomic data).
From this data, I distribute the identified factors in a SWOT matrix - identifying opportunities, strengths, weaknesses and threats that could afftect the local community. After that, each factor is given a scale from 0 to 2, being:
0 - Null or small impact 1 - Medium impact 2 - High impact
In this way, I have this kind of data:
Ok. Now I build a scale with this formula:
= (((strengths + opportunities) - (weaknesses + threats)) / ((strengths + opportunities) + (weaknesses + threats)) * 2
OBS: basically opportunities and strengths are positive values and threats and weaknesses are negative, so I subtract the negative values from the positive ones. The division by the sum of all values are made to have the statistical universe (population, in this case the maximum value). The multiplication by 2 are made to have the possibility to create a range from -200% to 200%, but it could be -100% to 100% too ;)
Now I have a scale ranging from -200% to 200% that I interpret in this way:
Very unfavorable (-200% to -100%) Unfavorable (-100% to -29%) Balance (-30% to 30%) Favorable (31% to 99%) Very favorable (100% to 200%)
OBS: This scale was used at this website (https://en.luz.vc/template/swot-analysis-excel-tool-template/)
Now, what I need is to convert this to 0 to 10 scale so I apply this formula:
I've discover this formula here: (Changing the scale of a variable to 0-100)
Finally, my question is how can I achieve this score (from 0 to 10) right from the beginning, without the need to make the conversion from the first scale?
OBS: The first scale give a percentage (-200% to 200%) and the second one a decimal number (0 to 10).
Warm regards ;)