Excel pivot table index option

Refer to the concept of expected value and joint probability. Its the neutral independent value. You divide the Observed with the Expected value. In simple terms there are total 6 values in your table excluding totals. So, if you distribute 6 across 6 cells equally then each cell is 1, as the constrain is that the grand total will be 6. Relative importance is got by solving the question "How can i distribute 6 across the 2x3 table such that the row total comes to 2 and column total comes to 3 and the value should reflect the proportion of actual value. You will arrive at the formula (Row Total x Column Total)/Grand Total . Divide the actual value in the cell with the ideal proportional value , you get the index. For example 1.02+0.95+1.01 will give you 3 and 0.98+1.05+0.99 will give you another 3. 3+3=6. Thus index has solved the question "How can i distribute 6 across the 2x3 table such that the row total comes to 2 and column total comes to 3 and the value should reflect the proportion of actual value.