Question Description
I’m working on a Statistics question and need guidance to help me study.
Decision Analysis": Exercises 22.2 and 22.11
Write your answers in a Microsoft Excel workbook, with each problem on a separate worksheet. Label each tab in the workbook with the exercise number. Highlight the answers in yellow and provide an interpretation in a text box.
 22.1 Set up the opportunity loss table from the following payoff table:
a _{1} 
a _{2} 

s _{1} 
55 
26 
s _{2} 
43 
38 
s _{3} 
29 
43 
s _{4} 
15 
51 
 22.2 Draw the decision tree for Exercise 22.1.
22.11 The owner of a clothing store must decide how many men's shirts to order for the new season. For a particular type of shirt, she must order in quantities of 100 shirts. If she orders 100 shirts, her cost is $10 per shirt; if she orders 200 shirts, her cost is $9 per shirt; and if she orders 300 or more shirts, her cost is $8.50 per shirt. Her selling price for the shirt is $12, but any shirts that remain unsold at the end of the season are sold at her famous "halfprice, endofseason sale.” For the sake of simplicity, she is willing to assume that the demand for this type of shirt will be 100, 150, 200, or 250 shirts. Of course, she cannot sell more shirts than she stocks. She is also willing to assume that she will suffer no loss of goodwill among her customers if she understocks and the customers cannot buy all the shirts they want. Furthermore, she must place her order today for the entire season; she cannot wait to see how the demand is running for this type of shirt.
a. Construct the payoff table to help the owner decide how many shirts to order.
b. Set up the opportunity loss table.
c. Draw the decision tree.
Final Answer
Brown University
1271 Tutors
California Institute of Technology
2131 Tutors
Carnegie Mellon University
982 Tutors
Columbia University
1256 Tutors
Dartmouth University
2113 Tutors
Emory University
2279 Tutors
Harvard University
599 Tutors
Massachusetts Institute of Technology
2319 Tutors
New York University
1645 Tutors
Notre Dam University
1911 Tutors
Oklahoma University
2122 Tutors
Pennsylvania State University
932 Tutors
Princeton University
1211 Tutors
Stanford University
983 Tutors
University of California
1282 Tutors
Oxford University
123 Tutors
Yale University
2325 Tutors