-1
As a beginner in Excel, I’m having difficulties to use a function that I believe is the solution to what I want, the function (SE).
The thing is, I have a sum of values that start at 54 and go to 317. I want to divide these values into 8 (eight) classes that remained like this: from 54 to 86 from 87 to 119 from 120 to 152 from 153 to 185 from 186 to 218 from 219 to 251 from 252 to 284 and from 285 to 317.
To these classes I gave "weights", type weight 1 up to weight 8. I would like Excel to identify which class belongs to classify in the weight I determine, example 54 to 86 equal to weight 1.
These values ranging from 54 to 317 come from the results of the mega sena, that is, the sum of each ten drawn. The smallest sum (54) is the sum of a contest where the sum of the ten gave this value, as well as the value 317.
– Luís Avelino Avelino
These sums are next to each drawn contest. I’ve classified them that way, into classes, to see which ones come out the most and the frequency at which they occur. I could not understand how to apply the function you spoke. (procv)
– Luís Avelino Avelino
Right, but which part is your doubt?
– Andre.Santarosa