Question: Solve using Excel ( please show each step and show all operation used in excel ) Thank you S1-22. The director of career advising at
Solve using Excel ( please show each step and show all operation used in excel ) Thank you

S1-22. The director of career advising at Grand Valley Commu- nity College wants to use decision analysis to provide in- formation to help students decide which two-year degree program they should pursue. The director has set up the following payoff table for six of the most popular and suc- cessful degree programs at GVCC that shows the estimated five-year gross income ($) from each degree for four future economic conditions: Degree Program Graphic Design Nursing Real Estate Medical Technology Culinary Technology Computer Information Technology Economic Conditions Recession Average Good Robust 115,000 155,000 190,000 220,000 140,000 175,000 210,000 225,000 95,000 135,000 230,000 350,000 120,000 180,000 210,000 270,000 85,000 125,000 180,000 290,000 125,000 160,000 200,000 260,000 Determine the best degree program in terms of projected income, using the following decision criteria: a. Maximax b. Maximin c. Equal likelihood d. Hurwicz (a = .25)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
