Question

Module 9 q4

A study comparing four personal computers resulted in the following pairwise comparison matrix for the performance criterion: 1 2 3 4 1 1 1 6 9 1 1 1 5 N 6 5 1 3 1 7 46 5 7 1 (a) Determine the priorities for the four computers relative to the performance criterion. (Round your answers to three decimal places.) computer 1: computer 2: computer 3: computer 4: (b) Compute the consistency ratio. (Use RI = 0.90. Round your answer to three decimal places.) Are the judgments regarding performance consistent? Since CR is G--Select--- 0.10, the individual's judgements are ---Select--

Please put answers in BOLD. Will Upvote.

Answer 1

Please refer to the soluttion below:

XI - Book1 - Microsoft Excel File Home Insert Page Layout Formulas Data Review View O x I AutoSum Calibri 11 AA Wrap Text General H Fill % Cut E Copy Paste Format Painter Clipboard BI U А Merge & Center $ % +.0 .00 .00 0 Insert Delete Format Clear Conditional Format Cell Formatting as Table Styles Styles Sort & Find & Filter - Select Editing Font Alignment Number Cells 026 A B C D E F G L K N M O - Р Q R 1 2 1 2 3 3 1 6 9 1 4 H J SYNTHESIZED MATRIX 1 2 3 0.1374 0.4918 0.4091 0.0229 0.0820 0.2273 0.0153 0.0164 0.0455 0.8244 0.4098 0.3182 2 1 5 2 4 1/6 1/5 1/7 1 1 1/2 1 1/6 1/9 6 72/7 4 0.1104 0.1325 0.0946 0.6625 Average 0.2872 0.1162 0.0429 0.5537 Priority Vector 5 3 4 1 1/5 5 12 1/5 3 4 6 7 7 SUM 22 8 9 1 2 10 1 B3/B7 B4/B7 B5/B7 B6/B7 2 C3/07 C4/C7 C5/C7 C6/07 3 D3/D7 D4/D7 D5/D7 D6/D7 4 E3/E7 E4/E7 E5/E7 E6/E7 11 3 4 12 13 a) 0.287 0.116 14 Computer 1 Computer 2 Computer 3 Computer 4 15 0.043 16 0.554

XI - Book1 - Microsoft Excel File Home Insert Page Layout Formulas Data Review View O x I AutoSum * Cut Ea Copy - Calibri 11 AA Wrap Text General H Fill Paste BI U А Merge & Center - $ - % +.0 .00 .00.0 Insert Delete Format Format Painter Clear Conditional Format Cell Formatting as Table Styles Styles Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Cells Q41 1 J K L M N 0 Р 0 R Weighted Sum Matrix 1.463 + * 9 + 0.5537 * 5 0.489 1/6 1/5 1/7 1 wool 1 0.177 7 3.158 3.158/0.5537= 5.7034 A B С D E F G H 17 b) 18 0.2872 1 0.1162 6 + 0.0429 19 1/6 1 20 1/9 1/5 21 6 5 22 23 Dividing all elements of the weighted sum matrix by their respective priority vector element, we get 24 25 1.463/0.2872= 5.0939 0.489/0.1162= 4.2137 0.177/0.0429= 4.1265 26 27 We then compute average of these values to obtain Amax 28 Amax= 4.7844 29 30 CI= (Amax-n)/(n-1) 0.2615 here, n=4 Cl is consistency Index 31 32 CR= CI/RI 0.2905 CR is consistency Ratio 33 34 Since CR is greater than 0.1, the individual's judgments are not satisfactory 35 36 37 RI= 0.9 38 39