Exhibit 14.9 The Following Questions Are Based on the Information Below

question 51

Short Answer

Exhibit 14.9
The following questions are based on the information below.
An investor is considering 4 investments, W, X, Y, and Z. The payoff from each investment is a function of the economic climate over the next 2 years. The economy can expand or decline. The following payoff matrix has been developed for the investment decision problem.
-Refer to Exhibit 14.9. Assume the formula =MAX(B5:C5) was entered in cell D5 and copied to cells D6:D8. What formula should go in cell E5 and get copied to cells E6:E8 to place a "<==" to indicate the choice according to the maximax decision rule?

---

Definitions:

Total Row

A row at the end of a table or spreadsheet that automatically calculates and displays the sum, average, or other statistical data for a column of numbers.

Query Datasheet

A tabular view displaying the results of a database query, allowing for data analysis and interaction.

Group of Records

A collection of related data entries in a database or spreadsheet that share common attributes.

Find Unmatched Query Wizard

A tool in database management systems that helps users find records in one table that have no corresponding records in another table.