Permutation Combination

[nilesh.parekh]

Hi there,

I have an excel where I have a 10 variables. Each variables have multiple attributes. Each attribute is assigned a weightage. I want to find all the possible outcomes of the sum of all variables on applying the permutation combination of all the attributes. This will give me 2.2 Mn outcomes.

Since reviewing these many would be difficult, can we get the synopsis of how many outcomes fall under various ranges.

The details of the variables, attributes and the weightage is provided in the attached file in the sheet named variables.
The details of the synopsis tableis provided in the attached file in the sheet named synopsis.

Regards,
Nilesh

[ragulduy]

Well as an estimate, you will have close to 0% in 226 to 500 and then probably not far away from 50/50 between the other two.

Edit, trying to me more accurate, I think:
0 to 125: 49.475%
126 to 225: 50.52%
226+: 0.005%