Question

In: Statistics and Probability

For the decision problem in Figure 6.1, use data tables to perform the following sensitivity analyses....

For the decision problem in Figure 6.1, use data tables to perform the following sensitivity analyses. The goal in each is to see whether decision 1 continues to have the largest EMV. In each part, provide a brief explanation of the results.

a. Let the payoff from the best outcome, the value in cell A3, vary from $30,000 to $50,000 in increments of $2500.

b. Let the probability of the worst outcome for the first decision, the value in cell B5, vary from 0.7 to 0.9 in increments of 0.025, and use formulas in cells B3 and B4 to ensure that they remain in the ratio 1 to 2 and the three probabilities for decision 1 continue to sum to 1.

c. Use a two-way data table to let the inputs in parts a and b vary simultaneously over the indicated ranges.

Please provide solution as per Excel.

Decision 1 Decision 2 Decision 3
Payoff/Cost Probability Payoff/Cost Probability Payoff/Cost Probability
$50,000 0.1 $5,000 0.6 $3,000 1
$10,000 0.2 -$1,000 0.4
-$5,000 0.7
EMV EMV EMV

Solutions

Expert Solution

The values are

Now select the data in cells A9 to B18. Chose data---> what if analysis--> data table

Select A3 in Column input cell

press ok and get the following results

Next select the range A9:B18 and chose data-->what if analysis--->data table

select B5 in the column input cell

Get the following

Get the following


Related Solutions

Preliminary data analyses indicates that use of a paired Wilcoxon signed-rank test is reasonable. Perform the...
Preliminary data analyses indicates that use of a paired Wilcoxon signed-rank test is reasonable. Perform the hypothesis test by using a paired Wilcoxon signed-rank test. Assume that the null hypothesis is Ho:u1=u2 In a study of the effectiveness of physical exercise in weight reduction, 12 subjects followed a program of physical exercise for two months. Their weights (in pounds) before and after this program are shown in the following table.    before 162 190 188 152 148 127 195 164...
Use Excel to perform various analyses and generate graphs, charts and plots of the following activities:...
Use Excel to perform various analyses and generate graphs, charts and plots of the following activities: generate frequency tables; produce bar graphs, pie charts, line charts, and scatter plots; calculate mean, median, and mode, standard deviation, standard scores, and normal distribution percentiles.
Why perform sensitivity analysis? Of what use is sensitivity analysis where good probability estimates are difficult...
Why perform sensitivity analysis? Of what use is sensitivity analysis where good probability estimates are difficult to obtain?
Use MATLAB to figure out the following problem, if you do not know how to use...
Use MATLAB to figure out the following problem, if you do not know how to use MATLAB then please do not answer. Coding is required for the exercise. For f(x) = arctan(x), find its zeros by implimenting Newtons method and the Secant method in Matlab. (Hint: Use Newtons method to calculate x1 for Secant method) Comment all code please since I would like to learn how to do this correctly in MATLAB. Thank you.
Use the Hungarian Method to solve the following Assignment Problem. Consider the following management decision problem:...
Use the Hungarian Method to solve the following Assignment Problem. Consider the following management decision problem: you have 4 employees E1, E2, E3, and E4 that must be reassigned to new jobs J1, J2, J3, and J4 (which they can all "sort of" do, with different training and quality costs) - and you must decide which employee should do which job (i.e., you need to make an assignment which has the least total cost for the company). Below is the...
Using the below sensitivity report, answer the following questions: SENSITIVITY REPORT ANALYSIS PROBLEM
Using the below sensitivity report, answer the following questions:SENSITIVITY REPORT ANALYSIS PROBLEM  a. If this is a LP product mix problem report, how many units of each product should be produced?b. If one unit of French is force produced, what will happen to the Objective Function value?c. The Caribbean’s Objective Coefficient is increased to 80. How will the new Objective Function value be determined? d. Which constraints are binding?e. If Finishing is decreased by one unit, how will the Objective...
1. Perform sensitivity analysis on the following project by first finding the NPV for the base...
1. Perform sensitivity analysis on the following project by first finding the NPV for the base case, then for a 10% decline in quantity sold and a 10% increase in quantity sold.       Investment = $270,000 Straight line depreciation                                      over 3 years       quantity sold per year = 20,000       Price per unit = $20       Operating Cost = $10 per unit (all variable)       Tax rate 25%   cost of capital 10%       Project will have a 3-year life...
Using the data below, perform descriptive statistics analyses (mean, standard deviation, variance) for scores from the...
Using the data below, perform descriptive statistics analyses (mean, standard deviation, variance) for scores from the two class periods. Then,determine if there is a significant difference between the two sets of exam scores by performing an independent t test. Lastly, write a paragraph to convey the findings, using APA format. The number would not align as I like but Third Period Scores are as follow: 84, 92,,98,76,80,90,70,94,100,94,98,88,90,92,88,76,80,92 and 88 Sixth Period Scores: 80,90,82,78,72,80,70,86,80,88,70,86,68,76,90,82,70,84, and 84 Please write legible to understand...
Using the data below, perform descriptive statistics analyses (mean, standard deviation, variance) for the brothers’ test....
Using the data below, perform descriptive statistics analyses (mean, standard deviation, variance) for the brothers’ test. Then, perform an Analysis of Variance (ANOVA) to determine if there is a significant difference between the brothers’ scores. Note: You may use Excel on your own or make an appointment to perform the test in SPSS Test Chapter 1, 2, 3&4 5 6 7 8&9 10 11&12 13 14 Chapter 1, 2, 3&4, 5, 6, 7, 8&9, 10, 11&12, 13, 14 (Jim) 85,...
Use the tables for the following problem. Maya wants to buy her first home in six...
Use the tables for the following problem. Maya wants to buy her first home in six years.  Maya plans to save $4,000 per year out of her annual bonus at the end of the year. Her savings account, which is compounded annually, earns an annual rate of 6%.  How much will Maya have for her down payment? Table ________________ Row _________________ Column (rate) _________ Factor _______________ Future Value ___________ -------------------------------------------------------------------------------------------------------------- Camden’s Antiques, Inc. just added a whole new line of furniture to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT