Quantitative Analysis for Management, 13/e

Long description

A matrix for weight sum vector in column L of the spreadsheet with three rows:

• All the three rows read: equal to MMULT open parens B3 colon D5 comma J3 colon J5 close parens.

• The Ctrl, Shift, and Enter keys are simultaneously pressed to enter the MMULT function.

A matrix for Priority in column J with three rows:

• All the three rows read: equal to MMULT open parens G27 colon I29 comma J21 colon J23 close parens.

• The factor weights open parens J21 colon J23 close parens are multiplied by the individual factor evaluations to give the overall evaluations.

A consistency vector matrix with three rows under columns N, O, and P:

• The first column of all the three rows reads: equal to L21 colon L23 / J21 colon J23.

• The second column of ...