Question: Using Excel Spreadsheet and formulas for this problem (make sure cell references are unique to your table). Provide all techniques practiced previously: five (5) techniques
Using Excel Spreadsheet and formulas for this problem (make sure cell references are unique to your table). Provide all techniques practiced previously: five (5) techniques for Decisions Making under Uncertainty, EMV, EOL, and EVPI. Use the attached Excel spreadsheet example (file name EXCEL Example 3-Spreadsheet for Decision Theory with All Formulas). Use = 0.7 for the Hurwicz. Submit the answers (on a separate sheet/tab) in the same Excel file with questions 4-5.
|
| STATE OF NATURE | |
| DECISION ALTERNATIVE | GOOD ECONOMY | POOR ECONOMY |
| Sotck market | 80,000 | -20,000 |
| Bonds | 30,000 | 20,000 |
| CDs | 23,000 | 23,000 |
| Probability | 0.5 | 0.5 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
