Generating random variates in Excel I am very confused with a question I have found in relation to Excel. I am hoping someone can help me do this or at-least give me direction in which I can figure out how to do this. So far I don't even know where to get started.


By Linearity of Expectation 
$E(W) = 3\times E(U) - 2\times E(D) + 4\times E(N) \times E(B)$
Mean of Uniform Distribution $= \frac{(a+b)}{2}$, for $E(U) = \frac{(2+4)}{2} = 4$
$E(D) = \frac{(3+7)}{2} = 5$
Mean of a Normal = Mean $= 3.5$ 
Mean of a Bernoulli = $p = 0.65$
Putting all together $E(W) = 3\times4 - 2\times 5 + 4\times 3.5\times 0.65 = 11.1$
Your simulation of 100 samples of W should average to somewhere close to 11.1
Attached you will see the set up in EXCEL with formulas to get it in the top most row.
Copy those formulas 100 times and draw the graph and compute average as below.


