Analysis Data and prepare for some Financial table

profileCaesarNick
Assignment2Database.xlsx

Sheet1

Alternatives Optimistic Conditions Realistic Conditions Pessimistic Conditions
Apartment Building 430000 350000 -110000
Office Building 260000 150000 -240000
Warehouse 360000 220000 -140000
Probability 0.35 0.51 0.14
Fee for Survey 13000
Probability of survey results positive 0.58
Probability of survey results negative 0.42
If the analysis report results positive Optimistic Conditions Realistic Conditions Pessimistic Conditions
probability 0.67 0.21 0.12
If the analysis report results negative Optimistic Conditions Realistic Conditions Pessimistic Conditions
probability 0.11 0.31 0.58