Index calculating

  • Thread starter Thread starter Dace
  • Start date Start date
D

Dace

hello, I would like to get help from someone...I must get
an index (not a mean) from the scale 1 (positive) till 5
(negative) points. is there a specific formulas to do? I
know only one way with coefficients, but may be something
else?
Please HELP me!!! Thanx
 
Dace,

"Get an index from a scale" has no specific meaning: average, mean, minimum,
maximum are all possibilities. If you could indicate what output you want
given a certain input, then perhaps we could help, but otherwise....

HTH,
Bernie
MS Excel MVP
 
Bernie
thank you for replay...i will try to explain it better :)

if I have the estimation in 5 points scale (+/-) with
percents like this:


Q: like them very much "+" don`t like "-"
please estimate 45% 12% 13% 25% 5%
the taste for
theses
oranges

and I would like from these percents to get one
variable, soemthing like a mean (but no really), so one
of the ways is to do it with the coefficients like that:
(45x1)+(12x2)+(13x3)+(25x4)+(5x5)=233/100=2.33

but may be there is another way to calculate it, because
I heard that it could be done differently...
may be you can help me?

really thanks
Dace
 
Dace,

What you are describing is a weighted average, and can be done using
SUMPRODUCT:

=SUMPRODUCT({1,2,3,4,5},A1:E1)

where A1:E1 have your percentages.

To get a percentage, simply use

=SUMPRODUCT({1,2,3,4,5},A1:E1)/SUM({1,2,3,4,5})
=SUMPRODUCT({1,2,3,4,5},A1:E1)/15

If you want to easily change the weights ( the {1,2,3,4,5}part) then you
could also use cell references:

=SUMPRODUCT($A$10:$E$10,A1:E1)/SUM($A$10:$E$10)

where A10:E10 have your weights.

HTH,
Bernie
MS Excel MVP
 
thank you very much, I`ll try to do ti....
Dace


-----Original Message-----
Dace,

What you are describing is a weighted average, and can be done using
SUMPRODUCT:

=SUMPRODUCT({1,2,3,4,5},A1:E1)

where A1:E1 have your percentages.

To get a percentage, simply use

=SUMPRODUCT({1,2,3,4,5},A1:E1)/SUM({1,2,3,4,5})
=SUMPRODUCT({1,2,3,4,5},A1:E1)/15

If you want to easily change the weights ( the {1,2,3,4,5}part) then you
could also use cell references:

=SUMPRODUCT($A$10:$E$10,A1:E1)/SUM($A$10:$E$10)

where A10:E10 have your weights.

HTH,
Bernie
MS Excel MVP




.
Click to expand...
 
Back
Top