Excel: Create scale with 2 known points

2

Hello,

I have a problem - which I believe to be much more mathematical than a formula in Excel.

I have a list with percentages of results and I need to "stagger" those values according to two known points.

o MINIMUM VALUE = 25 POINTS

o MAXIMUM VALUE = 99 POINTS

and there all the values between must be staggered according to these two references.

I know if it was only the Maximo value (or just the minimum) - a rule of three would be enough to stagger everything.

ex:

MAXIMUM VALUE = 54% = 99 POINTS.

then to 50% - in a three-rule - 91.67 points.

the formula being:

X = (99 x 50) / 54

My question is how to achieve the scale if we have tb the MINIMUM VALUE ..

for example

MAXIMUM VALUE = 54% .... 99 POINTS

MINIMUM VALUE = 12% .... 25 POINTS

How many points are worth 42%? 23%?

I swear I'm burning the cunt .. kkkkk

Thank you Daniel

    
asked by anonymous 23.06.2017 / 14:52

2 answers

0

I could not quite understand your question, but from the looks of it, perhaps a plausible solution is to bring your values first to 0. Its minimum value is currently 25, if 25 is the minimum I understand it would be 0%. Its maximum value is currently 99, if 99 is the maximum I understand it would be 100%. To facilitate the accounts you could set the minimum value to 0, so did: minimum - 25 = 0 maximum - 25 = 74

Subtract 25 from all values calculate the percentages, finally you can do the reverse calculation adding 25.

    
23.06.2017 / 19:23
0

So you have two scales:

Points:

25 Pontos - 99 Pontos, sendo seu centro 66 Pontos e seu range 74 Pontos (99 - 25 = 74)

Percentage:

12%-54%,sendoseucentro33%eseurange42%(54-12=42)

Nowthinkabouthowmuchwouldbe25%onthepointscale?Wecannotsimplydivide62(50%)by2,thecorrectonewouldbetoget62-25=37anddivide37/2-18,5andplacingonscalewouldbe:

25+18,5=43,5.

Sofarsogood.

  

Howmuchis25%inthePointsscale

Let'susetheRangeofpointstosimplifytherulecalculationsof3.

(74*25)/100=18,5-Ruleof3between74(range)25(porcentagem)

This18,5representswhenitshouldbeaddedfromthe25Pointstoreach25%withinthescale,thatis43.5Points.

  

Calculating other values

Quanto 45% na escala de porcentagem reflete na de pontos.

First you convert 45% within your range, into the Range:

Maketherule3:

(33*100)/42=78,57

Havinghowmany%iswithinyourrange,younowtransferthe%totheotherscale:

(74*78,57)/100=58,14

Asstatedabove,youaddthistotheminimumvaluetohitwithinthescale.Inthecase25Pontos+58,14Pontos=83,14Pontos

I think that's it. :)

    
26.06.2017 / 14:58