How do I discount 10% off of box # 2 and 5%off box #3 in the expected value colu

Question

How do I discount 10% off of box # 2 and 5%off box #3 in the expected value column . Please show formula.

AutoSave ofr excel spreadsheet-pilot Excel SHAMICA.BENJAMIN File Home Insert Page Layout Formulas DataReviewView Tell me what you want to do Share Le Online Pictures Equation Symbol PivotTable Recommended Table Pictures Maps PivotChart 3D Line Column Win/ Slicer Timeline Link Text My Ad-insRecommended l- PivotTables Icons Charts Map Tables Illustrations Charts Tours Sparklines Filters Links Symbols 7 Purchase Occasion Transition ProbabilityAverage Basket Size Actual Probability of Purchase Expected Value 100% 100% 100% Transition Probabilities Pilot Study Data Pilot Transition Probabilities . + 100% 809 PM Type here to search ^ E@411/5/2017

Explanation / Answer

Multiply 68% with .10. subtract the value you got from 68%. 68*.10= 6.8% . 68-6.8 = 61.2

similarly .05*49.51 = 2.4755. now substract 49.51-2.4755= 47.0325

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.