Create a fact table of your decision situation. Your fact table – as all your other decision tables – should have your values (criteria) as column headers, and your alternatives as row headers.

Heads-up: Note for Task 4 in this worksheet

You’ll need to upload your decision-table in a separate spreadsheet document (e.g., Excel or google docs spreadsheet). Important: Please make sure that all the formula you used for calculations are maintained in the spreadsheet you submit, and still visible for me if I double-click on a cell. You will not get full points on your table if this is not the case! The reasons why I want you to use formula functions in your tables (rather than do the calculations in your head or with a calculator) are: – It is otherwise impossible for me to see of you did indeed do the correct calculations (or just got to the correct solution by chance). – It will make the activity for next week (sensitivity analysis) a lot easier. – Once you have a table with the correct formula, you can save it as a template, and can very easily apply it to all kinds of decisions in your future. This will make things a lot easier than starting over each time, and will make it more likely that you actually use these tools in the future.

If you are unfamiliar with how to set up formulas in spreadsheets, I will be happy to help in person – just get in touch. Otherwise, you may find help from other people, from the Internet or from the program (help menu or manual) itself. I do believe that knowing how to use functions and formulas in spreadsheets is a really good basic skill to have, and the formulas we will be using are all very simple, so I encourage you to take this opportunity to learn it.

1. Fact Table [5 points]

Create a fact table of your decision situation. Your fact table – as all your other decision tables – should have your values (criteria) as column headers, and your alternatives as row headers. Your columns should reflect your final values, one value for each column. Your value set should fulfill the criteria in the book. Your rows should reflect your alternatives, one alternative for each column. Include at least three alternatives. (Hopefully last week’s exercises have helped you to come up with some new ones.) Once you have that basic structure, fill your fact table with what you consider realistic ranges of possible outcomes in each cell. Upload your fact table here (the document can be an image, table, spreadsheet, whatever you prefer). *

ADD FILE

2. Plusses-and-minuses Tables: Your General Knowledge and Understanding of the Concepts [5 points]

https://lh3.googleusercontent.com/HfMOxJ-qcyfcN1O1t3P1jCK_2wsMaDGglWc1Jb7BSEIXgFou-oGDRiAQnW5fMT_Wo8hiqYgP_A=w740

2.a) The table above shows an abstract example of a decision situation. According to the definition of dominance in the book, does any of the alternatives dominate all others in this table? If so, which one? [1pt]

Your answer

2.b) Is any of the alternatives dominated by all others in the table above? If so, which one? [1pt]

Your answer

2.c) Are there any pairs of alternatives in the table above (if you compare only two at a time) in which one dominates the other? Which one(s)? [2 pts]

Your answer

2.d) Are any of the values in the table above irrelevant according the criteria in the book? Explain why or why not. [1 pt]

Your answer

3. Your Own Plusses-and-minuses Table [6 points]

3.a) Create a plusses-and-minuses table for your own decision, using the same headers for rows and columns as for your fact table above. Upload it here (the document can be an image, table, spreadsheet, whatever you prefer). [4 pts]

ADD FILE

3.b) Do you have a dominating or dominated alternative in your own table? Which one, and why? [1 pt] *

Your answer

3.c) Would any of your values be irrelevant according to your table and the criteria in the book? Explain why or why not. [1 pts]

Your answer

4. 1-to-10 Weighted Table [10 pts]

4.a) Create a 1-to-10 Table of your own decision situation as a google spreadsheet, including weights and final scores (again using the same headers for rows and columns as for your fact fable above). Include both the raw ratings and the weighted ratings. Please give me (ursina@pdx.edu) editing privileges to the document, so that I can see the formula/functions you used to calculate the weighted ratings and final scores. If you prefer to work in a different spreadsheet program, such as excel, you can just upload the file to your google drive when you’re finished, and convert it into a google spreadsheet at that point. Please note that if you upload a file in a non-spreadsheet format (image, pdf, doc, etc), or if I can otherwise not see your calculations as functions, you will not get full points. [6 pts]

ADD FILE

4.b) Why did you choose this particular weight for each value? [1 pt]

Your answer

4.c) Which alternative was the “winner”? [1 pt]

Your answer

4.d) How do you feel about this result? Does it match up with your intuition? If not, what do you think could be the reason? Can you think of any additional value you may have overlooked? [2 pts]

Your answer

5. Review [4 points]

Up to this point in the class, which decision tools have been most helpful to you, and why? What were things that you learned about decision-making so far that you think are important, or that you think may be helpful in the future (for example the next time you are faced with an important decision, or are asked for advice by somebody who is making a difficult decision)? [4 pts]

 

"Is this question part of your assignment? We Can Help!"