1. Multiattribute utility theory (Excel) 10pts You are thinking of going on a holiday and trying...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Multiattribute utility theory (Excel) 10pts You are thinking of going on a holiday and trying to find the best holiday destination. Basing on three attributes, you will first build the additive multiattribute model u(x1, x2, x3) = wu (xi) i=1 and then use it to systematically evaluate the goodness of each destination. The attributes for your decision problem are The number of possible activities (i = 1), Safety for tourists (i = 2), and Distance from where you live (i = 3). The measurement scales of attributes i = 1,2,3 are [1, 5], {satisfactory, good, very good, excellent}, and [0 km, 3000 km], respectively. The attribute specific utilities are given as follows: Attribute i = 1 has a linear increasing attribute-specific utility function (the more activities the better) Attribute 2 has the utilities u (satisfactory) = 0, u (good) = 0.5, u (very good) = 0.75, u (excellent) = 1 For attribute i = 3 you'll go through the following internal dialogue: To maximise the exoticism of my holiday and follower engagement on social media, I want the destination to be far away rather than near Then if I have two destinations A and B that are equally preferred on attributes 1 and 2, and distance for A is uncertain with 50-50 chance of being either 0 or 3000 km, then what would be a certain distance for B so that A and B are equally preferred? o That would have to be around 1000 km... Nah, this is too hard to think through, let me just use a piecewise linear utility function that is consistent with x3 = 1000 a) Implement the utility functions U1, U2, U3 on the answer template file. Scale the utilities so that most preferred performance level gets attribute-specific utility of one and the least preferred performance level the utility of zero. Check that your model is correct up to this step by inputting an alternative xcheck = (4, good, 2100) that should give attribute-specific utilities of 0.75, 0.5, and 0.775, respectively. Then you start thinking about the relative importance of each attribute, i.e. the attribute weights. You make internally the following two observations about your preferences: If there are two destinations C and D that have outcomes xc = (5,satisfactory, 3000) and x = (x,excellent, 3000), you would think that a level of x = 2 would make C and D equally preferred If there are two destinations E and F with outcomes x = (3,satisfactory, 3000) and xF (3,excellent, 0), then E and F would be equally desirable for you. = b) Estimate attribute weights W, W2, W3 so that they sum to one and implement the overall utility function on the answer template. The alternative x check = (4, good, 21) should give a total utility of 0.6825. c) Compute the expected utilities for the following three alternatives using your model: Alternative Number of activities Reykjavik 4 Prague Tbilisi 3 5 Safety excellent very good satisfactory, 0.4; good, 0.6 Distance (km) 1500 1600 2900 Note: the Safety rating for 'Tbilisi' is random and depending on geopolitical uncertainties. The outcomes are: rating = satisfactory with probability 0.4, otherwise rating = good. Motivation: A practical exercise on constructing the MAUT model. A B C D E F 1 Note: please use only the green coloured cells for your answer input, do not add, merge, or delete cells or rows 123 10 11 12 13 45698020723 Alternative Number of activities Reykjavik 4 3 Tbilisi 5 Safety excellent 1500 SAT Prague very good 1600 Distance (km) (satisfactory,.4; good,.6) 2900 G H J K L M N a) Attribute specific utilities u1(4,good,2100) u2(4,good,2100)| u3(4,good,2100)| b) Attribute weights w1 w2 W3 c) Expected total utilities Reykjavik Prague Tbilisi P 1. Multiattribute utility theory (Excel) 10pts You are thinking of going on a holiday and trying to find the best holiday destination. Basing on three attributes, you will first build the additive multiattribute model u(x1, x2, x3) = wu (xi) i=1 and then use it to systematically evaluate the goodness of each destination. The attributes for your decision problem are The number of possible activities (i = 1), Safety for tourists (i = 2), and Distance from where you live (i = 3). The measurement scales of attributes i = 1,2,3 are [1, 5], {satisfactory, good, very good, excellent}, and [0 km, 3000 km], respectively. The attribute specific utilities are given as follows: Attribute i = 1 has a linear increasing attribute-specific utility function (the more activities the better) Attribute 2 has the utilities u (satisfactory) = 0, u (good) = 0.5, u (very good) = 0.75, u (excellent) = 1 For attribute i = 3 you'll go through the following internal dialogue: To maximise the exoticism of my holiday and follower engagement on social media, I want the destination to be far away rather than near Then if I have two destinations A and B that are equally preferred on attributes 1 and 2, and distance for A is uncertain with 50-50 chance of being either 0 or 3000 km, then what would be a certain distance for B so that A and B are equally preferred? o That would have to be around 1000 km... Nah, this is too hard to think through, let me just use a piecewise linear utility function that is consistent with x3 = 1000 a) Implement the utility functions U1, U2, U3 on the answer template file. Scale the utilities so that most preferred performance level gets attribute-specific utility of one and the least preferred performance level the utility of zero. Check that your model is correct up to this step by inputting an alternative xcheck = (4, good, 2100) that should give attribute-specific utilities of 0.75, 0.5, and 0.775, respectively. Then you start thinking about the relative importance of each attribute, i.e. the attribute weights. You make internally the following two observations about your preferences: If there are two destinations C and D that have outcomes xc = (5,satisfactory, 3000) and x = (x,excellent, 3000), you would think that a level of x = 2 would make C and D equally preferred If there are two destinations E and F with outcomes x = (3,satisfactory, 3000) and xF (3,excellent, 0), then E and F would be equally desirable for you. = b) Estimate attribute weights W, W2, W3 so that they sum to one and implement the overall utility function on the answer template. The alternative x check = (4, good, 21) should give a total utility of 0.6825. c) Compute the expected utilities for the following three alternatives using your model: Alternative Number of activities Reykjavik 4 Prague Tbilisi 3 5 Safety excellent very good satisfactory, 0.4; good, 0.6 Distance (km) 1500 1600 2900 Note: the Safety rating for 'Tbilisi' is random and depending on geopolitical uncertainties. The outcomes are: rating = satisfactory with probability 0.4, otherwise rating = good. Motivation: A practical exercise on constructing the MAUT model. A B C D E F 1 Note: please use only the green coloured cells for your answer input, do not add, merge, or delete cells or rows 123 10 11 12 13 45698020723 Alternative Number of activities Reykjavik 4 3 Tbilisi 5 Safety excellent 1500 SAT Prague very good 1600 Distance (km) (satisfactory,.4; good,.6) 2900 G H J K L M N a) Attribute specific utilities u1(4,good,2100) u2(4,good,2100)| u3(4,good,2100)| b) Attribute weights w1 w2 W3 c) Expected total utilities Reykjavik Prague Tbilisi P
Expert Answer:
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
PLEASE GIVE CORRECT ANSWERS Prove that the number of comparators in any sorting network is (n log n). [4 marks] (ii) What does Part (d)(i) imply in terms of the depth of any sorting network? [1 mark]...
-
A paper recycling company converts newspaper, mixed paper, white office paper, and cardboard into pulp for newsprint, packaging paper, and print stock quality paper. The following table summarizes...
-
If the expected default rate on a particular mortgage-backed security is 4 percent per year, and the corresponding Treasury security carries a 3 percent annual interest rate, what should be the...
-
1) Compare the variables in the Binomial model with those in the black-schooled model. Discuss which ones differ between the two models. Explain how this variable is presented in the each of these...
-
Suppose that \(v_{1}, v_{2}, \ldots, v_{n}\) are positive numbers. The arithmetic mean and the geometric mean of these numbers are, respectively, (a) It is always true that \(v_{A} \geq v_{G}\)....
-
Comparative income statements and balance sheets for Best Buy are shown below ($ millions). Required: a. Use the following ratios to prepare a projected income statement, balance sheet, and statement...
-
= = = Standard Income Statement Financial Statements in CAD Dollars Using the numbers from the two income statements, fill in the percentages calculated for the common-sized vertical analysis, then...
-
Name of Experiment: Spectrophotometry of a two- component mixture: Determination of CO and Ni as EDTA complexes. Q1: Purpose of experiment Q2: Introduction
-
1. What method are you using to track your daily spending? If you using an app, what app are you using? 2. Is your chosen method "working" for you? In other words, are you tracking your spending each...
-
How will an analyst assess the financial strength of a company using ratios? Give an example of a publicly traded company and assess three to five financial ratios.
-
How do modern batch processing architectures integrate with cloud-native technologies and containerization frameworks to facilitate resource provisioning, deployment scalability, and workload...
-
What role does data locality optimization play in enhancing the performance of batch processing jobs, and how do techniques such as data partitioning and co-location influence data access patterns...
-
Could you discuss the role of fault tolerance mechanisms such as checkpointing and task replication in mitigating job failures and ensuring data integrity within large-scale batch processing...
-
The Assembly Department of Smart Computers incurred $250,000 in direct materials and $75,000 in conversion costs. The equivalent units of production for direct materials and conversion costs are...
-
Suppose the index goes to 18 percent in year 5. What is the effective cost of the unrestricted ARM?
-
For fluids with \(\operatorname{Pr} <1\) the velocity profile is assumed to be a cubic for \(y
-
Consider the flat-plate heat transfer to be solved by the similarity approach. Show all the details leading to Eq. (18.15). What are the boundary conditions on \(\theta\) ? Extend your MATLAB code to...
-
Show all the steps leading to the integral balance equation (18.6) in the text. Use the following boundary conditions and verify Eq. (18.7). (i) At \(y=0, T=T_{\mathrm{S}}\). (ii) At...
Study smarter with the SolutionInn App