Question

Calculate the expected Value for Form Joint Venture Success Moderate Success Failure Probability Sell Company Form Joint Venture Sell Software on own Answer format: Number Round to 1 decimal places

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

STATS -Microsoft Excel (Product Activation Failed) Formulas File Home Insert Page Layout Data Review View Add-Ins Z AutoSum- Cut AC Wrap Text Calibri 11 General Copy Fill Merge & Center Paste 000 Conditional Format Cell Insert Delete Format Sort & Find & BIU % Format Painter Clear Filter Select Formatting as Table Styles Number Clipboard Font Alignment Styles Cells Editing fox EG52 ЕН ЕPР EF EG EH EJ EK EL EM EN EO EP EQ ER ES 35 36 37 38 39 40 EMV EXPECTED MONETARY VALUE 41 DEMAND SUCCESS MODERATE FAILURE 42 SUCCESS 43 PROBABILITY 0.3 0.3 0.4 EMV 44 EXPANSION 111 =$I 129.4 -SEH$43*EH46+$EI$43*E146+$EJ$43*EJ46 3*EH45+$EI$43*El45+$EJ$43*EJ45] 45 SELL COMPANY 111 111 111 46 FROM JV 210 120 76 199.3 SEH$43*EH47+$EI$43*E147+$EJ$43*EJ47] 47 SELL SOFTWARE ON OWN 420 111 100 48 49 50 ANSWER EXPECTED VALUE 129.4 51 FROM JV 52 53 HYPOTH assignment MATRIX Sheet2 COv TREND freq DEAR MEAN STDV PV FV DIVIDEND EMV TIME SERIES corr REGRESSION INTERVAL, NORMAL range CAMERA erences 130% W 13:19 ENG 03-11-2019