| SNHU: DAT-520 Problem Set 5 | Dustin's research |
| Biz | positive (YR) | negative (NR) | MARGINAL PROB |
| Viable (YV) | P(YV&YR) | P(YV&NR) | P(YV) | | | | | | | | | | | | | Viable (YV) |
| Not viable (NV) | P(NV&YR) | P(NV&NR) | P(NV) | | | | | | | | | | | | | | | | | | | | $0 |
| MARGINAL PROB | P(YR) | P(NR) | 1 | | | | | | | | | Buy | | | | | $0 |
| Values given in the story problem setup (fill in the blue cells, and the cell for X%): | | | | | | | | | | | | | ERROR:#N/A |
| | positive (YR) | negative (NR) | MARGINAL PROB | | | | | | | | | | | | | Not viable (NV) |
| Viable (YV) | | | X% | | | | | No research | | | | | | | | | | | | | | | $0 |
| Not viable (NV) | | | | | | | | | | ERROR:#N/A | | | | | | | $0 |
| MARGINAL PROB | | | 1 | | | | | | ERROR:#N/A |
| P(YR|YV)= | 60% | P(NR|YV)= | | | | | | | | | | Don't buy |
| P(YR|NV)= | | P(NR|NV)= | 70% | | | | | | | | | | | | | | | | | | | | 0 |
| | | | | | | | | | | | | | 0 |
| Conditional Probabilities: |
| P(YV|YR)= | | P(NV|YR)= |
| P(YV|NR)= | | P(NV|NR)= | | | | | | | | | | | | | | | | | | Viable (YV) |
| | | | | | | | | | | | | | | | | | | | | | | | $0 |
| Cost of research | | | | Buy Biz with or without research? | | | | | | | | | | | | Buy | | | | | $0 |
| | | | | | | ERROR:#N/A |
| Cost of business | | | | Rollback EV: | ERROR:#N/A | | | | | | | | | | | | ERROR:#N/A |
| Cost of refurb on purhcase | | | | | | | | | | | | | | | | | | | | Not viable (NV) |
| Total cost of purchase | $0 | | | | | | | | | | | Positive research (YR) | | | | | | | | | | | $0 |
| | | | | | | | | | | | | | | ERROR:#N/A | | | | | | | $0 |
| Potential payout | | | | | | | | | | | | 0 | ERROR:#N/A |
| | | | | | | | | | | | | | | | | Don't buy |
| | | | | | | | | | | | | | | | | | | | | | | | $0 |
| | | | | | | | | | | | | | | | | | $0 |
| | | | | | | | | Research |
| | | | | | | | | | ERROR:#N/A | | | | | | | | | | | Viable (YV) |
| | | | | | | | | | | | | | | | | | | | | | | | $0 |
| | | | | | | | | | | | | | | | | Buy | | | | | $0 |
| | | | | | | | | | | | | | | | | | ERROR:#N/A |
| | | | | | | | | | | | | | | | | | | | | Not viable (NV) |
| | | | | | | | | | | | | Negative research (NR) | | | | | | | | | | | $0 |
| | | | | | | | | | | | | | | ERROR:#N/A | | | | | | | $0 |
| | | | | | | | | | | | | 0 | ERROR:#N/A |
| | | | | | | | | | | | | | | | | Don't buy |
| | | | | | | | | | | | | | | | | | | | | | | | $0 |
| | | | | | | | | | | | | | | | | | $0 |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ID | Name | Value | Prob | Pred | Kind | NS | S1 | S2 | S3 | S4 | S5 | Row | Col | Mark |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0 | TreePlan | 0 | 0 | 0 | D | 2 | 1 | 2 | 0 | 0 | 0 | 19 | 1 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | | | 0 | 0 | D | 2 | 3 | 4 | 0 | 0 | 0 | 8 | 5 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 2 | | | 0 | 0 | E | 2 | 7 | 8 | 0 | 0 | 0 | 30 | 5 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 3 | | | 0 | 1 | E | 2 | 5 | 6 | 0 | 0 | 0 | 4 | 9 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 4 | | | 0 | 1 | T | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 9 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 5 | | | | 3 | T | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 13 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 6 | | | | 3 | T | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 13 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 7 | | | | 2 | D | 2 | 9 | 10 | 0 | 0 | 0 | 23 | 9 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 8 | | | | 2 | D | 2 | 13 | 14 | 0 | 0 | 0 | 38 | 9 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 9 | | | 0 | 7 | E | 2 | 11 | 12 | 0 | 0 | 0 | 19 | 13 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 10 | | | 0 | 7 | T | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 13 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 11 | | | | 9 | T | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 17 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 12 | | | | 9 | T | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 17 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 13 | | | 0 | 8 | E | 2 | 15 | 16 | 0 | 0 | 0 | 34 | 13 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 14 | | | 0 | 8 | T | 0 | 0 | 0 | 0 | 0 | 0 | 42 | 13 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 15 | | | | 13 | T | 0 | 0 | 0 | 0 | 0 | 0 | 32 | 17 | TRUE |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 16 | | | | 13 | T | 0 | 0 | 0 | 0 | 0 | 0 | 37 | 17 | TRUE |