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:

enter image description here

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:

enter image description here

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:

enter image description here

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 ;)

  • 1
    $\begingroup$ I recommend using survey methodology and factor analysis, which can be bolstered with qualitative data if you so wish. $\endgroup$ – Jay Schyler Raadt Dec 12 '19 at 12:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.