Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please i need the excel file Pane 2- Debbie Gibson is considering three investment options for a small inheritance that she has just received -
please i need the excel file
Pane 2- Debbie Gibson is considering three investment options for a small inheritance that she has just received - stocks, bonds, and money market. The return on her investment will depend on the performance of the economy, which can be strong, average, or weak. The returns for each possible combination are shown in the following table: Investment Strong Average Weak Stocks 12% 6% -10% Bonds 7% 4% 1% Money market 4% 3% 2% Assume that Debbie will choose only one of the investment options. a) Which investment should Debbie choose if she uses the maximax criterion? b) Which investment should Debbie choose if she uses the maximin criterion? c) Which investment should Debbie choose if she uses the equally likely criterion? d) Which investment should Debbie choose if she uses the criterion of realism with a = 0.52 e) Which investment should Debbic choose if she uses the minimax regret criterion? Page 2 of 2 405 words LE Filme Home insert Draw Page Layou Arial v 10 ' ' == ab & Wrap Text Paste yv a.A Merge & Center $ E11 4 Xv fx B D E F G H K L M N 1 2 PAYOFFS 3 Alternatives 4 Stocks 5 Bonds 6 Money Market Outcomes (a) MaxImax (b) Maximin (c) Equally Likely Strong Average Weak Maximum Choice Minimum Choice Average Choice (d) Hurwicz Realism Choice Outcomes Minimax Strong Average Woak Maximum Choice 8 9 REGRET 10 Alternatives 11 Stocks 12 Bonds 13 Money Market 14 15 10 17 18 19 20 21 22 23 24 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started