Page 248 - The Six Sigma Project Planner

To calculate the weight for each item, we must obtain the grand total for the entire
matrix and then divide the row totals by the grand total. This procedure, called
normalizing, is shown below:

B C D E F
A
1 Attribute A B C D E Total Weight
2 A-Easy to learn 0.00 4.00 1.00 3.00 1.00 9.00 26.2%
3 B-Easy to use 0.25 0.00 0.20 0.33 0.25 1.03 3.0%
4 C-Connectivity 1.00 5.00 0.00 3.00 3.00 12.00 34.9%
5 D-Compatible 0.33 3.00 0.33 0.00 0.33 4.00 11.6%
6 E-Easy to maintain 1.00 4.00 0.33 3.00 0.00 8.33 24.2%
7 Grand Total 34.37

These results are shown in the figure below.

Category Importance Weights
40%
34.9%
35%
30%
26.2%
24.2%
25%
Weight 20%

15%
11.6%
10%
5% 3.0%
0%
A-Easy to learn B-Easy to use C-Connectivity D-Compatible E-Easy to
maintain
Compare these weights with those obtained by the exact analysis using Expert Choice
2000.
Exact Spreadsheet
Category
Weight Weight
Easy to learn 26.4% 26.2%

Easy to use quickly after I’ve learned it 5.4% 3.0%
Internet connectivity 35.8% 34.9%
Works well with other software I own 10.5% 11.6%
Easy to maintain 21.8% 24.2%

231