Find an expected value in Excel Step 1: Type your values into two columns in Excel (“x” in one. 6. Calculate the sum of the products. Add together the six probability- value calculations to find the. Yes, that is fine for the expected value. Then find the expected value of Y2 in similar fashion. Use the two expectations to get the variance.