Turn in an Excel document that has the calculations for the following: A decision tree showing probabilities of rolling a die four times in Excel
Turn in an Excel document that has the calculations for the following: A decision tree showing probabilities of rolling...
A chance node on a decision tree has four possible outcomes each worth $100,000. The probabilities of the outcomes occurring are assessed as 10%, 27%, 43% and 20%. What is the expected value of this chance node?
please show excel calculations!
You should turn in your answers in ONE Excel document. Use financial formulas in Excel to show work for Requirement #1 and #5 of each part. An assignment submitted that doesn't demonstrate your formulas within Excel will receive an unsatisfactory grade. PART B Bill Corporation issued five-year, 6% bonds with a total face value of $1,000,000 on January 1, 2019. Interest is paid semi-annually on June 30 and December 31. The market rate of interest on...
Consider the following decision tree in which the probabilities are shown after each chance node and PW values are given for each terminal node. For full credit, you need to provide a detailed solution. (a) What decision should be made? (b) What is the expected value of the best decision? 0.2 - 05– 15.000 12.00 - 16.000 12.000 Pack 22 11.000 7 4 .000
A fair die has four faces numbered one to four. What is the probability of rolling a two exactly three times in ten rolls of the die?
Compute the probabilities of the following events: -rolling a 6 on a six sided dice -drawing a single card it being a either a 2 or a diamond -flipping a coin 3 times and getting 0 heads -flipping a coin 3 times and getting at least 1 heads
A gambler has observed from experience that the probability of at least one six when rolling a fair die four times is slightly larger than the probability of at least one double six when rolling two fair dice 24 times. Do you agree? A clear explanation will be greatly appreciated.
3. Using excel create the sample space for two dice. 4. Find the following probabilities using the sample space your created in 3. a. P[sum is even] b. P[sum is odd] c. P[one die is even and one die is odd] d. P[one die is even or the sum is 5] (These last three deal with the probabilities of a craps game.) e. P[sum is 7 or 11] f. P[sum is 2, 3 or 12] g. P[sum is not 2,...
A peculiar die has the following properties: on any roll the probability of rolling either a 4, a 6, or a 5 is 1/2, just as it is with an ordinary die. Moreover, the probability of rolling either a 5, a 3, or a 2 is again 1/2. However, the probability of rolling a 5 is 7/16, not 1/6 as one would expect of an ordinary fair die. From what you know about this peculiar die, compute the following. The...
A peculiar die has the following properties: on any roll the probability of rolling either a 5, a 2, or a 3 is 5, just as it is with an ordinary die. Moreover, the probability of rolling either a 3, a 6, or a 4 is again . However, the probability of rolling a 3 is as one would expect of an ordinary fair die. From what you know about this peculiar die, compute the following. a. The probability of...
non
excel solution, please!
6. Suppose that a decision maker faced with four decision alternatives and four states of natuure develops the following profit payoff table. State of Nature Decision Alternative S3 10 14 d1 10 d2 10 10 d3 13 10 8 d4 If the decision maker knows nothing about the probabilities of the four states of nature, what is the recommended decision using the optimistic, conservative, and minimax regret approaches? ANSWERS: 1. D2 2. a) Al b) A2...